AbandonmentProductsAddedToCart
Lists products customers added to cart during sessions that ended in abandonment.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- AbandonmentId supports the '=, IN' comparison operators.
- AbandonedCheckoutPayloadId supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM AbandonmentProductsAddedToCart WHERE AbandonmentId = 'Val1'
SELECT * FROM AbandonmentProductsAddedToCart WHERE AbandonedCheckoutPayloadId = 'Val1'
Columns
| Name | Type | References | Description |
| AbandonmentId | String | The globally unique identifier of the abandonment event this cart addition is associated with. | |
| AbandonedCheckoutPayloadId [KEY] | String | The globally unique identifier of the abandoned checkout payload connected to this cart addition. | |
| ProductId [KEY] | String | The globally unique identifier of the product that was added to the cart. | |
| VariantId [KEY] | String | The globally unique identifier of the specific product variant added to the cart. | |
| Quantity | Int | The number of units of the product variant that the customer added to the cart. |