AbandonedCheckouts
Retrieves information on customer checkouts that were started but not completed, useful for tracking cart abandonment and follow-up marketing.
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | A unique numeric identifier for the abandoned checkout. | |
| AbandonedCheckoutUrl | String | A full recovery link that can be sent to the customer to resume and complete their abandoned checkout. | |
| BuyerAcceptsMarketing | Bool | Indicates whether the customer who initiated the checkout agreed to receive marketing communications from the store. | |
| CancelReason | String | Specifies the reason the checkout or order was cancelled, if applicable. | |
| CustomerId | Long |
Customers.Id | A unique numeric identifier for the customer who initiated the checkout. |
| DiscountCodes | String | Any discount codes that were applied or could be applied to the checkout. | |
| String | The email address of the customer who started the checkout. | ||
| Note | String | An optional note left by the customer or added by the shop owner regarding the checkout. | |
| SubtotalPrice | Decimal | The total price of all items in the checkout before shipping and taxes. | |
| TotalDiscounts | Decimal | The combined total value of all discounts applied to the checkout. | |
| TotalLineItemsPrice | Decimal | The sum of prices for all line items before taxes, discounts, or shipping charges. | |
| TotalPrice | Decimal | The final total of the checkout, including items, taxes, shipping, and applied discounts. | |
| TotalTax | Decimal | The total amount of tax applied to the checkout. | |
| TaxesIncluded | Bool | Indicates whether taxes are included in the subtotal price. | |
| BillingAddressFirstName | String | The first name of the customer associated with the billing address. | |
| BillingAddressLastName | String | The last name of the customer associated with the billing address. | |
| BillingAddressAdress1 | String | The primary street address line for the billing address. | |
| BillingAddressAdress2 | String | An optional second line for the billing address, such as an apartment or suite number. | |
| BillingAddressPhone | String | The phone number associated with the billing address. | |
| BillingAddressCity | String | The city for the billing address. | |
| BillingAddressCompany | String | The company name listed on the billing address, if provided. | |
| BillingAddressZip | String | The postal or ZIP code for the billing address. | |
| BillingAddressProvince | String | The state or province for the billing address. | |
| BillingAddressCountry | String | The country name for the billing address. | |
| BillingAddressLatitude | Double | The latitude coordinate for the billing address. | |
| BillingAddressLongitude | Double | The longitude coordinate for the billing address. | |
| BillingAddressName | String | The full name of the person listed on the billing address. | |
| BillingAddressCountryCode | String | The two-letter ISO country code for the billing address. | |
| BillingAddressProvinceCode | String | The two-letter state or province abbreviation for the billing address. | |
| BillingAddressDefault | Bool | Indicates whether this is the customer's default billing address. | |
| ShippingAddressFirstName | String | The first name of the customer associated with the shipping address. | |
| ShippingAddressLastName | String | The last name of the customer associated with the shipping address. | |
| ShippingAddressAdress1 | String | The primary street address line for the shipping address. | |
| ShippingAddressAdress2 | String | An optional second line for the shipping address, such as an apartment or suite number. | |
| ShippingAddressPhone | String | The phone number associated with the shipping address. | |
| ShippingAddressCity | String | The city for the shipping address. | |
| ShippingAddressCompany | String | The company name listed on the shipping address, if provided. | |
| ShippingAddressZip | String | The postal or ZIP code for the shipping address. | |
| ShippingAddressProvince | String | The state or province for the shipping address. | |
| ShippingAddressCountry | String | The country name for the shipping address. | |
| ShippingAddressLatitude | Double | The latitude coordinate for the shipping address. | |
| ShippingAddressLongitude | Double | The longitude coordinate for the shipping address. | |
| ShippingAddressName | String | The full name of the person listed on the shipping address. | |
| ShippingAddressCountryCode | String | The two-letter ISO country code for the shipping address. | |
| ShippingAddressProvinceCode | String | The two-letter state or province abbreviation for the shipping address. | |
| ShippingAddressDefault | Bool | Indicates whether this is the customer's default shipping address. | |
| CompletedAt | Datetime | The date and time when the checkout was successfully completed and converted into an order. | |
| CreatedAt | Datetime | The date and time when the checkout was first created. | |
| UpdatedAt | Datetime | The date and time when the checkout was last updated. |