Query abandoned checkouts items.

View-Specific Information

Select

The driver uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The driver processes other filters client-side within the driver. For example, the following queries are processed server-side.

SELECT * FROM AbandonedCheckoutsItems WHERE CreatedAt > '2017-10-25'

Columns

Name	Type	References	Description
AbandonedCheckoutId [KEY]	Long	AbandonedCheckouts.Id	The unique numeric identifier for the order.
ProductId [KEY]	Long		The product ID od the item.
ItemVariantId [KEY]	Long		The product variant ID of item.
ItemTitle	String		The title of the product.
ItemQuantity	Int		The number of products that were purchased.
ItemPrice	Decimal		The price of the item in presentment currency.
SKU	String		A unique identifier for the item in the shop.
VariantTitle	String		The title of the product variant.
Vendor	String		The name of the item's supplier.
CreatedAt	Datetime		The date and time when the order was created.
UpdatedAt	Datetime		The date and time when the order was last modified.