AbandonedCheckouts
Query abandoned checkouts.
View-Specific Information
Select
The connector uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The connector processes other filters client-side within the connector. 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. | |
| 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. |