Customer Attribute Reference | Adobe Commerce 2.3 User Guide (Archived)

Customer Attribute Reference

This site contains archived merchant documentation for a version of Adobe Commerce and Magento Open Source that has reached end-of-support. The documentation available here is intended for historical reference only and is not maintained. The Adobe Commerce Merchant Documentation for current releases is published on the Adobe Experience League.

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, be sure you are aware of any potential legal and security risks associated with the storage of customers’ full date of birth (month, day, year) along with other personal identifiers (e.g., full name) before collecting or processing such data. 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., Dr., etc.).
`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., Esquire, etc.).
`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., Dr., etc.).
`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