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