DraftOrderLineItems
Lists products, variants, and quantities included in draft orders, including applied discounts.
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.
- DraftOrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM DraftOrderLineItems WHERE DraftOrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the draft order line item record. | |
| DraftOrderId | String |
DraftOrders.Id | The unique identifier of the draft order that this line item belongs to. |
| Name | String | The display name of the product associated with this line item. | |
| Title | String | The title of the product or variant. For custom line items, this field represents the manually entered item name. | |
| VariantTitle | String | The title or name of the specific product variant associated with the line item. | |
| Custom | Bool | Indicates whether the line item is custom (true) or linked to an existing product variant (false). Custom items are manually defined rather than pulled from the product catalog. | |
| Quantity | Int | The number of product or variant units requested in the draft order. | |
| Sku | String | The stock keeping unit (SKU) identifier of the product variant. | |
| Taxable | Bool | Specifies whether the product variant is subject to tax calculations. | |
| Vendor | String | The name of the vendor or supplier associated with the product variant. | |
| RequiresShipping | Bool | Indicates whether this item requires physical shipping. True for tangible products and false for digital or service-based items. | |
| IsGiftCard | Bool | Specifies whether the line item represents a gift card product. | |
| AppliedDiscountTitle | String | The name of any order-level discount applied to the draft order. | |
| AppliedDiscountDescription | String | A descriptive label explaining the type or reason for the applied discount. | |
| AppliedDiscountValue | Double | The numeric value of the discount. If the value type is 'percentage', this represents the percentage off. | |
| AppliedDiscountValueType | String | The type of discount value applied, such as 'percentage' or 'fixed_amount'. | |
| AppliedDiscountAmountV2Amount | Decimal | The total discounted amount applied to the order, represented as a decimal monetary value. | |
| AppliedDiscountAmountV2CurrencyCode | String | The ISO currency code corresponding to the discount amount. | |
| DiscountedTotalSetPresentmentMoneyAmount | Decimal | The total discounted price for this line item in the customer's presentment currency. | |
| DiscountedTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the discounted total in the presentment currency. | |
| DiscountedTotalSetShopMoneyAmount | Decimal | The total discounted price for this line item in the shop's primary currency. | |
| DiscountedTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the discounted total in the shop currency. | |
| DiscountedUnitPriceSetPresentmentMoneyAmount | Decimal | The per-unit discounted price of the product in the customer's presentment currency. | |
| DiscountedUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the discounted per-unit price in the presentment currency. | |
| DiscountedUnitPriceSetShopMoneyAmount | Decimal | The per-unit discounted price of the product in the shop's primary currency. | |
| DiscountedUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the discounted per-unit price in the shop currency. | |
| FulfillmentServiceId | String | The unique identifier of the fulfillment service responsible for fulfilling this line item. | |
| ImageId | String | A unique identifier for the product image associated with this line item. | |
| ImageWidth | Int | The original width of the associated image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| ImageAltText | String | A short descriptive phrase conveying the content or purpose of the image for accessibility or SEO. | |
| ImageHeight | Int | The original height of the associated image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| ImageUrl | String | The direct URL to the product image associated with this line item. | |
| OriginalTotalSetPresentmentMoneyAmount | Decimal | The total pre-discount price for this line item in the customer's presentment currency. | |
| OriginalTotalSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the pre-discount total in the presentment currency. | |
| OriginalTotalSetShopMoneyAmount | Decimal | The total pre-discount price for this line item in the shop's primary currency. | |
| OriginalTotalSetShopMoneyCurrencyCode | String | The ISO currency code for the pre-discount total in the shop currency. | |
| OriginalUnitPriceSetPresentmentMoneyAmount | Decimal | The original per-unit price of the item before discounts in the customer's presentment currency. | |
| OriginalUnitPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the original per-unit price in the presentment currency. | |
| OriginalUnitPriceSetShopMoneyAmount | Decimal | The original per-unit price of the item before discounts in the shop's primary currency. | |
| OriginalUnitPriceSetShopMoneyCurrencyCode | String | The ISO currency code for the original per-unit price in the shop currency. | |
| ProductId | String | The globally unique identifier of the product associated with this line item. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total amount of discount applied to this line item in the customer's presentment currency. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the total discount in the presentment currency. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total discount applied to this line item in the shop's primary currency. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The ISO currency code for the total discount in the shop currency. | |
| VariantId | String | The globally unique identifier of the product variant associated with this line item. | |
| WeightValue | Double | The numeric value representing the product's weight, used for shipping and fulfillment calculations. | |
| WeightUnit | String | The unit of measurement for the weight value (for example, 'g', 'kg', 'oz', or 'lb'). |