ODBC Driver for Shopify

Build 24.0.9062

AbandonmentProductsViewed

Returns the products viewed during the customer abandoned visit.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062