Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server 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 MCP Server 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. |