Customer Attribute 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  
_website  
_store  
confirmation  
created_at  
created_in  
disable_auto_group_change  
dob  
firstname  
gender  
group_id  
lastname  
middlename  
password_hash  
prefix  
rp_token  
rp_token_created_at  
store_id  
suffix  
taxvat  
website_id  
password  

Customer Addresses

Attribute Description
_website  
_email  
_entity_id  
city  
company  
country_id  
fax  
firstname  
lastname  
middlename  
postcode  
prefix  
region  
region_id  
street  
suffix  
telephone  
vat_id  
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