Fulfillments

Represents shipments created for orders, including tracking and delivery status.

Table-Specific Information

Select

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

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		The globally unique identifier of the fulfillment.
LegacyResourceId	String	True		The legacy identifier of the corresponding resource in the REST Admin API.
OrderId	String	True		The globally unique identifier of the order associated with the fulfillment.
Name	String	True		A human-readable reference identifier for the fulfillment.
Status	String	True		The current status of the fulfillment.
DeliveredAt	Datetime	True		The date when the fulfillment was delivered.
DisplayStatus	String	True		A human-readable display status for the fulfillment.
RequiresShipping	Bool	True		Indicates whether any of the line items in the fulfillment require shipping.
TotalQuantity	Int	True		The total quantity of all line items in the fulfillment.
EstimatedDeliveryAt	Datetime	True		The estimated date when the fulfillment is expected to arrive.
InTransitAt	Datetime	True		The date and time when the fulfillment was marked as in 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 updated.
LocationId	String	True		The globally unique identifier of the fulfillment location.
ServiceId	String	True		The identifier of the fulfillment service.
OriginAddressAddress1	String	True		The first line of the fulfillment location's address.
OriginAddressAddress2	String	True		The second line of the fulfillment location's address, typically an apartment, suite, or unit number.
OriginAddressCity	String	True		The city where the fulfillment location is situated.
OriginAddressCountryCode	String	True		The two-letter country code of the fulfillment location.
OriginAddressProvinceCode	String	True		The province or state code of the fulfillment location.
OriginAddressZip	String	True		The postal or ZIP code of the fulfillment location.
TrackingInfoCompany	String	True		The name of the shipping company handling the fulfillment.
TrackingInfoNumber	String	True		The tracking number assigned to the fulfillment.
TrackingInfoUrl	String	True		The URL used to track the fulfillment shipment.

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.