DraftOrderLineItems

Lists the line items included in a draft order with quantities and prices.

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.

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		The globally unique identifier of the draft order line item.
DraftOrderId	String	DraftOrders.Id	The globally unique identifier of the draft order that contains this line item.
Name	String		The display name of the product in the line item.
Title	String		The title of the product or variant. Applies only to custom line items.
VariantTitle	String		The title of the product variant included in the draft order.
Custom	Bool		Indicates whether the line item is a custom line item (true) or a product variant line item (false).
Quantity	Int		The number of product variants requested in the draft order.
Sku	String		The stock keeping unit (SKU) of the product variant.
Taxable	Bool		Indicates whether the product variant is taxable.
Vendor	String		The vendor associated with the product variant.
RequiresShipping	Bool		Indicates whether the product variant requires physical shipping.
IsGiftCard	Bool		Indicates whether the line item represents a gift card.
AppliedDiscountTitle	String		The title of the order-level discount applied to this line item.
AppliedDiscountDescription	String		The description of the order-level discount applied to this line item.
AppliedDiscountValue	Double		The value of the order-level discount. If the value type is 'percentage', this field represents the discount percentage.
AppliedDiscountValueType	String		The type of discount applied at the order level, such as percentage or fixed amount.
AppliedDiscountAmountV2Amount	Decimal		The discount amount applied to the line item, expressed as a decimal money value.
AppliedDiscountAmountV2CurrencyCode	String		The currency code of the discount amount applied to the line item.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		The total price of the line item after discounts, in the presentment currency, expressed as a decimal money value.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code of the discounted total in the presentment currency.
DiscountedTotalSetShopMoneyAmount	Decimal		The total price of the line item after discounts, in the shop currency, expressed as a decimal money value.
DiscountedTotalSetShopMoneyCurrencyCode	String		The currency code of the discounted total in the shop currency.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The per-unit price of the line item after discounts, in the presentment currency, expressed as a decimal money value.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code of the discounted per-unit price in the presentment currency.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The per-unit price of the line item after discounts, in the shop currency, expressed as a decimal money value.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The currency code of the discounted per-unit price in the shop currency.
FulfillmentServiceId	String		The identifier of the fulfillment service responsible for fulfilling the line item.
ImageId	String		The unique identifier of the product image associated with the line item.
ImageWidth	Int		The original width of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageAltText	String		Alternative text describing the content or purpose of the product image.
ImageHeight	Int		The original height of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageUrl	String		The URL of the product image.
OriginalTotalSetPresentmentMoneyAmount	Decimal		The original total price of the line item before discounts, in the presentment currency, expressed as a decimal money value.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code of the original total in the presentment currency.
OriginalTotalSetShopMoneyAmount	Decimal		The original total price of the line item before discounts, in the shop currency, expressed as a decimal money value.
OriginalTotalSetShopMoneyCurrencyCode	String		The currency code of the original total in the shop currency.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The original per-unit price of the line item before discounts, in the presentment currency, expressed as a decimal money value.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code of the original per-unit price in the presentment currency.
OriginalUnitPriceSetShopMoneyAmount	Decimal		The original per-unit price of the line item before discounts, in the shop currency, expressed as a decimal money value.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		The currency code of the original per-unit price in the shop currency.
ProductId	String		The globally unique identifier of the product associated with the line item.
TotalDiscountSetPresentmentMoneyAmount	Decimal		The total discount applied to the line item, in the presentment currency, expressed as a decimal money value.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		The currency code of the total discount in the presentment currency.
TotalDiscountSetShopMoneyAmount	Decimal		The total discount applied to the line item, in the shop currency, expressed as a decimal money value.
TotalDiscountSetShopMoneyCurrencyCode	String		The currency code of the total discount in the shop currency.
VariantId	String		The globally unique identifier of the product variant included in the line item.
WeightValue	Double		The numerical weight of the line item based on the unit system specified in WeightUnit.
WeightUnit	String		The unit of measurement used for the weight value, such as grams or kilograms.

JDBC Driver for Shopify

DraftOrderLineItems

View-Specific Information

Select

Columns