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