ODBC Driver for Mailchimp

Build 24.0.9062

EcommerceCarts

A list of an account's ecommerce carts.

Table Specific Information

Select

The 本製品 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 本製品.

The StoreId can be retrieved by selecting the ECommerceStores view.

  • StoreId supports the '=' operator.
  • Id supports the '=' operator.
For example:
SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123'

SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123' and Id = '44'

Columns

Name Type ReadOnly Description
StoreId [KEY] String False

The StoreId for the table.

Id [KEY] String False

A unique identifier for the cart.

Customer String False

Information about a specific customer. Carts for existing customers should include only the id parameter in the customer object body.

CampaignId String False

A string that uniquely identifies the campaign associated with a cart.

CheckoutUrl String False

The URL for the cart.

CurrencyCode String False

The three-letter ISO 4217 code for the currency that the cart uses.

OrderTotal Decimal False

The order total for the cart.

TaxTotal Decimal False

The total tax for the cart.

Lines String False

An array of the cart's line items. The column will not work for Update. Lines can be updated using EcommerceCartLines table.

CreatedAt Datetime True

The date and time when the cart was created.

UpdatedAt Datetime True

The date and time when the cart was last updated.

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