Customer data attributes reference
The following tables list the attributes from a typical export of the customers main file and customer addresses. The installation that was used to export this data has two websites and several store views, with the sample data installed.
Each attribute, or field, is represented in the CSV file as a column, and customer records are represented by rows. Columns that begin with an underscore are service entities that contain properties or complex data.
Customers main file
Attribute
Description
emailThe customer’s email address.
_website_storeconfirmationConfirmation flag.
created_atThe date the customer account was created.
created_inThe store view where the account was created.
disable_auto_group_changeDetermines if customer groups can be dynamically assigned during VAT ID validation.
dobThe customer’s date of birth.
Important: In keeping with current security and privacy best practices, review the storage and processing of customers’ full date of birth (month, day, year). When collected with other personal identifiers (such as full name), it is a potential legal and security risk. We recommend limiting the storage of customers’ full birth dates and instead suggest using customer year of birth as an alternative.
Important: In keeping with current security and privacy best practices, review the storage and processing of customers’ full date of birth (month, day, year). When collected with other personal identifiers (such as full name), it is a potential legal and security risk. We recommend limiting the storage of customers’ full birth dates and instead suggest using customer year of birth as an alternative.
firstnameThe first name of the customer.
genderThe customer gender.
group_idThe ID of the customer group where the customer is assigned.
lastnameThe last name of the customer.
middlenameThe middle name or middle initial of the customer.
password_hashPassword hash
prefixAny prefix that is used with the customer name (such as
Mr., Ms., Mrs., and Dr.).rp_tokenReset password token.
rp_token_created_atDate when the password was reset.
store_idStore ID
suffixAny suffix that is used with the customer name (such as
Jr., Sr., and Esquire).taxvatwebsite_idThe website ID of the site where the customer account was created.
passwordThe customer password.
Customer addresses
Attribute
Description
_website_email_entity_idcityThe city where the customer address is located.
companyThe company name, if applicable for this address.
country_idThe country id where the customer address is located.
faxThe fax number of the customer, if applicable.
firstnameThe customer’s first name.
lastnameThe customer’s last name.
middlenameThe middle name or middle initial of the customer.
postcodeThe ZIP or postal code where the customer address is located.
prefixAny prefix that is used with the customer name (such as
Mr., Ms., Mrs., and Dr.).regionThe region where the customer address is located.
region_idRegion ID
streetThe street address of the customer. A second line of the street address is available if specified in the configuration.
suffixIf used, the suffix that is associated with the customer’s name (such as
Jr., Sr., or III).telephoneThe customer’s telephone number that is associated with address.
vat_idVAT ID is an internal identifier for the VAT Number of the customer when used in VAT Validation.
vat_is_validvat_request_datevat_request_idvat_request_success_address_default_billing_Identifies the default billing address. A value of
1 indicates that the address is the default billing address of the customer. Values: 1 / 0_address_default_shipping_Identifies the default shipping address. A value of
1 indicates that the address is the default shipping address of the customer. Values: 1 / 0recommendation-more-help
d3c62084-5181-43fb-bba6-1feb2fcc3ec1