EcommerceCarts
A list of an account's ecommerce carts.
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 [KEY] | String | False |
The StoreId for the table. |
Id [KEY] | String | False |
A unique identifier for the cart. |
Customer | String | False |
Information about a specific customer. Carts for existing customers should include only the id parameter in the customer object body. |
CampaignId | String | False |
A string that uniquely identifies the campaign associated with a cart. |
CheckoutUrl | String | False |
The URL for the cart. |
CurrencyCode | String | False |
The three-letter ISO 4217 code for the currency that the cart uses. |
OrderTotal | Decimal | False |
The order total for the cart. |
TaxTotal | Decimal | False |
The total tax for the cart. |
Lines | String | False |
An array of the cart's line items. The column will not work for Update. Lines can be updated using EcommerceCartLines table. |
CreatedAt | Datetime | True |
The date and time when the cart was created. |
UpdatedAt | Datetime | True |
The date and time when the cart was last updated. |