Fulfillments

Fulfillment represents a shipment of one or more items in an order.

Table-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.

OrderId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM Fulfillments WHERE OrderId = 'Val1'

Insert

The following columns can be used to create a new record:

OriginAddressAddress1, OriginAddressAddress2, OriginAddressCity, OriginAddressCountryCode, OriginAddressProvinceCode, OriginAddressZip, TrackingInfoCompany, TrackingInfoNumber, TrackingInfoUrl

The following pseudo-columns can be used to create a new record:

NotifyCustomer, Message, 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.
TrackingInfoCompany	String	True		The company associated with the fulfillment.
TrackingInfoNumber	String	True		The tracking number of the fulfillment.
TrackingInfoUrl	String	True		The URL to track the fulfillment.

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.