EcommerceStores
A list of an account's ecommerce stores.
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.
- Id supports the '=' operator.
SELECT * FROM EcommerceStores WHERE Id = '44'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier for the store. |
| ListId [KEY] | String | The unique identifier for the MailChimp list that's associated with the store. The list_id for a specific store can't change. |
| Name | String | The name of the store. |
| Platform | String | The ecommerce platform of the store. |
| Domain | String | The store domain. |
| EmailAddress | String | The email address for the store. |
| CurrencyCode | String | The three-letter ISO 4217 code for the currency that the store accepts. |
| MoneyFormat | String | The currency format for the store. For example: `$`, etc. |
| PrimaryLocale | String | The primary locale for the store. For example: `en`, `de`, etc. |
| Timezone | String | The timezone for the store. |
| Phone | String | The store phone number. |
| Address_Address1 | String | The store's mailing address. |
| Address_Address2 | String | An additional field for the store's mailing address. |
| Address_City | String | The city the store is located in. |
| Address_Province | String | The store's state name or normalized province. |
| Address_ProvinceCode | String | The two-letter code for the store's province or state. |
| Address_PostalCode | String | The store's postal or zip code. |
| Address_Country | String | The store's country. |
| Address_CountryCode | String | The two-letter code for to the store's country. |
| Address_Longitude | Double | The longitude of the store location. |
| Address_Latitude | Double | The latitude of the store location. |
| CreatedAt | Datetime | The date and time the store was created. |
| UpdatedAt | Datetime | The date and time the store was last updated. |
| IsSyncing | Boolean | Whether to disable automations because the store is currently syncing. |
| ConnectedSite_SiteForeignId | String | The unique identifier for the connected site. |
| ConnectedSite_SiteScript_Url | String | The URL used for any integrations that offer built-in support for connected sites. |
| ConnectedSite_SiteScript_Fragment | String | A pre-built script that you can copy-and-paste into your site to integrate it with Mailchimp. |
| Automations_AbandondedCart_IsSupported | Boolean | Whether this store supports the abandonedCart automation. |
| Automations_AbandondedCart_Id | String | Unique ID of automation parent campaign. |
| Automations_AbandondedCart_Status | String | Status of the abandonedCart automation.
The allowed values are save, sending, paused. |
| Automations_AbandondedBrowse_IsSupported | Boolean | Whether this store supports the abandonedBrowse automation. |
| Automations_AbandondedBrowse_Id | String | Unique ID of automation parent campaign. |
| Automations_AbandondedBrowse_Status | String | Status of the abandonedBrowse automation.
The allowed values are save, sending, paused. |
| ListIsActive | Boolean | The status of the list connected to the store, namely if it's deleted or disabled. |