DraftOrderItems
Query draft order items.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the DraftOrderId. The supported SQL operators are '=' for DraftOrderId. The adapter processes other filters client-side within the adapter.
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. |