FulfillmentOrderLocationForMoveAvailableLineItems
A list of the fulfillment order's line items.
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
SELECT * FROM FulfillmentOrderLocationForMoveAvailableLineItems WHERE FulfillmentOrderId = 'Val1'
SELECT * FROM FulfillmentOrderLocationForMoveAvailableLineItems WHERE LocationId = 'Val1'
Columns
Name | Type | References | Description |
Id [KEY] | String | The unique identifier of the line item. | |
FulfillmentOrderId | String | The unique identifier of the fulfillment order. | |
ImageId | String | A unique ID for the image. | |
ImageWidth | Int | The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
ImageAltText | String | A word or phrase to share the nature or contents of an image. | |
ImageHeight | Int | The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
ImageUrl | String | The location of the image as a URL. | |
InventoryItemId | String | The ID of the inventory item. | |
Sku | String | The variant SKU number. | |
ProductTitle | String | The title of the product. | |
VariantTitle | String | The name of the variant. | |
Vendor | String | The name of the vendor who made the variant. | |
RemainingQuantity | Int | The number of units remaining to be fulfilled. | |
TotalQuantity | Int | The total number of units to be fulfilled. | |
RequiresShipping | Bool | Whether physical shipping is required for the variant. | |
WeightUnit | String | The weight of a line item unit. The unit of measurement for value. | |
WeightValue | Double | The weight value using the unit system specified with unit. | |
Warnings | String | Warning messages for a fulfillment order line item. | |
FinancialSummaries | String | The financial summary for the Fulfillment Order's Line Items. | |
LocationId [KEY] | String | The unique identifier of the location. |