Customer data attributes reference

Last update: 2023-07-13
  • Created for:
  • Beginner
    Intermediate
    Admin
    Leader

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
Previous page
Next page

On this page