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
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.

Customer addresses

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
recommendation-more-help
d3c62084-5181-43fb-bba6-1feb2fcc3ec1