Query abandoned checkouts.

View-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The adapter processes other filters client-side within the adapter. For example, the following queries are processed server-side.

SELECT * FROM AbandonedCheckouts WHERE CreatedAt > '2017-10-25'

Columns

Name	Type	References	Description
Id [KEY]	Long		The unique numeric identifier for the order.
AbandonedCheckoutUrl	String		The full recovery URL to be sent to a customer to recover their abandoned checkout.
BuyerAcceptsMarketing	Bool		Indicates whether or not the person who placed the order would like to receive email updates from the shop.
CancelReason	String		The reason why the order was cancelled.
CartToken	String		Unique identifier for a particular cart that is attached to a particular order.
Currency	String		The three letter code (ISO 4217) for the currency used for the payment.
CustomerId	Long	Customers.Id	A unique numeric identifier for the customer.
DiscountCodes	String		Applicable discount codes that can be applied to the order.
Email	String		The customer's email address.
Note	String		The text of an optional note that a shop owner can attach to the order.
LandingSite	String		The URL for the page where the buyer landed when entering the shop.
ReferringSite	String		The website that the customer clicked on to come to the shop.
SourceName	String		Where the order originated.
SubtotalPrice	Decimal		Price of the order before shipping and taxes.
TotalDiscounts	Decimal		The total amount of the discounts to be applied to the price of the order.
TotalLineItemsPrice	Decimal		The sum of all the prices of all the items in the order.
TotalPrice	Decimal		The sum of all the prices of all the items in the order, taxes and discounts included.
TotalTax	Decimal		The sum of all the taxes applied to the order.
TotalWeight	Double		The sum of all the weights of the line items in the order, in grams.
TaxesIncluded	Bool		States whether or not taxes are included in the order subtotal.
Token	String		Unique identifier for a particular order.
BillingAddressFirstName	String		The first name of the person associated with the payment method.
BillingAddressLastName	String		The last name of the person associated with the payment method.
BillingAddressAdress1	String		The street address of the billing address.
BillingAddressAdress2	String		An optional additional field for the street address of the billing address.
BillingAddressPhone	String		The phone number at the billing address.
BillingAddressCity	String		The city of the billing address.
BillingAddressCompany	String		The company of the person associated with the billing address.
BillingAddressZip	String		The zip or postal code of the billing address.
BillingAddressProvince	String		The name of the state or province of the billing address.
BillingAddressCountry	String		The name of the country of the billing address.
BillingAddressLatitude	Double		The latitude of the billing address.
BillingAddressLongitude	Double		The longitude of the billing address.
BillingAddressName	String		The full name of the person associated with the payment method.
BillingAddressCountryCode	String		The two-letter code for the country of the billing address.
BillingAddressProvinceCode	String		The two-letter abbreviation of the state or province of the billing address.
BillingAddressDefault	Bool		Whether this address is the default one or not.
ShippingAddressFirstName	String		The first name of the person associated with the shipping address.
ShippingAddressLastName	String		The last name of the person associated with the shipping address.
ShippingAddressAdress1	String		The street address of the shipping address.
ShippingAddressAdress2	String		An optional additional field for the street address of the shipping address.
ShippingAddressPhone	String		The phone number at the shipping address.
ShippingAddressCity	String		The city of the shipping address.
ShippingAddressCompany	String		The company of the person associated with the shipping address.
ShippingAddressZip	String		The zip or postal code of the shipping address.
ShippingAddressProvince	String		The name of the state or province of the shipping address.
ShippingAddressCountry	String		The name of the country of the shipping address.
ShippingAddressLatitude	Double		The latitude of the shipping address.
ShippingAddressLongitude	Double		The longitude of the shipping address.
ShippingAddressName	String		The full name of the person associated with the shipping address.
ShippingAddressCountryCode	String		The two-letter code for the country of the shipping address.
ShippingAddressProvinceCode	String		The two-letter abbreviation of the state or province of the shipping address.
ShippingAddressDefault	Bool		Whether this address is the default one or not.
ClosedAt	Datetime		The date and time when the order was closed.
CompletedAt	Datetime		CompletedAt
CreatedAt	Datetime		The date and time when the order was created.
UpdatedAt	Datetime		The date and time when the order was last modified.