AbandonedCheckouts
Displays all checkouts that customers started but didn't complete, supporting cart recovery analytics and remarketing.
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.
- UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
- CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
- Status supports the '=, !=' comparison operators.
- EmailState supports the '=, !=' comparison operators.
- RecoveryState supports the '=, !=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM AbandonedCheckouts WHERE Id = 'Val1'
SELECT * FROM AbandonedCheckouts WHERE UpdatedAt = '2023-01-01 11:10:00'
SELECT * FROM AbandonedCheckouts WHERE CreatedAt = '2023-01-01 11:10:00'
SELECT * FROM AbandonedCheckouts WHERE Status = 'open'
SELECT * FROM AbandonedCheckouts WHERE EmailState = 'sent'
SELECT * FROM AbandonedCheckouts WHERE RecoveryState = 'open'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the abandoned checkout record. | |
| Name | String | The merchant-facing reference name used to identify the checkout in reports or dashboards. | |
| AbandonedCheckoutUrl | String | A recovery link that allows the buyer to return and complete their abandoned checkout. | |
| CustomerId | String | The unique identifier of the customer who initiated the checkout. | |
| DiscountCodes | String | The discount codes that the buyer entered during checkout, separated by commas if multiple were applied. | |
| Note | String | A private note added by the merchant to the checkout, not visible to the buyer. | |
| TaxesIncluded | Bool | Indicates whether tax amounts were included in the item and shipping prices at checkout. | |
| UpdatedAt | Datetime | The timestamp indicating when the checkout record was last modified. | |
| CreatedAt | Datetime | The timestamp for when the checkout session was originally created. | |
| CompletedAt | Datetime | The timestamp for when the checkout was successfully completed, or null if incomplete. | |
| BillingAddressCoordinatesValidated | Bool | Indicates whether the billing address was successfully mapped to valid geographic coordinates. | |
| BillingAddressId | String | A unique identifier for the billing address associated with the checkout. | |
| BillingAddressValidationResultSummary | String | A summary of the billing address validation status as determined by Shopify's address verification process. | |
| BillingAddressFirstName | String | The first name provided in the billing address. | |
| BillingAddressLastName | String | The last name provided in the billing address. | |
| BillingAddressName | String | The full billing name, constructed from the first and last name fields. | |
| BillingAddressAddress1 | String | The first address line, typically including street address or PO Box information. | |
| BillingAddressAddress2 | String | The second address line, such as apartment, suite, or unit number. | |
| BillingAddressCity | String | The name of the city or locality for the billing address. | |
| BillingAddressCompany | String | The name of the company or organization provided in the billing address, if applicable. | |
| BillingAddressCountry | String | The full name of the billing address country. | |
| BillingAddressCountryCode | String | The two-letter country code (ISO 3166-1 alpha-2) for the billing address, such as US or CA. | |
| BillingAddressFormattedArea | String | A formatted list combining city, province, and country values for the billing address. | |
| BillingAddressLatitude | Double | The geographic latitude value of the billing address location. | |
| BillingAddressLongitude | Double | The geographic longitude value of the billing address location. | |
| BillingAddressPhone | String | The phone number associated with the billing contact. | |
| BillingAddressProvince | String | The region, province, or state for the billing address. | |
| BillingAddressProvinceCode | String | The short regional code for the billing province or state, such as ON for Ontario. | |
| BillingAddressZip | String | The postal or zip code of the billing address. | |
| BillingAddressTimeZone | String | The local time zone corresponding to the billing address region. | |
| ShippingAddressCoordinatesValidated | Bool | Indicates whether the shipping address was successfully mapped to valid geographic coordinates. | |
| ShippingAddressId | String | A unique identifier for the shipping address associated with the checkout. | |
| ShippingAddressValidationResultSummary | String | A summary of the shipping address validation status as determined by Shopify's address verification process. | |
| ShippingAddressFirstName | String | The first name provided in the shipping address. | |
| ShippingAddressLastName | String | The last name provided in the shipping address. | |
| ShippingAddressName | String | The full name used for shipping, constructed from the first and last name fields. | |
| ShippingAddressAddress1 | String | The first line of the shipping address, typically including street address or PO Box information. | |
| ShippingAddressAddress2 | String | The second line of the shipping address, such as apartment, suite, or unit number. | |
| ShippingAddressCity | String | The city or locality of the shipping address. | |
| ShippingAddressCompany | String | The company or organization name listed on the shipping address, if provided. | |
| ShippingAddressCountry | String | The full country name for the shipping address. | |
| ShippingAddressCountryCode | String | The two-letter country code (ISO 3166-1 alpha-2) for the shipping address, such as US or GB. | |
| ShippingAddressFormattedArea | String | A formatted list combining city, province, and country values for the shipping address. | |
| ShippingAddressLatitude | Double | The geographic latitude value of the shipping address location. | |
| ShippingAddressLongitude | Double | The geographic longitude value of the shipping address location. | |
| ShippingAddressPhone | String | The phone number associated with the shipping contact. | |
| ShippingAddressProvince | String | The region, province, or state for the shipping address. | |
| ShippingAddressProvinceCode | String | The short regional code for the shipping province or state, such as CA for California. | |
| ShippingAddressZip | String | The postal or zip code of the shipping address. | |
| ShippingAddressTimeZone | String | The local time zone corresponding to the shipping address region. | |
| SubtotalPriceSetPresentmentMoneyAmount | Decimal | The subtotal amount before taxes and discounts in the customer's presentment currency. | |
| SubtotalPriceSetPresentmentMoneyCurrencyCode | String | The currency code for the subtotal in the presentment currency. | |
| SubtotalPriceSetShopMoneyAmount | Decimal | The subtotal amount before taxes and discounts in the shop's base currency. | |
| SubtotalPriceSetShopMoneyCurrencyCode | String | The currency code for the subtotal in the shop's base currency. | |
| TotalDiscountSetPresentmentMoneyAmount | Decimal | The total amount of discounts applied in the customer's presentment currency. | |
| TotalDiscountSetPresentmentMoneyCurrencyCode | String | The currency code for the total discounts in the presentment currency. | |
| TotalDiscountSetShopMoneyAmount | Decimal | The total amount of discounts applied in the shop's base currency. | |
| TotalDiscountSetShopMoneyCurrencyCode | String | The currency code for the total discounts in the shop's base currency. | |
| TotalDutiesSetPresentmentMoneyAmount | Decimal | The total value of duties applied to the checkout in the presentment currency. | |
| TotalDutiesSetPresentmentMoneyCurrencyCode | String | The currency code for duties in the presentment currency. | |
| TotalDutiesSetShopMoneyAmount | Decimal | The total value of duties applied to the checkout in the shop's base currency. | |
| TotalDutiesSetShopMoneyCurrencyCode | String | The currency code for duties in the shop's base currency. | |
| TotalLineItemsPriceSetPresentmentMoneyAmount | Decimal | The combined total of all line item prices in the presentment currency before additional fees or discounts. | |
| TotalLineItemsPriceSetPresentmentMoneyCurrencyCode | String | The currency code for line item totals in the presentment currency. | |
| TotalLineItemsPriceSetShopMoneyAmount | Decimal | The combined total of all line item prices in the shop's base currency before additional fees or discounts. | |
| TotalLineItemsPriceSetShopMoneyCurrencyCode | String | The currency code for line item totals in the shop's base currency. | |
| TotalPriceSetPresentmentMoneyAmount | Decimal | The final total checkout amount, including taxes, discounts, and duties, in the presentment currency. | |
| TotalPriceSetPresentmentMoneyCurrencyCode | String | The currency code for the final checkout total in the presentment currency. | |
| TotalPriceSetShopMoneyAmount | Decimal | The final total checkout amount, including taxes, discounts, and duties, in the shop's base currency. | |
| TotalPriceSetShopMoneyCurrencyCode | String | The currency code for the final checkout total in the shop's base currency. | |
| TotalTaxSetPresentmentMoneyAmount | Decimal | The total amount of taxes applied in the presentment currency. | |
| TotalTaxSetPresentmentMoneyCurrencyCode | String | The currency code for taxes in the presentment currency. | |
| TotalTaxSetShopMoneyAmount | Decimal | The total amount of taxes applied in the shop's base currency. | |
| TotalTaxSetShopMoneyCurrencyCode | String | The currency code for taxes in the shop's base currency. | |
| Status | String | The current checkout status.
The allowed values are open, closed. | |
| EmailState | String | The status of email communications related to the checkout, such as sent or unsent.
The allowed values are sent, not_sent, scheduled, suppressed. | |
| RecoveryState | String | The state of recovery for the abandoned checkout.
The allowed values are open, closed. |