EcommerceCarts
Contains data on e-commerce carts associated with the account, including customer and total value information.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
The StoreId can be retrieved by selecting the ECommerceStores view.
- StoreId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123' SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123' and Id = '44'
Columns
| Name | Type | ReadOnly | Description |
| StoreId | String | False |
The unique identifier of the store associated with this cart. Each store represents an e-commerce integration connected to the Mailchimp account. |
| Id | String | False |
The unique identifier assigned to the specific cart. This value distinguishes the cart record within the store. |
| Customer | String | False |
Details about the customer who created the cart. For existing customers, include only the customer ID to link the cart to their profile. |
| CampaignId | String | False |
The unique identifier of the Mailchimp campaign associated with the cart, allowing tracking of marketing influence on purchases. |
| CheckoutUrl | String | False |
The direct URL where the customer can view and complete their checkout process for this cart. |
| CurrencyCode | String | False |
The three-letter International Organization for Standardization (ISO) 4217 currency code that defines the currency used in the cart. |
| OrderTotal | Decimal | False |
The total monetary value of all items in the cart, including taxes and discounts. |
| TaxTotal | Decimal | False |
The total tax amount applied to the cart based on the products and applicable tax rules. |
| Lines | String | False |
A list of individual line items contained within the cart. Line item details can be modified through the EcommerceCartLines table. |
| CreatedAt | Datetime | True |
The date and time when the cart was initially created in the store system. |
| UpdatedAt | Datetime | True |
The date and time when the cart was most recently updated or modified. |