FulfillmentServices
Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner.
Table-Specific Information
Select
The server processes all filters client-side within the server. 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 |
The ID of the fulfillment service. | |
| ServiceName | String | False |
The name of the fulfillment service as seen by merchants. | |
| Handle | String | True |
Human-readable unique identifier for this fulfillment service. | |
| Type | String | True |
Type associated with the fulfillment service. | |
| CallbackUrl | String | False |
The callback URL the fulfillment service has registered for requests. | |
| InventoryManagement | Bool | False |
Whether the fulfillment service tracks product inventory and provides updates to Shopify. | |
| PermitsSkuSharing | Bool | True |
Whether the fulfillment service can stock inventory alongside other locations. | |
| TrackingSupport | Bool | True |
Whether the fulfillment service implemented the /fetch_tracking_numbers endpoint. | |
| LocationId | String | True |
Globally unique identifier. |
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 |
The action to take with the location after the fulfillment service is deleted. The allowed values are DELETE, KEEP, TRANSFER. |