Query draft order items.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the DraftOrderId. The supported SQL operators are '=' for DraftOrderId. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side.

SELECT * FROM DraftOrderItems WHERE DraftOrderId = '123'

Columns

Name	Type	References	Description
ItemId [KEY]	Long		The id of the line item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
ProductId	Long	Products.Id	The ID of the product corresponding to the line item product variant.
Custom	Bool		States whether this is a custom line item or a product variant line item
FulfillableQuantity	Int		The amount available to fulfill.
FulFillmentsService	String		Service provider responsible for fulfillment.
ItemGrams	Int		The weight of the item in grams.
ItemPrice	Decimal		The price of the item before discounts have been applied.
ItemQuantity	Int		The number of products that were purchased.
RequiresShipping	Bool		States whether or not the fulfillment requires shipping.
SKU	String		A unique identifier of the item in the fulfillment.
ItemTitle	String		The title of the product or variant.
ItemVariantId	Long	ProductVariants.Id	The id of the product variant.
VariantTitle	String		The title of the product variant.
Vendor	String		The name of the supplier of the item.
Name	String		The name of the product variant.
GiftCard	Bool		States whether or not the product is a gift card.
Properties	String		Shows custom properties for this order item.
Taxable	Bool		States whether or not the product was taxable.
TaxLines	String		Shows tax lines for this order item.
AppliedDiscountTitle	String		The title of the applied discount for this order. Only available for draft orders.
AppliedDiscountDescription	String		The description of the applied discount for order. Only available for draft orders.
AppliedDiscountValue	Decimal		The value of the applied discount for this order. Only available for draft orders.
AppliedDiscountValueType	String		The value type of the applied discount for order. Only available for draft orders.
AppliedDiscountAmount	Decimal		The amount of the applied discount for this order. Only available for draft orders.