FulfillmentServices
Defines fulfillment services integrated with the shop, including their endpoints and managed locations.
Table-Specific Information
Select
The connector processes all filters client-side within the connector. The following query is the only one processed server-side:
SELECT * FROM FulfillmentServices
Insert
The following columns can be used to create a new record:
ServiceName, CallbackUrl, InventoryManagement
Update
The following columns can be updated:
ServiceName, CallbackUrl, InventoryManagement
Delete
You can delete entries by specifying the following columns:
Id, LocationId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally unique identifier for the fulfillment service record. | |
| ServiceName | String | False |
The display name of the fulfillment service as it appears to merchants in Shopify Admin. | |
| Handle | String | True |
A human-readable, unique identifier used to reference this fulfillment service within Shopify or through the API. | |
| Type | String | True |
The classification or category of the fulfillment service, indicating how it operates or integrates with Shopify. | |
| CallbackUrl | String | False |
The registered URL endpoint that receives fulfillment-related callbacks or webhook requests from Shopify. | |
| InventoryManagement | Bool | False |
Indicates whether the fulfillment service actively manages product inventory levels and provides stock updates to Shopify. | |
| PermitsSkuSharing | Bool | True |
Specifies whether this fulfillment service allows SKUs to be shared with other locations or fulfillment providers. | |
| TrackingSupport | Bool | True |
Indicates whether the fulfillment service supports shipment tracking by implementing the /fetch_tracking_numbers endpoint. | |
| LocationId | String | True |
A globally unique identifier for the location associated with this fulfillment service. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description |
| InventoryAction | String |
Specifies the action to perform with the location's inventory when the fulfillment service is deleted, such as retaining or removing stock associations. 使用できる値は次のとおりです。DELETE, KEEP, TRANSFER |