CData Python Connector for Shopify

Build 23.0.8839

DraftOrderItems

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839