FulfillmentOrderLineItems
Lists the line items grouped under a fulfillment order.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- FulfillmentOrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM FulfillmentOrderLineItems WHERE FulfillmentOrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The globally unique identifier of the fulfillment order line item. | |
| FulfillmentOrderId | String | The globally unique identifier of the fulfillment order that this line item belongs to. | |
| ImageId | String | The globally unique identifier of the image associated with the product or variant. | |
| ImageWidth | Int | The original width of the product image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | Alternative text describing the content or purpose of the product image. | |
| ImageHeight | Int | The original height of the product image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | The URL of the product image. | |
| InventoryItemId | String | The globally unique identifier of the inventory item tied to this line item. | |
| Sku | String | The stock keeping unit (SKU) of the product variant. | |
| ProductTitle | String | The title of the product linked to this line item. | |
| VariantId | String | The globally unique identifier of the product variant associated with this line item. | |
| VariantTitle | String | The title of the product variant. | |
| Vendor | String | The name of the vendor that supplied or manufactured the product variant. | |
| RemainingQuantity | Int | The number of units of this line item still pending fulfillment. | |
| TotalQuantity | Int | The total number of units of this line item required in the fulfillment order. | |
| RequiresShipping | Bool | Indicates whether the line item requires physical shipping. | |
| WeightUnit | String | The unit of measurement used for the line item's weight, such as grams or kilograms. | |
| WeightValue | Double | The numeric weight value of a single unit of the line item, measured in the specified unit. | |
| Warnings | String | Any warnings or issues associated with the fulfillment order line item. | |
| FinancialSummaries | String | A financial breakdown of costs associated with the fulfillment order line item. |