FulfillmentOrderLineItems
A list of the fulfillment order's line items.
View-Specific Information
Select
The adapter uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The adapter processes other filters client-side within the adapter.
- FulfillmentOrderId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM FulfillmentOrderLineItems
SELECT * FROM FulfillmentOrderLineItems WHERE FulfillmentOrderId = '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. |