Magento Open Source 2.2.x

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 attributeA characteristic or property of a product; anything that describes a product. Examples of product attributes include color, size, weight, and price., or field, is represented in the CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas. 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 dataData that is associated with multiple product options..

  • 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