Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider 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 ADO.NET Provider 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. |
| AppSubscriptionTrialExtend | Extends the trial of an app subscription. |
| 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. |
| CustomerGenerateActivationUrl | Generates a URL for activating a customer account. |
| CustomerSegmentMembersQueryCreate | Creates a customer segment members query. |
| CustomerSendAccountInviteEmail | Sends an account invite email to a customer. |
| DiscountCodeRedeemCodeBulkDelete | Asynchronously delete discount codes in bulk. |
| DiscountRedeemCodeBulkAdd | Asynchronously adds discount codes in bulk to a code discount. Maximum: 250 codes per call. |
| DraftOrderComplete | Completes a draft order and creates an order. |
| DraftOrderInvoiceSend | Sends an email invoice for a draft order. |
| EnableStandardMetafieldDefinition | Enables a standard metafield definition from a provided template. |
| FulfillmentCancel | Cancels an existing Fulfillment and reverses its effects on associated FulfillmentOrder objects. When you cancel a fulfillment, the system creates new fulfillment orders for the cancelled items so they can be fulfilled again. |
| FulfillmentOrderHold | Applies a hold on a fulfillment order to pause fulfillment. |
| FulfillmentOrderMerge | Merges one or more fulfillment orders into a single order based on line item inputs and quantities. |
| FulfillmentOrderMove | Moves a fulfillment order to a new location. |
| FulfillmentOrderReleaseHold | Releases the fulfillment hold on a fulfillment order. |
| FulfillmentOrderSplit | Splits a fulfillment order into multiple orders based on line item inputs and quantities. |
| FulfillmentOrdersReroute | Route the fulfillment orders to an alternative location, according to the shop's order routing settings. |
| 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. |
| 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. |
| MarketingEngagementCreate | Creates a marketing engagement for a marketing activity. |
| OrderCancel | Cancels an order and optionally restocks items and notifies the customer. |
| OrderCreateManualPayment | Creates a manual payment for an order. |
| OrderSuggestRefund | Retrieves a suggested refund for an order based on line items, duties, shipping, and the refund method allocation. |
| 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. |
| ThemeDuplicate | Duplicates a theme. |
| ThemeFilesCopy | Copies files within a theme, overwriting existing destination files. |
| TransactionVoid | Voids an uncaptured authorization transaction so it can no longer be captured. |
| UpdateFile | Updates metadata or properties of an existing uploaded file asset. |