OrdersItems
Provides item-level order details, including variant, quantity, pricing, discounts, and fulfillment status.
Columns
| Name | Type | References | Description |
| ItemId [KEY] | Long | The unique numeric identifier for the order item. Available only for orders. | |
| OrderId | Long |
Orders.Id | The unique numeric identifier for the order associated with this item. |
| OrderUpdatedAt | Datetime | The date and time when the order containing this item was last modified. | |
| ProductId | Long | The unique numeric identifier for the product associated with this order item. | |
| ItemVariantId | Long | The unique numeric identifier for the product variant associated with this item. | |
| ItemTitle | String | The title of the product associated with this order item. | |
| Name | String | The name of the product variant for this item. | |
| ItemQuantity | Int | The quantity of this product purchased in the order. | |
| ItemPrice | Decimal | The unit price of the item before any discounts are applied. | |
| ItemGrams | Int | The weight of the item in grams, used for shipping calculations. | |
| SKU | String | A unique stock keeping unit (SKU) identifier for the item in the order. | |
| VariantTitle | String | The title of the specific product variant for this order item. | |
| Properties | String | A JSON aggregate of custom properties or options associated with this order item. | |
| Vendor | String | The supplier or vendor associated with this item. | |
| FulFillmentsService | String | The fulfillment service provider responsible for fulfilling this item. | |
| RequiresShipping | Bool | Indicates whether this item requires physical shipping. | |
| Taxable | Bool | Indicates whether this item is subject to sales tax. | |
| GiftCard | Bool | Indicates whether this item represents a gift card product. | |
| CurrentQuantity | Int | The current quantity of this line item after any updates or removals. | |
| FulfillableQuantity | Int | The number of units remaining that can still be fulfilled for this item. | |
| TotalDiscount | Decimal | The total discount amount applied to this individual line item. | |
| FulfillmentStatus | String | The current fulfillment status of the order item, indicating how much of the item has been fulfilled. | |
| AppliedDiscountTitle | String | The title of any discount applied to this order item. Available only for draft orders. | |
| AppliedDiscountDescription | String | A brief description of the applied discount for this order item. Available only for draft orders. | |
| AppliedDiscountValue | Decimal | The numeric value of the applied discount for this order item. Available only for draft orders. | |
| AppliedDiscountValueType | String | The type of discount applied to this order item (for example, percentage or fixed amount). Available only for draft orders. | |
| AppliedDiscountAmount | Decimal | The total monetary amount discounted for this order item. Available only for draft orders. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description | |
| Type | String | Specifies the source type of the order item.
The allowed values are Order, DraftOrder, AbandonedCheckout. | |
| Status | String | Filters the order item by order status. Valid values: open (only open orders), closed (only closed orders), cancelled (only canceled orders), or any (orders of any status). Default: open. |