EcommerceOrders
A list of an account's ecommerce orders.
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.
- 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. |