FulfillmentOrderLineItems
Retrieves detailed product line information associated with fulfillment orders.
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 | A globally unique identifier for the fulfillment order line item record. | |
| FulfillmentOrderId | String | The unique identifier of the fulfillment order that this line item belongs to. | |
| ImageId | String | The unique identifier for the image associated with the product or variant in this line item. | |
| ImageWidth | Int | The original width of the image in pixels, or null if the image is externally hosted. | |
| ImageAltText | String | A short descriptive phrase providing context about the image content for accessibility and SEO purposes. | |
| ImageHeight | Int | The original height of the image in pixels, or null if the image is externally hosted. | |
| ImageUrl | String | The direct URL of the product or variant image related to this fulfillment order line item. | |
| InventoryItemId | String | The unique identifier for the inventory item linked to this fulfillment order line item. | |
| Sku | String | The stock keeping unit (SKU) that identifies the product variant associated with this line item. | |
| ProductTitle | String | The title of the product as it appears in the Shopify catalog or at the time of 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 it appears at the time of fulfillment. | |
| Vendor | String | The name of the vendor or brand that supplies the product variant. | |
| RemainingQuantity | Int | The number of units of this line item that have not yet been fulfilled. | |
| TotalQuantity | Int | The total number of units assigned to this fulfillment order line item. | |
| RequiresShipping | Bool | Indicates whether the product requires physical shipment as part of the fulfillment process. | |
| WeightUnit | String | The unit of measurement (such as grams or pounds) used for the line item's weight value. | |
| WeightValue | Double | The numerical weight value of the item, measured using the unit specified in WeightUnit. | |
| Warnings | String | Messages describing potential issues or constraints related to this fulfillment order line item, such as stock limits or location restrictions. | |
| FinancialSummaries | String | A summary of monetary values associated with this line item, including pricing, discounts, and tax details relevant to the fulfillment order. |