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.

Last updated