EcommerceOrders
A list of an account's ecommerce orders.
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.
- Id supports the '=' operator.
SELECT * FROM EcommerceOrders WHERE StoreId = 'Test_Store123' SELECT * FROM EcommerceOrders 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 order. |
| Customer | String | False |
Information about a specific customer. Orders 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 an order. |
| FinancialStatus | String | False |
The order status. For example: `refunded`, `processing`, `cancelled`, etc. |
| FulfillmentStatus | String | False |
The fulfillment status for the order. For example: `partial`, `fulfilled`, etc. |
| CurrencyCode | String | False |
The three-letter ISO 4217 code for the currency that the store accepts. |
| OrderTotal | Decimal | False |
The order total for the order. |
| TaxTotal | Decimal | False |
The tax total for the order. |
| ShippingTotal | Decimal | False |
The shipping total for the order. |
| TrackingCode | String | False |
The MailChimp tracking code for the order. Uses the 'mc_tc' parameter in eCommerce360-enabled tracking urls. |
| ProcessedAtForeign | Datetime | False |
The date and time the order was processed. |
| CancelledAtForeign | Datetime | False |
The date and time the order was cancelled. |
| UpdatedAtForeign | Datetime | False |
The date and time the order was updated. |
| ShippingAddress_Name | String | False |
The name associated with an order's shipping address. |
| ShippingAddress_Address1 | String | False |
The shipping address for the order. |
| ShippingAddress_Address2 | String | False |
An additional field for the shipping address. |
| ShippingAddress_City | String | False |
The city in the order's shipping address. |
| ShippingAddress_Province | String | False |
The state or normalized province in the order's shipping address. |
| ShippingAddress_ProvinceCode | String | False |
The two-letter code for the province or state the order's shipping address is located in. |
| ShippingAddress_PostalCode | String | False |
The postal or zip code in the order's shipping address. |
| ShippingAddress_Country | String | False |
The country in the order's shipping address. |
| ShippingAddress_CountryCode | String | False |
The two-letter code for the country in the shipping address. |
| ShippingAddress_Longitude | Double | False |
The longitude for the shipping address location. |
| ShippingAddress_Latitude | Double | False |
The latitude for the shipping address location. |
| ShippingAddress_Phone | String | False |
The phone number for the order's shipping address |
| ShippingAddress_Company | String | False |
The company associated with an order's shipping address. |
| BillingAddress_Name | String | False |
The name associated with an order's billing address. |
| BillingAddress_Address1 | String | False |
The billing address for the order. |
| BillingAddress_Address2 | String | False |
An additional field for the billing address. |
| BillingAddress_City | String | False |
The city in the billing address. |
| BillingAddress_Province | String | False |
The state or normalized province in the billing address. |
| BillingAddress_ProvinceCode | String | False |
The two-letter code for the province or state in the billing address. |
| BillingAddress_PostalCode | String | False |
The postal or zip code in the billing address. |
| BillingAddress_Country | String | False |
The country in the billing address. |
| BillingAddress_CountryCode | String | False |
The two-letter code for the country in the billing address. |
| BillingAddress_Longitude | Double | False |
The longitude for the billing address location. |
| BillingAddress_Latitude | Double | False |
The latitude for the billing address location. |
| BillingAddress_Phone | String | False |
The phone number for the billing address. |
| BillingAddress_Company | String | False |
The company associated with the billing address. |
| Lines | String | False |
An array of the order's line items. The column will not work for Update. Lines can be updated using EcommerceOrderLines table. |