FulfillmentOrderLocationsForMove
A list of locations that the fulfillment order can potentially move to.
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
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. | |
| LocationId [KEY] | String | The unique identifier of the location. | |
| AvailableLineItemsCount | Int | Total number of fulfillment order line items that can be moved from their current assigned location to the given location. | |
| AvailableLineItemsCountPrecision | String | The count's precision, or the exactness of the value. | |
| UnavailableLineItemsCount | Int | Total number of fulfillment order line items that can't be moved from their current assigned location to the given location. | |
| UnavailableLineItemsCountPrecision | String | The count's precision, or the exactness of the value. | |
| Movable | Bool | Whether the fulfillment order can be moved to the location. | |
| Message | String | A human-readable string with the reason why the fulfillment order, or some of its line items, can't be moved to the location. |