Fulfillments
Fulfillment represents a shipment of one or more items in an order.
View-Specific Information
Select
The adapter processes filters client-side within the adapter.
The following queries are processed server-side:
SELECT * FROM Fulfillments
SELECT * FROM Fulfillments WHERE OrderId='gid://shopify/Order/1234'
SELECT * FROM Fulfillments WHERE OrderId IN ('gid://shopify/Order/1234', 'gid://shopify/Order/1235')
Columns
Name | Type | References | Description |
Id [KEY] | String | Globally unique identifier. | |
CreatedAt | Datetime | The date and time when the fulfillment was created. | |
DeliveredAt | Datetime | The date that this fulfillment was delivered. | |
DisplayStatus | String | Human readable display status for this fulfillment. | |
EstimatedDeliveryAt | Datetime | The estimated date that this fulfillment will arrive. | |
InTransitAt | Datetime | The date and time when the fulfillment went into transit. | |
LegacyResourceId | Long | The ID of the corresponding resource in the REST Admin API. | |
Name | String | Human readable reference identifier for this fulfillment. | |
OrderId | String | Globally unique identifier. | |
RequiresShipping | Boolean | Whether any of the line items in the fulfillment require shipping. | |
Status | String | The status of the fulfillment. | |
TotalQuantity | Integer | Sum of all line item quantities for the fulfillment. | |
UpdatedAt | Datetime | The date and time when the fulfillment was last modified. |