EcommerceCarts
Contains data on e-commerce carts associated with the account, including customer and total value information.
Table-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| StoreId | = |
| Id | = |
SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123'
SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123' AND Id = '44'
Note: To retrieve the StoreId, query the EcommerceStores view.
Columns
| Name | Type | ReadOnly | References | 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 |
Campaigns.Id |
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. |