FulfillmentServices
Lists fulfillment services that prepare and ship orders on behalf of the merchant.
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, RequiresShippingMethod
Update
The following columns can be updated:
ServiceName, CallbackUrl, InventoryManagement, RequiresShippingMethod
Delete
You can delete entries by specifying the following columns:
Id, LocationId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the fulfillment service. | |
| ServiceName | String | False |
The name of the fulfillment service as displayed to merchants. | |
| Handle | String | True |
A human-readable, unique string that identifies the fulfillment service. | |
| Type | String | True |
The type of the fulfillment service. | |
| CallbackUrl | String | False |
The callback URL that the fulfillment service registers to receive requests from Shopify. | |
| InventoryManagement | Bool | False |
Indicates whether the fulfillment service tracks product inventory and provides updates to Shopify. | |
| PermitsSkuSharing | Bool | True |
Indicates whether the fulfillment service can stock inventory alongside other locations. | |
| RequiresShippingMethod | Bool | False |
Indicates whether the fulfillment service requires products to be physically shipped. | |
| TrackingSupport | Bool | True |
Indicates whether the fulfillment service supports tracking numbers through the /fetch_tracking_numbers endpoint. | |
| LocationId | String | True |
The globally unique identifier of the location associated with the 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 take with the location after the fulfillment service is deleted. The allowed values are DELETE, KEEP, TRANSFER. |