FulfillmentOrderLocationsForMove
Lists candidate locations to which a fulfillment order can be moved.
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 globally unique identifier of the fulfillment order being evaluated for relocation. | |
| LocationId [KEY] | String | The globally unique identifier of the target location. | |
| AvailableLineItemsCount | Int | The number of fulfillment order line items that can be reassigned from their current location to this location. | |
| AvailableLineItemsCountPrecision | String | The precision level of the available line items count. | |
| UnavailableLineItemsCount | Int | The number of fulfillment order line items that cannot be reassigned to this location. | |
| UnavailableLineItemsCountPrecision | String | The precision level of the unavailable line items count. | |
| Movable | Bool | Indicates whether the fulfillment order as a whole can be moved to this location. | |
| Message | String | A human-readable explanation of why the fulfillment order, or certain line items, cannot be moved to the location. |