Fulfillments

Stores shipment data for orders, including tracking details, carrier information, and shipment timestamps.

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		A globally unique identifier for the fulfillment record.
LegacyResourceId	String	True		The legacy identifier of the corresponding fulfillment resource in the REST Admin API.
OrderId	String	True		A globally unique identifier linking this fulfillment to its parent Shopify order.
Name	String	True		A human-readable reference name or label assigned to this fulfillment.
Status	String	True		The current state of the fulfillment, such as pending, in_progress, success, or canceled.
DeliveredAt	Datetime	True		The date when this fulfillment was successfully delivered to the customer.
DisplayStatus	String	True		A user-friendly representation of the fulfillment's current status, suitable for display in Shopify Admin or reports.
RequiresShipping	Bool	True		Indicates whether any line items in the fulfillment require physical shipment.
TotalQuantity	Int	True		The total quantity of all items included in this fulfillment.
EstimatedDeliveryAt	Datetime	True		The estimated date and time when the fulfillment is expected to be delivered to the customer.
InTransitAt	Datetime	True		The date and time when the fulfillment shipment was marked as in transit.
CreatedAt	Datetime	True		The timestamp representing when this fulfillment record was created in Shopify.
UpdatedAt	Datetime	True		The timestamp representing the most recent update made to this fulfillment record.
LocationId	String	True		A globally unique identifier for the fulfillment location associated with this record.
ServiceId	String	True		The unique identifier of the fulfillment service responsible for completing this fulfillment.
OriginAddressAddress1	String	True		The primary street address of the fulfillment origin location.
OriginAddressAddress2	String	True		An additional address line for the fulfillment origin, such as apartment, suite, or unit number.
OriginAddressCity	String	True		The city where the fulfillment originated.
OriginAddressCountryCode	String	True		The two-letter ISO country code of the fulfillment origin location.
OriginAddressProvinceCode	String	True		The province or state code of the fulfillment origin location.
OriginAddressZip	String	True		The postal or ZIP code of the fulfillment origin location.
TrackingInfoCompany	String	True		The name of the shipping or courier company handling this fulfillment.
TrackingInfoNumber	String	True		The tracking number provided by the shipping carrier for this fulfillment.
TrackingInfoUrl	String	True		The direct URL provided by the carrier for tracking the shipment status.

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.