Query fulfillment orders.

View-Specific Information

Select

The server uses the Shopify API to process search criteria that refer to the OrderId and Id columns. The server processes other filters client-side within the server. For example, the following queries are processed server-side.

SELECT * FROM FulfillmentOrders WHERE OrderId = '1'

SELECT * FROM FulfillmentOrders WHERE Id = '1'

Columns

Name	Type	References	Description
Id [KEY]	Long		An ID for the fulfillment order.
ShopId	Long	Shop.Id	The ID of the shop that's associated with the fulfillment order.
OrderId [KEY]	Long	Orders.Id	The ID of the order that's associated with the fulfillment order.
AssignedLocationId	Long		The ID of the location that has been assigned to do the work.
DestinationId	String		The ID of the fulfillment order destination.
DestinationAddress1	String		The first line of the address of the destination.
DestinationAddress2	String		The second line of the address of the destination.
DestinationCity	String		The city of the destination.
DestinationCompany	String		The company of the destination.
DestinationFirstName	String		The first name of the customer at the destination.
DestinationLastName	String		The last name of the customer at the destination.
DestinationPhone	String		The phone number of the customer at the destination.
FullfillAt	Datetime		The datetime (in UTC) when the fulfillment order is ready for fulfillment.
LineItems	String		Represents line items belonging to a fulfillment order.
RequestStatus	String		The status of the fulfillment.
Status	String		The status of the fulfillment order.
SupportedActions	String		The actions that can be performed on this fulfillment order.
MerchantRequests	String		A list of requests sent by the merchant to the fulfillment service for this fulfillment order..
FulfillmentHolds	String		Represents the fulfillment holds applied on the fulfillment order.
InternationalDuties	String		The international duties relevant to the fulfillment order.
AssignedLocationAddress1	String		The street address of the assigned location
AssignedLocationAddress2	String		An optional additional field for the street address of the assigned location.
AssignedLocationCity	String		The city of the assigned location.
AssignedLocationCountryCode	String		The two-letter code for the country of the assigned location
AssignedLocationName	String		The name of the assigned location.
AssignedLocationPhone	String		The phone number of the assigned location.
DeliveryMethodId	Long		The ID of the delivery option that was presented to the buyer during checkout.
DeliveryMethodPresentedName	String		The name of the delivery option that was presented to the buyer during checkout.
DeliveryMethodType	String		The type of the delivery option that was presented to the buyer during checkout.