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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description | |
| Type | String | Specifies the source type of the order item.
使用できる値は次のとおりです。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. |