FulfillmentOrderLocationForMoveUnavailableLineItems
Lists items that cannot be moved to a new fulfillment location, often due to stock or policy restrictions.
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 FulfillmentOrderLocationForMoveUnavailableLineItems WHERE FulfillmentOrderId = 'Val1'
SELECT * FROM FulfillmentOrderLocationForMoveUnavailableLineItems 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 includes 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 descriptive phrase that conveys the image's purpose or content for accessibility and SEO. | |
| 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 connected to this fulfillment order line item. | |
| Sku | String | The stock keeping unit (SKU) assigned to the product variant associated with this line item. | |
| ProductTitle | String | The title of the product as it appears in the Shopify catalog or at order creation. | |
| VariantId | String | The unique identifier of the product variant associated with this fulfillment order line item. | |
| VariantTitle | String | The name of the product variant as recorded in the catalog or at fulfillment time. | |
| Vendor | String | The vendor or manufacturer responsible for producing the product variant. | |
| RemainingQuantity | Int | The number of units from this line item that remain unfulfilled and are not available for movement. | |
| TotalQuantity | Int | The total number of units included in this fulfillment order line item. | |
| RequiresShipping | Bool | Indicates whether this line item requires physical shipping. | |
| WeightUnit | String | The unit of measurement (such as grams or pounds) used to express the weight value of the line item. | |
| WeightValue | Double | The numeric weight value of the line item, based on the unit defined in WeightUnit. | |
| Warnings | String | Messages or alerts describing issues preventing this line item from being moved, such as insufficient stock or restricted location availability. | |
| FinancialSummaries | String | A summary of financial details for the line item, including prices, discounts, and tax information relevant to the fulfillment order. | |
| LocationId [KEY] | String | The unique identifier of the location that cannot currently fulfill or accept movement of this line item. |