EcommerceOrderLines
A list of an ecommerce order's lines.
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 StoreId for the table. |
| OrderId [KEY] | String | False |
The OrderId for the table. |
| Id [KEY] | String | False |
A unique identifier for the order line item. |
| ProductId | String | False |
A unique identifier for the product associated with the order line item. |
| ProductTitle | String | True |
The name of the product for the order line item. |
| ProductVariantId | String | False |
A unique identifier for the product variant associated with the order line item. |
| ProductVariantTitle | String | True |
The name of the product variant for the order line item. |
| Quantity | Integer | False |
The quantity of an order line item. |
| Price | Decimal | False |
The price of an ecommerce order line item. |