FulfillmentOrders
Query fulfillment orders.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the OrderId and Id columns. The adapter processes other filters client-side within the adapter. 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. |