EcommerceCustomers
A list of an account's ecommerce customers.
Columns
Name
Type
ReadOnly
Description
StoreId [KEY]
String
True
The StoreId for the table.
Id [KEY]
String
True
A unique identifier for the customer.
EmailAddress
String
True
The customer's email address.
OptInStatus
Boolean
False
The customer's opt-in status. This value will never overwrite the opt-in status of a pre-existing MailChimp list member, but will apply to list members that are added through the e-commerce API endpoints.
Company
String
False
The customer's company.
FirstName
String
False
The customer's first name.
LastName
String
False
The customer's last name.
OrdersCount
Integer
False
The customer's total order count.
TotalSpent
Decimal
False
The total amount the customer has spent.
Address_Address1
String
False
The mailing address of the customer.
Address_Address2
String
False
An additional field for the customer's mailing address.
Address_City
String
False
The city the customer is located in.
Address_Province
String
False
The customer's state name or normalized province.
Address_ProvinceCode
String
False
The two-letter code for the customer's province or state.
Address_PostalCode
String
False
The customer's postal or zip code.
Address_Country
String
False
The customer's country.
Address_CountryCode
String
False
The two-letter code for the customer's country.
CreatedAt
Datetime
True
The date and time the customer was created.
UpdatedAt
Datetime
True
The date and time the customer was last updated.
Last updated