EcommerceOrderLines
Lists line items included in e-commerce orders, such as product identifiers, quantities, and prices.
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.
- OrderId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM EcommerceOrderLines WHERE StoreId = 'Test_Store123' and OrderId = '44' SELECT * FROM EcommerceOrderLines WHERE StoreId = 'Test_Store123' and OrderId = '44' and Id = '88'
Delete
Note : API will throw error if the Order contains only one line item. You will have to delete the order to delete all the lines.
DELETE FROM EcommerceOrderLines WHERE StoreId = 'Test_Store123' and OrderId = '44' and Id = '88'
Columns
| Name | Type | ReadOnly | Description |
| StoreId [KEY] | String | False |
The unique identifier of the store where the order line item is recorded. Each store represents an e-commerce integration connected to the Mailchimp account. |
| OrderId [KEY] | String | False |
The unique identifier of the order that contains this specific line item. Each order can include one or more products purchased together. |
| Id [KEY] | String | False |
The unique identifier of the line item within the order, used to distinguish it from other items in the same transaction. |
| ProductId | String | False |
The unique identifier of the product associated with the line item. This links the order record to the product catalog. |
| ProductTitle | String | True |
The display name or title of the product purchased in the order. |
| ProductVariantId | String | False |
The unique identifier of the specific variant of the product included in the order, such as a particular size, color, or model. |
| ProductVariantTitle | String | True |
The name or description of the selected product variant purchased in this order line. |
| Quantity | Integer | False |
The number of units of the product variant included in the order line item. |
| Price | Decimal | False |
The unit price of the product variant at the time of purchase, before applying discounts or taxes. |
| Discount | Decimal | False |
The total discount amount applied to this line item, including promotional codes or price adjustments. |
| ImageUrl | String | True |
The URL of the product image associated with the order line item, typically used for display in receipts or analytics dashboards. |