DraftOrderItems
Query draft order items.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the DraftOrderId. The supported SQL operators are '=' for DraftOrderId. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
For example, the following queries are processed server side.
SELECT * FROM DraftOrderItems
SELECT * FROM DraftOrderItems WHERE DraftOrderId = '123'
Columns
Name | Type | References | Description |
ItemId | 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 | Boolean | States whether this is a custom line item or a product variant line item | |
FulfillableQuantity | Integer | The amount available to fulfill. | |
FulFillmentsService | String | Service provider responsible for fulfillment. | |
ItemGrams | Integer | The weight of the item in grams. | |
ItemPrice | Decimal | The price of the item before discounts have been applied. | |
ItemQuantity | Integer | The number of products that were purchased. | |
RequiresShipping | Boolean | 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 | 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 | Boolean | States whether or not the product is a gift card. | |
Properties | String | Shows custom properties for this order item. | |
Taxable | Boolean | 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. |