Abandonment
Returns abandonment.
View-Specific Information
Select
The cmdlet uses the Shopify API to process WHERE clause conditions built with the following columns and operators:- Id supports the '=' comparison operator.
- AbandonedCheckoutPayloadId supports the '=' comparison operator.
The cmdlet processes other filters client-side within the cmdlet.
For example, the following queries are processed server-side:
SELECT * FROM Abandonment WHERE Id='VALUE'
SELECT * FROM Abandonment WHERE AbandonedCheckoutPayloadId='VALUE'
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. |