AssignedFulfillmentOrders
Retrieves a paginated list of fulfillment orders assigned to the shop locations owned by the app. Assigned fulfillment orders are fulfillment orders that are set to be fulfilled from locations managed by fulfillment services that are registered by the app. One app (api_client) can host multiple fulfillment services on a shop. Each fulfillment service manages a dedicated location on a shop. Assigned fulfillment orders can have associated, or might currently not be requested to be fulfilled. The app must have 'read_assigned_fulfillment_orders' to be able to retrieve fulfillment orders assigned to its locations. All assigned fulfillment orders (except those with the 'CLOSED' status) will be returned by default.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the AssignedLocationLocationId column, which supports the '=,IN' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM AssignedFulfillmentOrders WHERE AssignedLocationLocationId='VALUE'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| ShopId | String |
Shop.Id | A globally-unique ID. |
| OrderId | String | A globally-unique ID. | |
| Status | String | The status of the fulfillment order. | |
| FulfillAt | Datetime | 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 | The latest date and time by which all items in the fulfillment order need to be fulfilled. | |
| RequestStatus | String | The request status of the fulfillment order. | |
| CreatedAt | Datetime | Date and time when the fulfillment order was created. | |
| UpdatedAt | Datetime | The date and time when the fulfillment order was last updated. | |
| AssignedLocationName | String | The name of the location. | |
| AssignedLocationAddress1 | String | The first line of the address for the location. | |
| AssignedLocationAddress2 | String | The second line of the address for the location. | |
| AssignedLocationCity | String | The city of the location. | |
| AssignedLocationPhone | String | The phone number of the location. | |
| AssignedLocationProvince | String | The province of the location. | |
| AssignedLocationZip | String | The ZIP code of the location. | |
| AssignedLocationCountryCode | String | The two-letter country code of the location. | |
| AssignedLocationLocationId | String | A globally-unique ID. | |
| AssignedLocationLocationLegacyResourceId | String | The ID of the corresponding resource in the REST Admin API. | |
| AssignedLocationLocationName | String | The name of the location. | |
| AssignedLocationLocationActivatable | Bool | Whether this location can be reactivated. | |
| AssignedLocationLocationDeactivatable | Bool | Whether this location can be deactivated. | |
| AssignedLocationLocationDeletable | Bool | Whether this location can be deleted. | |
| AssignedLocationLocationAddressVerified | Bool | Whether the location address has been verified. | |
| AssignedLocationLocationDeactivatedAt | String | 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 | Whether the location is active. | |
| AssignedLocationLocationShipsInventory | Bool | Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored. | |
| AssignedLocationLocationFulfillsOnlineOrders | Bool | Whether this location can fulfill online orders. | |
| AssignedLocationLocationHasActiveInventory | Bool | Whether this location has active inventory. | |
| AssignedLocationLocationHasUnfulfilledOrders | Bool | Whether this location has orders that need to be fulfilled. | |
| DeliveryMethodId | String | A globally-unique ID. | |
| DeliveryMethodMethodType | String | The type of the delivery method. | |
| DeliveryMethodMaxDeliveryDateTime | Datetime | The latest delivery date and time when the fulfillment is expected to arrive at the buyer's location. | |
| DeliveryMethodMinDeliveryDateTime | Datetime | The earliest delivery date and time when the fulfillment is expected to arrive at the buyer's location. | |
| DestinationId | String | A globally-unique ID. | |
| DestinationFirstName | String | The first name of the customer at the destination. | |
| DestinationLastName | String | The last name of the customer at the 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. | |
| DestinationEmail | String | The email of the customer at the destination. | |
| DestinationPhone | String | The phone number of the customer at the destination. | |
| DestinationProvince | String | The province of the destination. | |
| DestinationZip | String | The ZIP code of the destination. | |
| DestinationCountryCode | String | The two-letter country code of the destination. | |
| InternationalDutiesIncoterm | String | The method of duties payment. Example values: 'DDP', 'DAP'. |