Fulfillments
Fulfillment represents a shipment of one or more items in an order.
View-Specific Information
Select
The driver processes filters client-side within the driver.
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. |