Fulfillments
Fulfillment represents a shipment of one or more items in an order.
Table-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the OrderIdcolumn, which supports the '=,IN' comparison operators.
The add-in processes other filters client-side within the add-in.
For example, the following query is processed server-side:
SELECT * FROM Fulfillments WHERE OrderId='VALUE'
Insert
INSERT statements are mapped to the 'fulfillmentCreateV2' GraphQL mutation.
The following columns can be used to create a new record:
OriginAddressAddress1, OriginAddressAddress2, OriginAddressCity, OriginAddressCountryCode, OriginAddressProvinceCode, OriginAddressZip, TrackingInfoNumber, TrackingInfoUrl, FulfillmentOrderIds
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
LegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
OrderId | String | True |
Globally unique identifier. | |
Name | String | True |
Human readable reference identifier for this fulfillment. | |
Status | String | True |
The status of the fulfillment. | |
DeliveredAt | Datetime | True |
The date that this fulfillment was delivered. | |
DisplayStatus | String | True |
Human readable display status for this fulfillment. | |
RequiresShipping | Bool | True |
Whether any of the line items in the fulfillment require shipping. | |
TotalQuantity | Int | True |
Sum of all line item quantities for the fulfillment. | |
EstimatedDeliveryAt | Datetime | True |
The estimated date that this fulfillment will arrive. | |
InTransitAt | Datetime | True |
The date and time when the fulfillment went into transit. | |
CreatedAt | Datetime | True |
The date and time when the fulfillment was created. | |
UpdatedAt | Datetime | True |
The date and time when the fulfillment was last modified. | |
LocationId | String | True |
A globally-unique ID. | |
ServiceId | String | True |
The ID of the fulfillment service. | |
OriginAddressAddress1 | String | True |
The street address of the fulfillment location. | |
OriginAddressAddress2 | String | True |
The second line of the address. Typically the number of the apartment, suite, or unit. | |
OriginAddressCity | String | True |
The city in which the fulfillment location is located. | |
OriginAddressCountryCode | String | True |
The country code of the fulfillment location. | |
OriginAddressProvinceCode | String | True |
The province code of the fulfillment location. | |
OriginAddressZip | String | True |
The zip code of the fulfillment location. | |
TrackingInfoNumber | String | True |
TrackingInfoNumber | |
TrackingInfoUrl | String | True |
TrackingInfoUrl |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
FulfillmentOrderIds | String |
An aggregated object containing the FulfillmentOrder ids. Ex: [{'fulfillmentOrderId': 'gid://shopify/FulfillmentOrder/xxx'}] |