OrderLineItems
Provides detailed product-level information for all line items included in orders.
View-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- ResourceId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderLineItems WHERE ResourceId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the order line item. | |
| ResourceId | String |
Orders.Id | The globally unique identifier for the resource representing this line item. |
| Name | String | The full display name of the product as shown in the order, typically including both the product title and variant title. | |
| Title | String | The title of the product as it appeared when the order was created. | |
| VariantTitle | String | The title of the specific variant purchased, captured at the time of order creation. | |
| VariantId | String | A globally unique identifier for the purchased product variant. | |
| ProductId | String | A globally unique identifier for the base product associated with this line item. | |
| SellingPlanSellingPlanId | String | The ID of the selling plan (for example, subscription or pre-order) associated with this line item. | |
| Quantity | Int | The total number of units ordered for this product variant. | |
| Restockable | Bool | Indicates whether this item can be returned to inventory if restocked. | |
| Sku | String | The stock keeping unit (SKU) identifier for the purchased variant. | |
| Taxable | Bool | Indicates whether the item is subject to tax based on the shop's tax settings. | |
| Vendor | String | The name of the vendor or manufacturer who supplied the variant. | |
| CurrentQuantity | Int | The remaining quantity for this line item after any cancellations or returns have been applied. | |
| MerchantEditable | Bool | Indicates whether the merchant can edit this line item's details after the order is placed. | |
| RefundableQuantity | Int | The number of units currently eligible for refund. | |
| RequiresShipping | Bool | Whether this product requires physical shipment. False for digital or service items. | |
| UnfulfilledQuantity | Int | The number of units in this line item that have not yet been fulfilled. | |
| NonFulfillableQuantity | Int | The total number of units that cannot be fulfilled due to refunds, cancellations, or non-physical items such as tips. | |
| IsGiftCard | Bool | Indicates whether this line item represents the purchase of a gift card. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted price for this line item in the customer's presentment currency. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The total discounted price after applying discount codes, expressed in the presentment currency. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the discounted total. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The total discounted price for this line item in the shop's base currency. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The total discounted price after discount codes, expressed in the shop's base currency. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the discounted total. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted price per unit of the item in the customer's presentment currency. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the discounted unit price. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted price per unit of the item in the shop's base currency. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the discounted unit price. | |
| ImageId | String | The unique identifier for the image associated with this product variant. | |
| ImageWidth | Int | The original width of the associated product image in pixels, or null if not hosted by Shopify. | |
| ImageAltText | String | A short descriptive phrase providing alternative text for the associated product image. | |
| ImageHeight | Int | The original height of the associated product image in pixels, or null if not hosted by Shopify. | |
| ImageUrl | String | The URL of the product image as hosted by Shopify or an external source. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The total pre-discount price of this line item in the customer's presentment currency. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original (undiscounted) total. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The total pre-discount price of this line item in the shop's base currency. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the original (undiscounted) total. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The pre-discount price per unit in the customer's presentment currency. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the pre-discount unit price. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The pre-discount price per unit in the shop's base currency. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the pre-discount unit price. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount value applied to this line item in the customer's presentment currency. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the total discount. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount value applied to this line item in the shop's base currency. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the total discount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total for all unfulfilled units in presentment currency. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the unfulfilled discounted total. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The discounted total for all unfulfilled units in the shop's base currency. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the unfulfilled discounted total. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The original total before discounts for all unfulfilled units, in presentment currency. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled original total. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The original total before discounts for all unfulfilled units, in the shop's base currency. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency of the unfulfilled original total. | |
| OrderUpdatedAt | Datetime | The date and time when the order containing this line item was last updated. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description | |
| FulfillmentService | String | The handle of the fulfillment service responsible for stocking or shipping this product variant. | |
| OrderLineItemCustomAttributes | String | Custom metadata fields associated with the line item, often used for personalization or configuration options. | |
| OrderLineItemTaxLines | String | A list of tax line objects, each representing a specific tax applied to this line item. |