Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Shopify.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Shopify, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Shopify Stored Procedures
| Name | Description |
| AcceptCancellationRequest | Accepts a cancellation request sent to a fulfillment service for a fulfillment order. |
| AcceptFulfillmentRequest | Accepts a fulfillment request sent to a fulfillment service for a fulfillment order. |
| ApproveComment | Approves a blog comment so it becomes publicly visible. |
| CollectionReorder | Reorders products within a collection to control storefront merchandising. |
| CompanyContactRemoveFromCompany | Removes a contact from a specified business-to-business (B2B) company. |
| CreateFile | Creates file assets from an external URL or finalizes previously staged uploads. |
| EnableStandardMetafieldDefinition | Enables a standard metafield definition from a provided template. |
| FulfillmentOrderMerge | Merges one or more fulfillment orders into a single order based on line item inputs and quantities. |
| FulfillmentOrderSplit | Splits a fulfillment order into multiple orders based on line item inputs and quantities. |
| InventoryAdjustQuantities | Applies relative changes to inventory quantities for specified items. |
| InventoryBulkToggleActivation | Activates or deactivates inventory items at selected locations to control eligibility for stocking. |
| InventoryMoveQuantities | Moves quantities between inventory quantity names (for example, available or reserved) within a location. |
| InventorySetQuantities | Sets absolute inventory quantities for specified quantity names at a location. |
| InventorySetScheduledChanges | Schedules future inventory level changes for specified items and locations. |
| MarkCommentNotSpam | Marks a comment as not spam to restore normal visibility. |
| MarkCommentSpam | Marks a comment as spam to hide it from public view. |
| OrderCancel | Cancels an order and optionally restocks items and notifies the customer. |
| OrderCreateManualPayment | Creates a manual payment for an order. |
| PublishTheme | Publishes a theme to make it the live storefront theme. |
| RejectCancellationRequest | Rejects a cancellation request sent to a fulfillment service for a fulfillment order. |
| RejectFulfillmentRequest | Rejects a fulfillment request sent to a fulfillment service for a fulfillment order. |
| SendCancellationRequest | Sends a cancellation request to the fulfillment service of a fulfillment order. |
| SendFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| TransactionVoid | Voids an uncaptured authorization transaction so it can no longer be captured. |
| UpdateFile | Updates metadata or properties of an existing uploaded file asset. |