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