EcommerceOrderLines
A list of an ecommerce order's lines.
Table Specific Information
Select
The add-in 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 add-in.
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. |