EcommerceCartLines
Lists individual items included in an e-commerce cart, including product details and quantities.
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.
- CartId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' and CartId = '44' SELECT * FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' and CartId = '44' and Id = '88'
Delete
Note : API will throw error if the cart contains only one line item. You will have to delete the cart to delete all the lines.
DELETE FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' and CartId = '44' and Id = '88'
Columns
| Name | Type | ReadOnly | Description |
| StoreId [KEY] | String | False |
The unique identifier of the store where the cart line item is recorded. Each store represents an e-commerce integration connected to Mailchimp. |
| CartId [KEY] | String | False |
The unique identifier of the shopping cart that contains this line item. Each cart groups one or more products selected by a customer. |
| Id [KEY] | String | False |
The unique identifier of the specific line item within the cart, used to differentiate it from other items in the same cart. |
| ProductId | String | False |
The unique identifier of the product added to the cart. This links the line item to the product record in the associated store. |
| ProductTitle | String | True |
The display name or title of the product associated with the cart line item. |
| ProductVariantId | String | False |
The unique identifier of the specific product variant included in the cart, such as a size or color variation. |
| ProductVariantTitle | String | True |
The name or description of the product variant, helping identify the specific version of the product being purchased. |
| Quantity | Integer | False |
The number of units of this product variant included in the cart line item. |
| Price | Decimal | False |
The unit price of the product variant in the cart, before applying any discounts or taxes. |