AssignedFulfillmentOrders
Retrieves all fulfillment orders assigned to the shop's locations or fulfillment services managed by the app.
View-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.
- AssignedLocationLocationId supports the '=, IN' comparison operators.
- AssignmentStatus supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM AssignedFulfillmentOrders WHERE AssignedLocationLocationId = 'Val1'
SELECT * FROM AssignedFulfillmentOrders WHERE AssignmentStatus = 'CANCELLATION_REQUESTED'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the assigned fulfillment order record. | |
| ShopId | String |
Shop.Id | The unique identifier of the Shopify store associated with this fulfillment order. |
| OrderId | String | The unique identifier of the order that this fulfillment order corresponds to. | |
| Status | String | The current lifecycle status of the fulfillment order, such as open, in_progress, or closed. | |
| FulfillAt | Datetime | The scheduled date and time when the fulfillment order becomes eligible for fulfillment. For example, subscription orders may have a future fulfillment date, while standard orders typically use the order creation date. | |
| FulfillBy | Datetime | The latest date and time by which all items in the fulfillment order must be fulfilled. | |
| RequestStatus | String | The current request status of the fulfillment order, indicating processing or completion progress. | |
| CreatedAt | Datetime | The timestamp when the fulfillment order was initially created. | |
| UpdatedAt | Datetime | The timestamp when the fulfillment order record was last modified. | |
| AssignedLocationName | String | The name of the location assigned to fulfill this order. | |
| AssignedLocationAddress1 | String | The first line of the address for the assigned fulfillment location. | |
| AssignedLocationAddress2 | String | The second line of the address for the assigned fulfillment location, such as suite or unit number. | |
| AssignedLocationCity | String | The city where the assigned fulfillment location is situated. | |
| AssignedLocationPhone | String | The contact phone number for the assigned fulfillment location. | |
| AssignedLocationProvince | String | The province, state, or region where the assigned fulfillment location is located. | |
| AssignedLocationZip | String | The postal or ZIP code of the assigned fulfillment location. | |
| AssignedLocationCountryCode | String | The two-letter ISO country code representing the assigned location's country. | |
| AssignedLocationLocationId | String | The unique identifier of the assigned fulfillment location. | |
| AssignedLocationLocationLegacyResourceId | String | The corresponding REST Admin API resource ID for the assigned location. | |
| AssignedLocationLocationName | String | The official name of the assigned location used within Shopify's fulfillment system. | |
| AssignedLocationLocationActivatable | Bool | Indicates whether the location can be reactivated if previously deactivated. | |
| AssignedLocationLocationDeactivatable | Bool | Indicates whether the location can be deactivated by the merchant or system. | |
| AssignedLocationLocationDeletable | Bool | Indicates whether the location record can be permanently deleted. | |
| AssignedLocationLocationAddressVerified | Bool | Specifies whether the address of this location has been verified for accuracy. | |
| AssignedLocationLocationDeactivatedAt | String | The date and time when the location was deactivated, expressed in UTC format (for example, '2019-09-07T15:50:00Z'). | |
| AssignedLocationLocationIsActive | Bool | Indicates whether the location is currently active and available for fulfillment operations. | |
| AssignedLocationLocationShipsInventory | Bool | Indicates whether the location is used for calculating shipping rates. This field is ignored when multi-origin shipping is enabled. | |
| AssignedLocationLocationFulfillsOnlineOrders | Bool | Specifies whether this location is allowed to fulfill online orders. | |
| AssignedLocationLocationHasActiveInventory | Bool | Indicates whether the assigned location currently holds active inventory. | |
| AssignedLocationLocationHasUnfulfilledOrders | Bool | Indicates whether the location has outstanding orders pending fulfillment. | |
| DeliveryMethodId | String | The unique identifier of the delivery method used for this fulfillment order. | |
| DeliveryMethodPresentedName | String | The name of the delivery option displayed to the buyer during checkout, such as 'Standard Shipping' or 'Express Delivery'. | |
| DeliveryMethodMethodType | String | The category or type of delivery method, such as local, shipping, or pickup. | |
| DeliveryMethodMaxDeliveryDateTime | Datetime | The latest estimated delivery date and time for the fulfillment to reach the buyer. | |
| DeliveryMethodMinDeliveryDateTime | Datetime | The earliest estimated delivery date and time for the fulfillment to reach the buyer. | |
| DeliveryMethodServiceCode | String | A reference code representing the shipping service used, such as a carrier or fulfillment type identifier. | |
| DeliveryMethodSourceReference | String | Carrier or promise provider–specific reference data linked to the delivery promise. | |
| DeliveryMethodBrandedPromiseName | String | The name of the branded delivery promise offered to the buyer, such as 'Shop Promise'. | |
| DeliveryMethodBrandedPromiseHandle | String | The internal handle of the branded promise, such as 'shop_promise'. | |
| DeliveryMethodAdditionalInformationPhone | String | A contact phone number for delivery coordination or customer communication. | |
| DeliveryMethodAdditionalInformationInstructions | String | Special delivery instructions provided by the buyer or merchant. | |
| DestinationId | String | The unique identifier of the delivery destination record. | |
| DestinationFirstName | String | The first name of the customer receiving the order at the destination. | |
| DestinationLastName | String | The last name of the customer receiving the order at the destination. | |
| DestinationAddress1 | String | The first line of the destination address, typically the street address or PO box. | |
| DestinationAddress2 | String | The second line of the destination address, such as apartment or suite number. | |
| DestinationCity | String | The city or locality of the delivery destination. | |
| DestinationCompany | String | The company or organization name associated with the destination address, if applicable. | |
| DestinationEmail | String | The email address of the customer associated with the delivery destination. | |
| DestinationPhone | String | The contact phone number for the customer at the destination. | |
| DestinationProvince | String | The region, province, or state of the delivery destination. | |
| DestinationZip | String | The postal or ZIP code for the destination address. | |
| DestinationCountryCode | String | The two-letter ISO country code for the destination address. | |
| DestinationLocationId | String | The unique identifier of the location record representing the shipping destination. | |
| InternationalDutiesIncoterm | String | The incoterm that defines the international duties payment arrangement, such as DDP (Delivered Duty Paid) or DAP (Delivered at Place). | |
| AssignmentStatus | String | The current assignment status of the fulfillment order, such as 'fulfillment accepted' or 'fulfillment unsubmitted'.
The allowed values are CANCELLATION_REQUESTED, FULFILLMENT_ACCEPTED, FULFILLMENT_REQUESTED, FULFILLMENT_UNSUBMITTED. |