AbandonedCheckouts

Columns

Name	Type	Description
Id	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	Boolean	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	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	Boolean	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	Boolean	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	Boolean	Whether this address is the default one or not.
ClosedAt	Datetime	The date and time when the order was closed.
CompletedAt	Datetime
CreatedAt	Datetime	The date and time when the order was created.
UpdatedAt	Datetime	The date and time when the order was last modified.