Query order items.

View-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns and the Type pseudo column. The supported SQL operators are '=' for OrderId and Type and '>' and '<' for OrderUpdatedAt. The adapter processes other filters client-side within the adapter.

For example, the following queries are processed server-side. You can set the Type pseudo column to "DraftOrder" to list order items belonging to draft orders instead of orders, or you can set Type to "AbandonedCheckout" to list order items belonging to abandoned checkouts.

SELECT * FROM OrderItems WHERE OrderId = '123'

SELECT * FROM OrderItems WHERE OrderUpdatedAt > '2018-05-10'

SELECT * FROM OrderItems WHERE Type = 'DraftOrder'

SELECT * FROM OrderItems WHERE Type = 'AbandonedCheckout'

Columns

Name	Type	References	Description
ItemId [KEY]	Long		The id of the order item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
ProductId	Long	Products.Id	The id of the of the product beloning to the order item.
ItemVariantId	Long	ProductVariants.Id	The id of the product variant.
ItemTitle	String		The title of the product.
Name	String		The name of the product variant.
ItemQuantity	Int		The number of products that were purchased.
ItemPrice	Decimal		The price of the item before discounts have been applied.
ItemGrams	Int		The weight of the item in grams.
SKU	String		A unique identifier of the item in the fulfillment.
VariantTitle	String		The title of the product variant.
Properties	String		Shows custom properties for this order item.
Vendor	String		The name of the supplier of the item.
FulFillmentsService	String		Service provider who is doing the fulfillment.
RequiresShipping	Bool		States whether or not the fulfillment requires shipping.
Taxable	Bool		States whether or not the product was taxable.
GiftCard	Bool		States whether or not the order item is a gift card.
FulfillableQuantity	Int		The amount available to fulfill.
TotalDiscount	Decimal		The total discount amount applied to this order item.
FulfillmentStatus	String		How far along an order is in terms order items fulfilled.
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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.

Name	Type	Description
Type	String		The type of order item, can be one of the following(Order, DraftOrder, AbandonedCheckout).
Status	String		Filter orders by their status. Valid values are: open: show only open orders, closed: show only closed orders, cancelled: show only canceled orders, any: show orders of any status,default: open.