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
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| 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. The allowed values are DELETE, KEEP, TRANSFER. |