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.
Attribute | Description |
---|---|
email |
The customer’s email address. |
_website |
|
_store |
|
confirmation |
Confirmation flag. |
created_at |
The date the customer account was created. |
created_in |
The store view where the account was created. |
disable_auto_group_change |
Determines if customer groups can be dynamically assigned during VAT ID validation. |
dob |
The 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. |
firstname |
The first name of the customer. |
gender |
The customer gender. |
group_id |
The ID of the customer group where the customer is assigned. |
lastname |
The last name of the customer. |
middlename |
The middle name or middle initial of the customer. |
password_hash |
Password hash |
prefix |
Any prefix that is used with the customer name (such as Mr. , Ms. , Mrs. , and Dr. ). |
rp_token |
Reset password token. |
rp_token_created_at |
Date when the password was reset. |
store_id |
Store ID |
suffix |
Any suffix that is used with the customer name (such as Jr. , Sr. , and Esquire ). |
taxvat |
|
website_id |
The website ID of the site where the customer account was created. |
password |
The customer password. |
Attribute | Description |
---|---|
_website |
|
_email |
|
_entity_id |
|
city |
The city where the customer address is located. |
company |
The company name, if applicable for this address. |
country_id |
The country id where the customer address is located. |
fax |
The fax number of the customer, if applicable. |
firstname |
The customer’s first name. |
lastname |
The customer’s last name. |
middlename |
The middle name or middle initial of the customer. |
postcode |
The ZIP or postal code where the customer address is located. |
prefix |
Any prefix that is used with the customer name (such as Mr. , Ms. , Mrs. , and Dr. ). |
region |
The region where the customer address is located. |
region_id |
Region ID |
street |
The street address of the customer. A second line of the street address is available if specified in the configuration. |
suffix |
If used, the suffix that is associated with the customer’s name (such as Jr. , Sr. , or III ). |
telephone |
The customer’s telephone number that is associated with address. |
vat_id |
VAT ID is an internal identifier for the VAT Number of the customer when used in VAT Validation. |
vat_is_valid |
|
vat_request_date |
|
vat_request_id |
|
vat_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 / 0 |