EcommerceOrderLines
Lists line items included in e-commerce orders, such as product identifiers, quantities, and prices.
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 | = |
| OrderId | = |
| Id | = |
SELECT * FROM EcommerceOrderLines WHERE StoreId = 'Test_Store123' AND OrderId = '44'
SELECT * FROM EcommerceOrderLines WHERE StoreId = 'Test_Store123' AND OrderId = '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 EcommerceOrderLines WHERE StoreId = 'Test_Store123' AND OrderId = '44' AND Id = '88'
Note: The API throws an error if the order contains only one line item. Therefore, you must delete the order to delete all line items.
Columns
| Name | Type | ReadOnly | References | 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 | Long | 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. |