Query order item properties.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId column. The supported SQL operators are '=' for OrderId. The connector processes other filters client-side within the connector.

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 OrderItemProperties WHERE OrderId = '123'

Columns

Name	Type	References	Description
LineNumber [KEY]	Long		A unique numeric identifier for the table.
ItemId	Long	OrdersItems.ItemId	The id of the order item. Only available for orders.
OrderId	Long	Orders.Id	The id of the order.
Name	String		The name of the item property.
Value	String		The value of the item property.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.