Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector 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 Python Connector for Shopify Stored Procedures
| Name | Description |
| AcceptCancellationRequest | Accepts a customer's cancellation request and notifies the assigned fulfillment service to halt fulfillment processing. |
| AcceptFulfillmentRequest | Approves a pending fulfillment request and authorizes the fulfillment service to ship the associated order. |
| ApproveComment | Marks a blog comment as approved, making it publicly visible on the storefront. |
| AssignDefaultAddress | Assigns a customer's selected address as the default shipping and billing address in their profile. |
| CalculateRefund | Calculates refund amounts for order line items and shipping, returning a breakdown of refundable totals. |
| ChangeSpamStatus | Updates a comment's spam status, toggling between spam and non-spam classification. |
| CompleteDraftOrder | Finalizes a draft order and converts it into a completed order ready for checkout and fulfillment. |
| CreateAccountActivationUrl | Generates a secure URL that allows a customer to activate their online store account. |
| GetOAuthAccessToken | Gets an authentication token from Shopify. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RejectCancellationRequest | Rejects a cancellation request and informs the fulfillment service to continue processing the fulfillment order. |
| RejectFulfillmentRequest | Declines a fulfillment request from a fulfillment service, optionally providing a rejection reason. |
| RestoreComment | Restores a comment that was previously deleted or marked as removed. |
| SendCancellationRequest | Submits a request to cancel an order or fulfillment to the assigned fulfillment service. |
| SendFulfillmentRequest | Sends a request to initiate fulfillment for a specific order or order line items. |
| SendInvite | Sends an account invitation email to a customer, with optional custom messaging. |
| SendInvoice | Emails a draft order invoice to a customer, allowing them to complete payment via checkout. |
| UpdateQuantity | Updates available inventory quantities for a specific product variant at a designated location. |