FulfillmentOrderLocationForMoveAvailableLineItems
Lists items that can be reassigned to a new fulfillment location during inventory relocation.
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 FulfillmentOrderLocationForMoveAvailableLineItems WHERE FulfillmentOrderId = 'Val1'
SELECT * FROM FulfillmentOrderLocationForMoveAvailableLineItems WHERE LocationId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the fulfillment order line item record. | |
| FulfillmentOrderId | String | The unique identifier of the fulfillment order that contains this line item. | |
| ImageId | String | The unique identifier for the image associated with the product or variant linked to this line item. | |
| ImageWidth | Int | The width of the image in pixels, or null if the image is hosted externally. | |
| ImageAltText | String | A short descriptive phrase providing context about the image content for accessibility and SEO purposes. | |
| ImageHeight | Int | The height of the image in pixels, or null if the image is hosted externally. | |
| ImageUrl | String | The direct URL of the product or variant image associated with this fulfillment order line item. | |
| InventoryItemId | String | The unique identifier for the inventory item tied to this fulfillment order line item. | |
| Sku | String | The stock keeping unit (SKU) for the product variant linked to this line item. | |
| ProductTitle | String | The title of the product as recorded in Shopify or at the time of order creation. | |
| VariantId | String | The unique identifier of the product variant associated with this line item. | |
| VariantTitle | String | The name of the product variant as defined in the store catalog or at fulfillment. | |
| Vendor | String | The name of the vendor or supplier providing the product variant. | |
| RemainingQuantity | Int | The number of units of this line item that have not yet been fulfilled or transferred. | |
| TotalQuantity | Int | The total number of units assigned to this fulfillment order line item for movement or fulfillment. | |
| RequiresShipping | Bool | Indicates whether the product requires physical shipping as part of the fulfillment process. | |
| WeightUnit | String | The unit of measurement used for the line item's weight value, such as grams or pounds. | |
| WeightValue | Double | The numerical weight of the line item using the unit specified in WeightUnit. | |
| Warnings | String | Any messages or alerts identifying issues or considerations with moving or fulfilling this line item, such as stock availability. | |
| FinancialSummaries | String | A summary of financial details related to this line item, including pricing, discounts, and tax components. | |
| LocationId [KEY] | String | The unique identifier of the location where the fulfillment order line item can be moved or fulfilled from. |