EcommerceCarts
Contains data on e-commerce carts associated with the account, including customer and total value information.
Table Specific Information
Select
The connector 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 connector.
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. |