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 | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| AcceptFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| ApproveComment | Approves a comment |
| AssignDefaultAddress | Assign a default address to a customer. |
| CalculateRefund | Calculates refund transactions based on line items and shipping. |
| ChangeSpamStatus | Changes spam status of a comment |
| CompleteDraftOrder | Complete a draft order. |
| CreateAccountActivationUrl | Creates an account activation URL for the specified customer. |
| RejectCancellationRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| RejectFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| RestoreComment | Restores a previously removed comment |
| SendCancellationRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| SendFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| SendInvite | Send a default or customized invite to a customer. |
| SendInvoice | Send a default or customized invoice to a customer. |
| UpdateQuantity | Update the available quantity of inventory items for a product variant in a specific location. |