ADO.NET Provider for Mailchimp

Build 26.0.9655

EcommerceOrders

Contains details of e-commerce orders tracked through connected stores, including order totals and customer details.

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.

ColumnSupported Operators
StoreId=
Id=
CampaignId=
Outreach_Id=
CustomerId=
HasOutreach=

For example, the following queries are processed server-side: 

SELECT * FROM EcommerceOrders WHERE StoreId = 'Test_Store123'
SELECT * FROM EcommerceOrders WHERE StoreId = 'Test_Store123' AND Id = '44'
SELECT * FROM EcommerceOrders WHERE CampaignId = '12144'
SELECT * FROM EcommerceOrders WHERE Outreach_Id = '12144'
SELECT * FROM EcommerceOrders WHERE CustomerId = '12144'
SELECT * FROM EcommerceOrders WHERE HasOutreach = 'true'
Note: To retrieve the StoreId, query the EcommerceStores view.

Columns

Name Type ReadOnly References Description
StoreId [KEY] String False

The unique identifier of the store where the order was placed. Each store represents an e-commerce integration connected to the Mailchimp account.

Id [KEY] String False

The unique identifier assigned to the order within the store. This value distinguishes the order from other transactions.

Customer String False

Details about the customer who placed the order. For existing customers, include only the customer ID to associate the order with their record.

CampaignId String False

Campaigns.Id

The unique identifier of the Mailchimp campaign associated with the order, enabling marketing attribution and performance tracking.

FinancialStatus String False

The financial state of the order, such as refunded, processing, or cancelled, indicating its payment status.

FulfillmentStatus String False

The fulfillment progress of the order, such as partial or fulfilled, showing whether items have been shipped or completed.

CurrencyCode String False

The three-letter International Organization for Standardization (ISO) 4217 currency code that defines the currency used in the order.

OrderTotal Decimal False

The total monetary amount of the order, including products, taxes, and shipping costs, after discounts are applied.

TaxTotal Decimal False

The total tax amount applied to the order based on the products purchased and the buyer's location.

ShippingTotal Decimal False

The total shipping charge applied to the order.

TrackingCode String False

The Mailchimp tracking code applied to the order. It uses the 'mc_tc' parameter from eCommerce360-enabled tracking URLs to measure marketing impact.

The allowed values are prec.

ProcessedAtForeign Datetime False

The date and time when the order was processed in the connected store system.

CancelledAtForeign Datetime False

The date and time when the order was canceled, if applicable.

UpdatedAtForeign Datetime False

The date and time when the order record was last updated in the store.

ShippingAddress_Name String False

The full name of the recipient for the order's shipping address.

ShippingAddress_Address1 String False

The first line of the shipping address, typically the street address or P.O. box.

ShippingAddress_Address2 String False

An additional field for apartment, suite, or building details in the shipping address.

ShippingAddress_City String False

The city where the order is being shipped.

ShippingAddress_Province String False

The state or province listed in the shipping address.

ShippingAddress_ProvinceCode String False

The two-letter code representing the state or province in the shipping address.

ShippingAddress_PostalCode String False

The postal or ZIP code for the shipping address.

ShippingAddress_Country String False

The full name of the country where the order is shipped.

ShippingAddress_CountryCode String False

The two-letter ISO 3166-1 code for the shipping country.

ShippingAddress_Longitude Double False

The longitude coordinate associated with the shipping address location.

ShippingAddress_Latitude Double False

The latitude coordinate associated with the shipping address location.

ShippingAddress_Phone String False

The phone number associated with the shipping address, if provided.

ShippingAddress_Company String False

The company name associated with the shipping address, if applicable.

BillingAddress_Name String False

The full name of the person or company on the billing address.

BillingAddress_Address1 String False

The first line of the billing address, typically the street address or P.O. box.

BillingAddress_Address2 String False

An additional field for apartment, suite, or building details in the billing address.

BillingAddress_City String False

The city where the billing address is located.

BillingAddress_Province String False

The state or province listed in the billing address.

BillingAddress_ProvinceCode String False

The two-letter code representing the state or province in the billing address.

BillingAddress_PostalCode String False

The postal or ZIP code for the billing address.

BillingAddress_Country String False

The full name of the country for the billing address.

BillingAddress_CountryCode String False

The two-letter ISO 3166-1 code for the billing country.

BillingAddress_Longitude Double False

The longitude coordinate for the billing address location.

BillingAddress_Latitude Double False

The latitude coordinate for the billing address location.

BillingAddress_Phone String False

The phone number associated with the billing address.

BillingAddress_Company String False

The company name associated with the billing address, if applicable.

Lines String False

A list of the order's line items, each representing a product or variant purchased. Line items can be updated through the EcommerceOrderLines table.

Outreach_Id String False

The unique identifier of the marketing outreach associated with the order, such as an email campaign or ad.

Outreach_Name String True

The name of the outreach campaign linked to the order.

Outreach_Type String True

The type of marketing outreach, such as email, social, or advertisement.

Outreach_PublishedTime String True

The date and time when the outreach campaign was published, in ISO 8601 format.

TrackingNumber String False

The tracking number provided by the shipping carrier for the order.

TrackingCarrier String False

The name of the shipping carrier handling the order, such as UPS, FedEx, or DHL.

TrackingUrl String False

The URL provided by the carrier to track the shipment's delivery status.

LandingSite String False

The URL of the page where the buyer first arrived before completing the order, useful for analyzing marketing funnels.

Promos String False

A list of promotional or discount codes applied to the order. When updating, this field is fully replaced with new values.

OrderUrl String False

The URL of the order record within the e-commerce system, used for quick reference or access.

DiscountTotal Decimal False

The total value of discounts applied to the order across all items.

CustomerId String True

A unique identifier for the customer associated with the order.

Customer_EmailAddress String True

The primary email address of the customer associated with the order, used for communications and marketing.

Customer_SmsPhoneNumber String True

The SMS-capable phone number of the customer associated with the order.

Customer_OptInStatus Boolean True

If the value is 'true', the customer has opted in to receive marketing emails from the store.

Customer_Company String True

The company name associated with the customer who placed the order, if applicable.

Customer_FirstName String True

The first name of the customer who placed the order, used for personalization and segmentation.

Customer_LastName String True

The last name of the customer who placed the order, used for personalization and segmentation.

Customer_OrdersCount Integer True

The total number of completed orders associated with the customer across all recorded transactions.

Customer_TotalSpent Decimal True

The cumulative monetary amount the customer has spent on completed orders across the store.

Customer_Address_Address1 String True

The first line of the customer's address, typically the street address or P.O. box.

Customer_Address_Address2 String True

An additional address line for apartment numbers, suites, or secondary address details.

Customer_Address_City String True

The city where the customer resides.

Customer_Address_Province String True

The full name of the customer's state or province.

Customer_Address_ProvinceCode String True

The two-letter code representing the customer's state or province, following regional postal standards.

Customer_Address_PostalCode String True

The customer's postal or ZIP code for billing or shipping.

Customer_Address_Country String True

The full name of the customer's country.

Customer_Address_CountryCode String True

The two-letter ISO 3166-1 code for the customer's country.

Customer_CreatedAt Datetime True

The date and time when the customer record was first created in the store.

Customer_UpdatedAt Datetime True

The date and time when the customer's information was last updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
HasOutreach Boolean

If the value is 'true', restricts results to orders associated with an outreach campaign, such as an email or ad. This column is only valid for SELECT operations.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655