Returns the products viewed during the customer abandoned visit.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

• AbandonmentId supports the '=' comparison operator.
• AbandonedCheckoutPayloadId supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM AbandonmentProductsViewed WHERE AbandonmentId='VALUE'

SELECT * FROM AbandonmentProductsViewed WHERE AbandonedCheckoutPayloadId='VALUE'

Columns

Name	Type	References	Description
AbandonmentId [KEY]	String	Abandonment.Id	A globally-unique ID.
AbandonedCheckoutPayloadId	String		A globally-unique ID.
ProductId [KEY]	String		A globally-unique ID.
VariantId	String		A globally-unique ID.
Quantity	Int		The quantity of the product that the customer requested.