FulfillmentOrders
Retrieves a paginated list of merchant-managed and third-party fulfillment orders.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
- Status supports the '=,!=' comparison operators.
- AssignedLocationLocationId supports the '=,!=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM FulfillmentOrders
SELECT * FROM FulfillmentOrders WHERE Id = 'Val1'
SELECT * FROM FulfillmentOrders WHERE Status = 'Val1'
SELECT * FROM FulfillmentOrders WHERE AssignedLocationLocationId = 'Val1'
Update
The following column can be updated:
Status
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| Status | String | False |
The status of the fulfillment order. | |
| FulfillAt | Datetime | True |
The date and time at which the fulfillment order will be fulfillable. When this date and time is reached, the scheduled fulfillment order is automatically transitioned to open. For example, the 'fulfill_at' date for a subscription order might be the 1st of each month, a pre-order 'fulfill_at' date would be 'nil', and a standard order 'fulfill_at' date would be the order creation date. | |
| FulfillBy | Datetime | True |
The latest date and time by which all items in the fulfillment order need to be fulfilled. | |
| OrderName | String | True |
The unique identifier for the order that appears on the order page. | |
| RequestStatus | String | True |
The request status of the fulfillment order. | |
| CreatedAt | Datetime | True |
Date and time when the fulfillment order was created. | |
| UpdatedAt | Datetime | True |
The date and time when the fulfillment order was last updated. | |
| OrderProcessedAt | Datetime | True |
The date and time when the fulfillment order was processed at. | |
| AssignedLocationName | String | True |
The name of the location. | |
| AssignedLocationAddress1 | String | True |
The first line of the address for the location. | |
| AssignedLocationAddress2 | String | True |
The second line of the address for the location. | |
| AssignedLocationCity | String | True |
The city of the location. | |
| AssignedLocationPhone | String | True |
The phone number of the location. | |
| AssignedLocationProvince | String | True |
The province of the location. | |
| AssignedLocationZip | String | True |
The ZIP code of the location. | |
| AssignedLocationCountryCode | String | True |
The two-letter country code of the location. | |
| AssignedLocationLocationId | String | True |
A globally-unique ID. | |
| AssignedLocationLocationLegacyResourceId | String | True |
The ID of the corresponding resource in the REST Admin API. | |
| AssignedLocationLocationName | String | True |
The name of the location. | |
| AssignedLocationLocationActivatable | Bool | True |
Whether this location can be reactivated. | |
| AssignedLocationLocationDeactivatable | Bool | True |
Whether this location can be deactivated. | |
| AssignedLocationLocationDeletable | Bool | True |
Whether this location can be deleted. | |
| AssignedLocationLocationAddressVerified | Bool | True |
Whether the location address has been verified. | |
| AssignedLocationLocationDeactivatedAt | String | True |
The date and time that the location was deactivated at. For example, 3: 30 pm on September 7, 2019 in the time zone of UTC (Universal Time Coordinated) is represented as '2019-09-07T15: 50: 00Z'. | |
| AssignedLocationLocationIsActive | Bool | True |
Whether the location is active. | |
| AssignedLocationLocationShipsInventory | Bool | True |
Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored. | |
| AssignedLocationLocationFulfillsOnlineOrders | Bool | True |
Whether this location can fulfill online orders. | |
| AssignedLocationLocationHasActiveInventory | Bool | True |
Whether this location has active inventory. | |
| AssignedLocationLocationHasUnfulfilledOrders | Bool | True |
Whether this location has orders that need to be fulfilled. | |
| DeliveryMethodId | String | True |
A globally-unique ID. | |
| DeliveryMethodMethodType | String | True |
The type of the delivery method. | |
| DeliveryMethodMaxDeliveryDateTime | Datetime | True |
The latest delivery date and time when the fulfillment is expected to arrive at the buyer's location. | |
| DeliveryMethodMinDeliveryDateTime | Datetime | True |
The earliest delivery date and time when the fulfillment is expected to arrive at the buyer's location. | |
| DestinationId | String | True |
A globally-unique ID. | |
| DestinationFirstName | String | True |
The first name of the customer at the destination. | |
| DestinationLastName | String | True |
The last name of the customer at the destination. | |
| DestinationAddress1 | String | True |
The first line of the address of the destination. | |
| DestinationAddress2 | String | True |
The second line of the address of the destination. | |
| DestinationCity | String | True |
The city of the destination. | |
| DestinationCompany | String | True |
The company of the destination. | |
| DestinationEmail | String | True |
The email of the customer at the destination. | |
| DestinationPhone | String | True |
The phone number of the customer at the destination. | |
| DestinationProvince | String | True |
The province of the destination. | |
| DestinationZip | String | True |
The ZIP code of the destination. | |
| DestinationCountryCode | String | True |
The two-letter country code of the destination. | |
| InternationalDutiesIncoterm | String | True |
The method of duties payment. Example values: 'DDP', 'DAP'. | |
| OrderId | String | True |
A globally-unique ID. |