FulfillmentOrderLocationsForMove
Displays eligible locations to which fulfillment orders can be reassigned.
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.
- FulfillmentOrderId supports the '=, IN' comparison operators.
- LocationId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM FulfillmentOrderLocationsForMove WHERE FulfillmentOrderId = 'Val1'
SELECT * FROM FulfillmentOrderLocationsForMove WHERE LocationId = 'Val1'
Columns
| Name | Type | References | Description |
| FulfillmentOrderId [KEY] | String | The unique identifier of the fulfillment order being evaluated for possible relocation. | |
| LocationId [KEY] | String | The unique identifier of the target location to which the fulfillment order may be moved. | |
| AvailableLineItemsCount | Int | The total number of line items within the fulfillment order that are eligible to be moved from their current assigned location to this location. | |
| AvailableLineItemsCountPrecision | String | Indicates the precision or reliability of the available line item count, showing whether the value is exact or estimated. | |
| UnavailableLineItemsCount | Int | The total number of line items that cannot be moved from their current assigned location to this location. | |
| UnavailableLineItemsCountPrecision | String | Indicates the precision or reliability of the unavailable line item count, showing whether the value is exact or estimated. | |
| Movable | Bool | Specifies whether the fulfillment order as a whole can be reassigned to the target location based on inventory and fulfillment constraints. | |
| Message | String | A descriptive message explaining why the fulfillment order or specific line items cannot be moved to this location, if applicable. |