EcommerceCartLines
Lists individual items included in an e-commerce cart, including product details and quantities.
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 | = |
| CartId | = |
| Id | = |
SELECT * FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' AND CartId = '44'
SELECT * FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' AND CartId = '44' AND Id = '88'
Note: To retrieve the StoreId, query the EcommerceStores view.
Delete
The following is an example of a DELETE operation:DELETE FROM EcommerceCartLines WHERE StoreId = 'Test_Store123' AND CartId = '44' AND Id = '88'
Note: The API throws an error if the cart contains only one line item. Therefore, you must delete the cart to delete all line items.
Columns
| Name | Type | ReadOnly | References | 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 | Long | 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. |