EcommerceStores

A list of an account's ecommerce stores.

Table Specific Information

For example:

SELECT * FROM EcommerceStores WHERE  Id = '44'


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.