Query abandoned checkouts items.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The connector processes other filters client-side within the connector. 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	Products.Id	The product ID od the item.
ItemVariantId [KEY]	Long	ProductVariants.Id	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.
ItemGrams	Int		The weight of the item in grams.
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.
FulFillmentsService	String		The fulfillment service provider for the item.
CreatedAt	Datetime		The date and time when the order was created.
UpdatedAt	Datetime		The date and time when the order was last modified.