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 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.
- 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.
使用できる値は次のとおりです。CANCELLATION_REQUESTED, FULFILLMENT_ACCEPTED, FULFILLMENT_REQUESTED, FULFILLMENT_UNSUBMITTED |