Power BI Connector for Shopify

Build 25.0.9454

DraftOrderItems

Shows line items included in draft orders, with product, quantity, and pricing details.

Columns

Name Type References Description
ItemId [KEY] Long The unique numeric identifier of the draft order line item.
DraftOrderId Long

DraftOrders.Id

The unique numeric identifier of the draft order associated with this line item.
ProductId Long The unique numeric identifier of the product corresponding to this line item's variant.
Custom Bool Indicates whether this line item is custom (manually added) or linked to a product variant.
FulfillableQuantity Int The number of units from this line item that are available for fulfillment.
FulFillmentsService String The service provider or fulfillment method responsible for fulfilling this line item.
ItemGrams Int The weight of the line item in grams, used for shipping and fulfillment calculations.
ItemPrice Decimal The unit price of the item before applying any discounts.
ItemQuantity Int The quantity of this product or variant included in the draft order.
RequiresShipping Bool Indicates whether the line item requires physical shipping.
SKU String The unique stock keeping unit (SKU) assigned to the product variant.
ItemTitle String The title of the product or variant at the time the draft order was created.
ItemVariantId Long The unique numeric identifier of the product variant associated with this line item.
VariantTitle String The display title of the product variant as it appears in the draft order.
Vendor String The name of the vendor or supplier for this product.
Name String The concatenated name of the product and variant (for example, 'T-Shirt - Large / Blue').
GiftCard Bool Indicates whether this line item represents a gift card purchase.
Properties String A JSON aggregate listing any custom properties or buyer notes associated with the line item.
Taxable Bool Indicates whether the item is subject to tax.
TaxLines String A JSON aggregate detailing the applicable tax lines for this line item.
AppliedDiscountTitle String The title of the discount applied to this line item. Available only for draft orders.
AppliedDiscountDescription String A description of the discount applied to this line item. Available only for draft orders.
AppliedDiscountValue Decimal The numerical value of the discount applied to this line item. Available only for draft orders.
AppliedDiscountValueType String The type of discount value applied (for example, 'percentage' or 'fixed_amount'). Available only for draft orders.
AppliedDiscountAmount Decimal The total discounted amount applied to this line item. Available only for draft orders.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454