AbandonedCheckouts

List checkouts that were abandoned by customers.

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.

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 globally-unique ID.
Name	String		Unique merchant-facing identifier for the checkout.
AbandonedCheckoutUrl	String		The URL for the buyer to recover their checkout.
CustomerId	String		A globally-unique ID.
DiscountCodes	String		The discount codes entered by the buyer at checkout.
Note	String		A merchant-facing note added to the checkout. Not visible to the buyer.
TaxesIncluded	Bool		Whether taxes are included in line item and shipping line prices.
UpdatedAt	Datetime		The date and time when the checkout was most recently updated.
CreatedAt	Datetime		The date and time when the checkout was created.
CompletedAt	Datetime		The date and time when the buyer completed the checkout. Null if the checkout has not been completed.
BillingAddressCoordinatesValidated	Bool		Whether the address corresponds to recognized latitude and longitude values.
BillingAddressId	String		A globally-unique ID.
BillingAddressValidationResultSummary	String		The validation status that is leveraged by the address validation feature in the Shopify Admin.
BillingAddressFirstName	String		The first name of the customer.
BillingAddressLastName	String		The last name of the customer.
BillingAddressName	String		The full name of the customer, based on firstName and lastName.
BillingAddressAddress1	String		The first line of the address. Typically the street address or PO Box number.
BillingAddressAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
BillingAddressCity	String		The name of the city, district, village, or town.
BillingAddressCompany	String		The name of the customer's company or organization.
BillingAddressCountry	String		The name of the country.
BillingAddressCountryCode	String		The two-letter code for the country of the address. For example, US.
BillingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
BillingAddressLatitude	Double		The latitude coordinate of the customer address.
BillingAddressLongitude	Double		The longitude coordinate of the customer address.
BillingAddressPhone	String		A unique phone number for the customer.
BillingAddressProvince	String		The region of the address, such as the province, state, or district.
BillingAddressProvinceCode	String		The alphanumeric code for the region. For example, ON.
BillingAddressZip	String		The zip or postal code of the address.
BillingAddressTimeZone	String		The time zone of the address.
ShippingAddressCoordinatesValidated	Bool		Whether the address corresponds to recognized latitude and longitude values.
ShippingAddressId	String		A globally-unique ID.
ShippingAddressValidationResultSummary	String		The validation status that is leveraged by the address validation feature in the Shopify Admin.
ShippingAddressFirstName	String		The first name of the customer.
ShippingAddressLastName	String		The last name of the customer.
ShippingAddressName	String		The full name of the customer, based on firstName and lastName.
ShippingAddressAddress1	String		The first line of the address. Typically the street address or PO Box number.
ShippingAddressAddress2	String		The second line of the address. Typically the number of the apartment, suite, or unit.
ShippingAddressCity	String		The name of the city, district, village, or town.
ShippingAddressCompany	String		The name of the customer's company or organization.
ShippingAddressCountry	String		The name of the country.
ShippingAddressCountryCode	String		The two-letter code for the country of the address. For example, US.
ShippingAddressFormattedArea	String		A comma-separated list of the values for city, province, and country.
ShippingAddressLatitude	Double		The latitude coordinate of the customer address.
ShippingAddressLongitude	Double		The longitude coordinate of the customer address.
ShippingAddressPhone	String		A unique phone number for the customer.
ShippingAddressProvince	String		The region of the address, such as the province, state, or district.
ShippingAddressProvinceCode	String		The alphanumeric code for the region. For example, ON.
ShippingAddressZip	String		The zip or postal code of the address.
ShippingAddressTimeZone	String		The time zone of the address.
SubtotalPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
SubtotalPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
SubtotalPriceSetShopMoneyAmount	Decimal		Decimal money amount.
SubtotalPriceSetShopMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalDiscountSetShopMoneyAmount	Decimal		Decimal money amount.
TotalDiscountSetShopMoneyCurrencyCode	String		Currency of the money.
TotalDutiesSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalDutiesSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalDutiesSetShopMoneyAmount	Decimal		Decimal money amount.
TotalDutiesSetShopMoneyCurrencyCode	String		Currency of the money.
TotalLineItemsPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalLineItemsPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalLineItemsPriceSetShopMoneyAmount	Decimal		Decimal money amount.
TotalLineItemsPriceSetShopMoneyCurrencyCode	String		Currency of the money.
TotalPriceSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalPriceSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalPriceSetShopMoneyAmount	Decimal		Decimal money amount.
TotalPriceSetShopMoneyCurrencyCode	String		Currency of the money.
TotalTaxSetPresentmentMoneyAmount	Decimal		Decimal money amount.
TotalTaxSetPresentmentMoneyCurrencyCode	String		Currency of the money.
TotalTaxSetShopMoneyAmount	Decimal		Decimal money amount.
TotalTaxSetShopMoneyCurrencyCode	String		Currency of the money.
Status	String		Filter by the status. The allowed values are open, closed.
EmailState	String		Filter by the email state. The allowed values are sent, not_sent, scheduled, suppressed.
RecoveryState	String		Filter by the recovery state. The allowed values are open, closed.

JDBC Driver for Shopify

AbandonedCheckouts

View-Specific Information

Select

Columns