EcommerceStores
A list of an account's ecommerce stores.
Table Specific Information
Select
The provider 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 provider.
- 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. |