ODBC Driver for Mailchimp

Build 24.0.9060

EcommerceOrderLines

A list of an ecommerce order's lines.

Table Specific Information

Select

The driver 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 driver.

The StoreId can be retrieved by selecting the ECommerceStores view.

  • StoreId supports the '=' operator.
  • OrderId supports the '=' operator.
  • Id supports the '=' operator.
For example:
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060