OrderLineItems
Lists line items on orders, including variants, quantities, and pricing.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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 Id for the order line item. | |
| ResourceId | String |
Orders.Id | A globally unique Id for the resource associated with the line item. |
| Name | String | The title of the product, optionally appended with the title of the variant (if applicable). | |
| Title | String | The title of the product at the time of order creation. | |
| VariantTitle | String | The title of the variant at the time of order creation. | |
| VariantId | String | A globally unique Id for the variant associated with the line item. | |
| ProductId | String | A globally unique Id for the product associated with the line item. | |
| SellingPlanSellingPlanId | String | The Id of the selling plan associated with the line item. | |
| Quantity | Int | The number of variant units ordered. | |
| Restockable | Bool | Indicates whether the line item can be restocked. | |
| Sku | String | The variant SKU number. | |
| Taxable | Bool | Indicates whether the variant is taxable. | |
| Vendor | String | The name of the vendor who made the variant. | |
| CurrentQuantity | Int | The current quantity of the line item, excluding removed units. | |
| MerchantEditable | Bool | Indicates whether the line item can be edited. | |
| RefundableQuantity | Int | The quantity of the line item that can be refunded. | |
| RequiresShipping | Bool | Indicates whether physical shipping is required for the variant. | |
| UnfulfilledQuantity | Int | The number of units not yet fulfilled. | |
| NonFulfillableQuantity | Int | The number of units that cannot be fulfilled. For example, refunded items or non-fulfillable items like tips. | |
| IsGiftCard | Bool | Indicates whether the line item represents the purchase of a gift card. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The discounted total, in presentment currency, as a decimal value. | |
| DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts | Decimal | The discounted total with code discounts applied, in presentment currency, as a decimal value. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted total. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The discounted total, in shop currency, as a decimal value. | |
| DiscountedTotalSetShopMoneyAmountWithCodeDiscounts | Decimal | The discounted total with code discounts applied, in shop currency, as a decimal value. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discounted total. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The discounted unit price, in presentment currency, as a decimal value. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the discounted unit price. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The discounted unit price, in shop currency, as a decimal value. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discounted unit price. | |
| ImageId | String | A globally unique Id for the image. | |
| ImageWidth | Int | The original width of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | A word or phrase that describes the contents or purpose of the image. | |
| ImageHeight | Int | The original height of the image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | The URL location of the image. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The original total, in presentment currency, as a decimal value. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original total. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The original total, in shop currency, as a decimal value. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the original total. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original unit price, in presentment currency, as a decimal value. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the original unit price. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original unit price, in shop currency, as a decimal value. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the original unit price. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total discount applied, in presentment currency, as a decimal value. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the total discount. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount applied, in shop currency, as a decimal value. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the total discount. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled discounted total, in presentment currency, as a decimal value. | |
| UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled discounted total. | |
| UnfulfilledDiscountedTotalSetShopMoneyAmount | Decimal | The unfulfilled discounted total, in shop currency, as a decimal value. | |
| UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the unfulfilled discounted total. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyAmount | Decimal | The unfulfilled original total, in presentment currency, as a decimal value. | |
| UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the unfulfilled original total. | |
| UnfulfilledOriginalTotalSetShopMoneyAmount | Decimal | The unfulfilled original total, in shop currency, as a decimal value. | |
| UnfulfilledOriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the unfulfilled original total. | |
| OrderUpdatedAt | Datetime | The date and time when the order was last updated. |
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 | |
| FulfillmentService | String | The handle of the fulfillment service that stocks the product variant for the line item. | |
| OrderLineItemCustomAttributes | String | Custom information added to the cart for the line item, often used for product customization options. | |
| OrderLineItemTaxLines | String | A list of tax line objects applied to the line item. |