AbandonedCheckouts

Returns abandoned checkout sessions with customer, cart, and timing details for recovery.

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		The globally unique identifier of the abandoned checkout.
Name	String		A merchant-facing identifier that uniquely identifies this checkout in Shopify.
AbandonedCheckoutUrl	String		The URL that allows the buyer to return and complete their abandoned checkout.
CustomerId	String		The globally unique identifier of the customer associated with this abandoned checkout.
DiscountCodes	String		One or more discount codes entered by the buyer during checkout.
Note	String		A private note recorded by the merchant for this checkout, not visible to the buyer.
TaxesIncluded	Bool		Indicates whether line item and shipping prices already include taxes.
UpdatedAt	Datetime		The date and time when the abandoned checkout was last updated.
CreatedAt	Datetime		The date and time when the abandoned checkout was created.
CompletedAt	Datetime		The date and time when the buyer successfully completed the checkout. Returns null if the checkout remains incomplete.
BillingAddressCoordinatesValidated	Bool		Indicates whether the billing address corresponds to recognized latitude and longitude values.
BillingAddressId	String		The globally unique identifier of the billing address associated with this checkout.
BillingAddressValidationResultSummary	String		The result of address validation for the billing address, as reported in the Shopify Admin.
BillingAddressFirstName	String		The first name of the customer listed on the billing address.
BillingAddressLastName	String		The last name of the customer listed on the billing address.
BillingAddressName	String		The full name of the customer on the billing address, based on first and last name.
BillingAddressAddress1	String		The first line of the billing address, usually a street address or PO Box.
BillingAddressAddress2	String		The second line of the billing address, usually an apartment, suite, or unit number.
BillingAddressCity	String		The city, town, district, or village of the billing address.
BillingAddressCompany	String		The company or organization name provided in the billing address.
BillingAddressCountry	String		The full country name of the billing address.
BillingAddressCountryCode	String		The two-letter country code of the billing address, such as US.
BillingAddressFormattedArea	String		A comma-separated list combining the city, province, and country for the billing address.
BillingAddressLatitude	Double		The latitude coordinate of the billing address.
BillingAddressLongitude	Double		The longitude coordinate of the billing address.
BillingAddressPhone	String		The phone number listed with the billing address.
BillingAddressProvince	String		The province, state, or district of the billing address.
BillingAddressProvinceCode	String		The region code for the billing address, such as 'ON', for Ontario.
BillingAddressZip	String		The postal or ZIP code of the billing address.
BillingAddressTimeZone	String		The time zone associated with the billing address.
ShippingAddressCoordinatesValidated	Bool		Indicates whether the shipping address corresponds to recognized latitude and longitude values.
ShippingAddressId	String		The globally unique identifier of the shipping address associated with this checkout.
ShippingAddressValidationResultSummary	String		The result of address validation for the shipping address, as reported in the Shopify Admin.
ShippingAddressFirstName	String		The first name of the customer listed on the shipping address.
ShippingAddressLastName	String		The last name of the customer listed on the shipping address.
ShippingAddressName	String		The full name of the customer on the shipping address, based on first and last name.
ShippingAddressAddress1	String		The first line of the shipping address, usually a street address or PO Box.
ShippingAddressAddress2	String		The second line of the shipping address, usually an apartment, suite, or unit number.
ShippingAddressCity	String		The city, town, district, or village of the shipping address.
ShippingAddressCompany	String		The company or organization name provided in the shipping address.
ShippingAddressCountry	String		The full country name of the shipping address.
ShippingAddressCountryCode	String		The two-letter country code of the shipping address, such as US.
ShippingAddressFormattedArea	String		A comma-separated list combining the city, province, and country for the shipping address.
ShippingAddressLatitude	Double		The latitude coordinate of the shipping address.
ShippingAddressLongitude	Double		The longitude coordinate of the shipping address.
ShippingAddressPhone	String		The phone number listed with the shipping address.
ShippingAddressProvince	String		The province, state, or district of the shipping address.
ShippingAddressProvinceCode	String		The region code for the shipping address, such as 'ON' for Ontario.
ShippingAddressZip	String		The postal or ZIP code of the shipping address.
ShippingAddressTimeZone	String		The time zone associated with the shipping address.
SubtotalPriceSetPresentmentMoneyAmount	Decimal		The subtotal price of all line items before discounts, expressed as a decimal money amount in the presentment currency.
SubtotalPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the subtotal price of the line items before discounts.
SubtotalPriceSetShopMoneyAmount	Decimal		The subtotal price of all line items before discounts, expressed as a decimal money amount in the shop's base currency.
SubtotalPriceSetShopMoneyCurrencyCode	String		The shop currency code for the subtotal price of the line items before discounts.
TotalDiscountSetPresentmentMoneyAmount	Decimal		The total value of all discounts applied, expressed as a decimal money amount in the presentment currency.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the total discount value.
TotalDiscountSetShopMoneyAmount	Decimal		The total value of all discounts applied, expressed as a decimal money amount in the shop's base currency.
TotalDiscountSetShopMoneyCurrencyCode	String		The shop currency code for the total discount value.
TotalDutiesSetPresentmentMoneyAmount	Decimal		The total duties charged for this checkout, expressed as a decimal money amount in the presentment currency.
TotalDutiesSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the duties total.
TotalDutiesSetShopMoneyAmount	Decimal		The total duties charged for this checkout, expressed as a decimal money amount in the shop's base currency.
TotalDutiesSetShopMoneyCurrencyCode	String		The shop currency code for the duties total.
TotalLineItemsPriceSetPresentmentMoneyAmount	Decimal		The combined price of all line items before taxes and duties, expressed as a decimal money amount in the presentment currency.
TotalLineItemsPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the combined line item price before taxes and duties.
TotalLineItemsPriceSetShopMoneyAmount	Decimal		The combined price of all line items before taxes and duties, expressed as a decimal money amount in the shop's base currency.
TotalLineItemsPriceSetShopMoneyCurrencyCode	String		The shop currency code for the combined line item price before taxes and duties.
TotalPriceSetPresentmentMoneyAmount	Decimal		The final checkout total including line items, shipping, taxes, and duties, expressed as a decimal money amount in the presentment currency.
TotalPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the final checkout total.
TotalPriceSetShopMoneyAmount	Decimal		The final checkout total including line items, shipping, taxes, and duties, expressed as a decimal money amount in the shop's base currency.
TotalPriceSetShopMoneyCurrencyCode	String		The shop currency code for the final checkout total.
TotalTaxSetPresentmentMoneyAmount	Decimal		The total taxes applied to the checkout, expressed as a decimal money amount in the presentment currency.
TotalTaxSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the total taxes applied.
TotalTaxSetShopMoneyAmount	Decimal		The total taxes applied to the checkout, expressed as a decimal money amount in the shop's base currency.
TotalTaxSetShopMoneyCurrencyCode	String		The shop currency code for the total taxes applied.
Status	String		The current status of the abandoned checkout, such as open or completed. The allowed values are open, closed.
EmailState	String		The status of recovery emails sent for this abandoned checkout. The allowed values are sent, not_sent, scheduled, suppressed.
RecoveryState	String		The current recovery state of the abandoned checkout, such as recovered or unrecovered. The allowed values are open, closed.

Tableau Connector for Shopify

AbandonedCheckouts

View-Specific Information

Select

Columns