Fulfillments
Fulfillment represents a shipment of one or more items in an order.
Table-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.
- OrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Fulfillments
SELECT * FROM Fulfillments WHERE OrderId = 'Val1'
Insert
The following columns can be used to create a new record:
Id, OriginAddressAddress1, OriginAddressAddress2, OriginAddressCity, OriginAddressCountryCode, OriginAddressProvinceCode, OriginAddressZip, TrackingInfoNumber, TrackingInfoUrl
The following pseudo-column can be used to create a new record:
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。
Name | Type | Description |
FulfillmentOrderIds | String |
An aggregated object containing the FulfillmentOrder ids. Ex: [{'fulfillmentOrderId': 'gid://shopify/FulfillmentOrder/xxx'}] |