ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Shopify の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにShopify から関連するレスポンスデータを返します。
CData Excel Add-In for Shopify ストアドプロシージャ
| Name | Description |
| AcceptCancellationRequest | Approves and processes a cancellation request for a fulfillment order, notifying the related fulfillment service. |
| AcceptFulfillmentRequest | Approves a fulfillment request and instructs the assigned fulfillment service to begin order processing. |
| ApproveComment | Marks a pending blog comment as approved, making it visible on the storefront. |
| CollectionReorder | Reorders products within a specific collection based on the provided order of product IDs. |
| CompanyContactRemoveFromCompany | Removes a contact from a company record, revoking associated company-level permissions. |
| CreateFile | Uploads or registers a file asset in Shopify using an external URL or a staged upload reference. |
| EnableStandardMetafieldDefinition | Activates a standard metafield definition from a predefined template for consistent data structuring. |
| FulfillmentOrderMerge | Merges multiple fulfillment orders into a single order based on specified line item and quantity inputs. |
| FulfillmentOrderSplit | Splits an existing fulfillment order into separate orders according to specified line items 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. |
| InventoryAdjustQuantities | Applies relative adjustments to inventory quantities at one or more locations. |
| InventoryBulkToggleActivation | Activates or deactivates inventory items across multiple locations, determining where they can be stocked or sold. |
| InventoryMoveQuantities | Moves available inventory quantities between inventory states or bins within the same location. |
| InventorySetQuantities | Sets absolute inventory quantities for specific items, overwriting existing values. |
| InventorySetScheduledChanges | Schedules future changes to inventory levels, allowing time-based stock updates. |
| MarkCommentNotSpam | Marks a comment as legitimate by removing its spam designation. |
| MarkCommentSpam | Flags a comment as spam, preventing it from appearing on the storefront. |
| OrderCancel | Cancels an order, reversing associated fulfillments and triggering applicable refunds. |
| PublishTheme | Publishes a selected theme as the active storefront theme. |
| RejectCancellationRequest | Rejects a cancellation request for a fulfillment order, instructing the fulfillment service to proceed with shipping. |
| RejectFulfillmentRequest | Rejects a pending fulfillment request sent to the fulfillment service, optionally including a rejection message. |
| SendCancellationRequest | Submits a cancellation request for a fulfillment order to its corresponding fulfillment service. |
| SendFulfillmentRequest | Sends a fulfillment initiation request to the designated fulfillment service. |
| TransactionVoid | Voids an uncaptured authorization transaction before settlement. |
| UpdateFile | Updates metadata or attributes of an existing uploaded file asset within Shopify. |