AbandonmentProductsViewed
Returns the products viewed during the customer abandoned visit.
View-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- AbandonmentId supports the '=,IN' comparison operators.
- AbandonedCheckoutPayloadId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM AbandonmentProductsViewed
SELECT * FROM AbandonmentProductsViewed WHERE AbandonmentId = 'Val1'
SELECT * FROM AbandonmentProductsViewed WHERE AbandonedCheckoutPayloadId = 'Val1'
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. |