ODBC Driver for Shopify

Build 24.0.9060

AbandonmentProductsAddedToCart

Returns the products added to the cart during the customer abandoned visit.

View-Specific Information

Select

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

  • AbandonmentId supports the '=,IN' comparison operators.
  • AbandonedCheckoutPayloadId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM AbandonmentProductsAddedToCart
  SELECT * FROM AbandonmentProductsAddedToCart WHERE AbandonmentId = 'Val1'
  SELECT * FROM AbandonmentProductsAddedToCart WHERE AbandonedCheckoutPayloadId = 'Val1'

Columns

Name Type References Description
AbandonmentId [KEY] String A globally-unique ID.
AbandonedCheckoutPayloadId String A globally-unique ID.
ProductId 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.9060