Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver 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 ODBC Driver 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.
CollectionReorder	Reorders a set of products within a specified collection.
CompanyContactRemoveFromCompany	Removes a company contact from a Company.
FulfillmentOrderMerge	Merges a set or multiple sets of fulfillment orders together into one based on line item inputs and quantities.
FulfillmentOrderSplit	Splits a fulfillment order or orders based on line item inputs and quantities.
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.
OrderCancel	Cancels an order.
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.