AssignedFulfillmentOrders
Retrieves fulfillment orders assigned to app-managed locations (requires read_assigned_fulfillment_orders). CLOSED orders are excluded by default.
View-Specific Information
Select
The component uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.
- 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 | The globally unique identifier of the assigned fulfillment order. | |
| ShopId | String |
Shop.Id | The globally unique identifier of the shop associated with this fulfillment order. |
| OrderId | String | The globally unique identifier of the order linked to this fulfillment order. | |
| Status | String | The current status of the fulfillment order, such as open, scheduled, or closed. | |
| FulfillAt | Datetime | The date and time when the fulfillment order becomes fulfillable. Once this time is reached, scheduled orders automatically transition to open. For example, a subscription order might have a fulfill_at date set to the first of each month, while a pre-order might return null. | |
| FulfillBy | Datetime | The deadline by which all items in the fulfillment order must be fulfilled. | |
| RequestStatus | String | The current request status of the fulfillment order, such as accepted, pending, or failed. | |
| CreatedAt | Datetime | The 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 display name of the location assigned to fulfill this order. | |
| AssignedLocationAddress1 | String | The first line of the assigned location's address. | |
| AssignedLocationAddress2 | String | The second line of the assigned location's address, such as an apartment or suite number. | |
| AssignedLocationCity | String | The city where the assigned location is based. | |
| AssignedLocationPhone | String | The phone number of the assigned location. | |
| AssignedLocationProvince | String | The province or state where the assigned location is based. | |
| AssignedLocationZip | String | The postal or ZIP code of the assigned location. | |
| AssignedLocationCountryCode | String | The two-letter country code for the assigned location. | |
| AssignedLocationLocationId | String | The globally unique identifier of the assigned location. | |
| AssignedLocationLocationLegacyResourceId | String | The legacy identifier for the assigned location in the REST Admin API. | |
| AssignedLocationLocationName | String | The name of the assigned location resource. | |
| AssignedLocationLocationActivatable | Bool | Indicates whether the location can be reactivated. | |
| AssignedLocationLocationDeactivatable | Bool | Indicates whether the location can be deactivated. | |
| AssignedLocationLocationDeletable | Bool | Indicates whether the location can be deleted. | |
| AssignedLocationLocationAddressVerified | Bool | Indicates whether the address of the assigned location has been verified. | |
| AssignedLocationLocationDeactivatedAt | String | The date and time when the assigned location was deactivated, in UTC. For example: '2019-09-07T15:50:00Z'. | |
| AssignedLocationLocationIsActive | Bool | Indicates whether the assigned location is currently active. | |
| AssignedLocationLocationShipsInventory | Bool | Indicates whether the location contributes to shipping rate calculations. This flag is ignored in multi-origin shipping mode. | |
| AssignedLocationLocationFulfillsOnlineOrders | Bool | Indicates whether the assigned location can fulfill online orders. | |
| AssignedLocationLocationHasActiveInventory | Bool | Indicates whether the assigned location has active inventory available. | |
| AssignedLocationLocationHasUnfulfilledOrders | Bool | Indicates whether the assigned location currently has unfulfilled orders. | |
| DeliveryMethodId | String | The globally unique identifier of the delivery method chosen for this order. | |
| DeliveryMethodPresentedName | String | The name of the delivery option presented to the buyer at checkout. | |
| DeliveryMethodMethodType | String | The type of delivery method used, such as standard or express. | |
| DeliveryMethodMaxDeliveryDateTime | Datetime | The latest estimated date and time for delivery to the buyer's location. | |
| DeliveryMethodMinDeliveryDateTime | Datetime | The earliest estimated date and time for delivery to the buyer's location. | |
| DeliveryMethodServiceCode | String | The service code that identifies the shipping method. | |
| DeliveryMethodSourceReference | String | Provider-specific reference data associated with the delivery promise. | |
| DeliveryMethodBrandedPromiseName | String | The branded delivery promise name, such as 'Shop Promise'. | |
| DeliveryMethodBrandedPromiseHandle | String | The branded delivery promise handle, such as 'shop_promise'. | |
| DeliveryMethodAdditionalInformationPhone | String | A contact phone number for coordinating delivery. | |
| DeliveryMethodAdditionalInformationInstructions | String | Special delivery instructions provided for the order. | |
| DestinationId | String | The globally unique identifier of the destination record. | |
| DestinationFirstName | String | The first name of the customer at the destination address. | |
| DestinationLastName | String | The last name of the customer at the destination address. | |
| DestinationAddress1 | String | The first line of the customer's destination address. | |
| DestinationAddress2 | String | The second line of the customer's destination address, such as an apartment or suite number. | |
| DestinationCity | String | The city of the customer's destination address. | |
| DestinationCompany | String | The company name listed in the customer's destination address, if applicable. | |
| DestinationEmail | String | The email address of the customer at the destination. | |
| DestinationPhone | String | The phone number of the customer at the destination. | |
| DestinationProvince | String | The province or state of the customer's destination address. | |
| DestinationZip | String | The postal or ZIP code of the customer's destination address. | |
| DestinationCountryCode | String | The two-letter country code of the customer's destination address. | |
| DestinationLocationId | String | The globally unique identifier of the customer's destination location. | |
| InternationalDutiesIncoterm | String | The incoterm that specifies how international duties are paid includes example values such as Delivered Duty Paid (DDP) and Delivered at Place (DAP). | |
| AssignmentStatus | String | The assignment status of the fulfillment orders to return. If no assignmentStatus argument is provided, all assigned fulfillment orders are returned except those with CLOSED status.
The allowed values are CANCELLATION_REQUESTED, FULFILLMENT_ACCEPTED, FULFILLMENT_REQUESTED, FULFILLMENT_UNSUBMITTED. |