EcommerceStores
Returns a list of an account's ecommerce stores.
View-Specific Information
Select
The provider uses 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.
| Column | Supported Operators |
| Id | = |
SELECT * FROM EcommerceStores WHERE Id = '44'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the store. | |
| ListId [KEY] | String |
Lists.Id | The unique identifier for the Mailchimp list associated with the store. The list Id for a specific store cannot 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, such as `$`. | |
| PrimaryLocale | String | The primary locale for the store, such as `en` or `de`. | |
| 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 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 | Indicates whether the store is currently syncing, which disables automations. | |
| 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 | Indicates whether this store supports the Abandoned Cart automation. | |
| Automations_AbandondedCart_Id | String | The unique Id of the automation parent campaign. | |
| Automations_AbandondedCart_Status | String | The status of the Abandoned Cart automation.
The allowed values are save, sending, paused. | |
| Automations_AbandondedBrowse_IsSupported | Boolean | Indicates whether this store supports the Abandoned Browse automation. | |
| Automations_AbandondedBrowse_Id | String | The unique Id of the automation parent campaign. | |
| Automations_AbandondedBrowse_Status | String | The status of the Abandoned Browse automation.
The allowed values are save, sending, paused. | |
| ListIsActive | Boolean | Indicates whether the list connected to the store is active. A value of false indicates the list is deleted or disabled. |