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.
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.
Last updated