CData Python Connector for Shopify

Build 24.0.9060

Abandonment

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

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

For example, the following queries are processed server side:

  SELECT * FROM Abandonment
  SELECT * FROM Abandonment WHERE Id = 'Val1'
  SELECT * FROM Abandonment WHERE AbandonedCheckoutPayloadId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
AppId String A globally-unique ID.
CustomerId String A globally-unique ID.
AbandonmentType String The abandonment type.
EmailState String The email state (e.g., sent or not sent).
InventoryAvailable Bool Whether the products in abandonment are available.
EmailSentAt Datetime When the email was sent, if that is the case.
MostRecentStep String The most recent step type.
VisitStartedAt Datetime The date and time when the visit started.
IsFromOnlineStore Bool Whether the abandonment event comes from the Online Store sales channel.
IsFromShopApp Bool Whether the abandonment event comes from the Shop app sales channel.
IsFromShopPay Bool Whether the abandonment event comes from Shop Pay.
IsMostSignificantAbandonment Bool Whether the customer did not complete another most significant step since this abandonment.
LastBrowseAbandonmentDate Datetime The date for the latest browse abandonment.
LastCartAbandonmentDate Datetime The date for the latest cart abandonment.
LastCheckoutAbandonmentDate Datetime The date for the latest checkout abandonment.
DaysSinceLastAbandonmentEmail Int The number of days since the last abandonment email was sent to the customer.
HoursSinceLastAbandonedCheckout Double The number of hours since the customer has last abandoned a checkout.
CustomerHasNoOrderSinceAbandonment Bool Whether the customer has completed an order since this checkout has been abandoned.
CreatedAt Datetime The date and time when the abandonment was created.
AbandonedCheckoutPayloadId String A globally-unique ID.
AbandonedCheckoutPayloadDefaultCursor String A default cursor that returns the single next record, sorted ascending by ID.
AbandonedCheckoutPayloadAbandonedCheckoutUrl String The URL for the buyer to recover their checkout.
AbandonedCheckoutPayloadLineItemsQuantity Int The number of products in the checkout.

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