Import Customers with csv file

Last modified by NETZKOLLEKTIV on Fri, July 2, 2010 03:10
Source|Old Revisions  

This is an old revision of the document!

The import customers mapping tool is buggy and I don’t recommend using it. There are fields that you will want to use that aren’t set up properly and some not present at all. It is also misleading in that it has things labeled as ‘db field’ when you are not actually mapping to db fields. Instead, you are mapping your file columns to hardcode “keys” from expected “key/value” pairs in the import code. For example, there is a mapping to “group”, but the code is looking for you to have a row with the label “group_id”. I was instead able to modify the column titles in my csv to match what the code was expecting and I got the import working using the following column titles:

  • website
  • group_id
  • firstname
  • middlename
  • lastname
  • billing_company
  • billing_city
  • billing_firstname
  • billing_lastname
  • billing_postcode
  • billing_region
  • billing_street1
  • billing_telephone
  • billing_country
  • email
  • is_subscribed
  • dob

Note, there is a “shipping” analog to each of the “billing” items (for example, shipping_postcode, shipping_street1).

Also, for the street address fields, the system labels them as “shipping_street1”, “shipping_street2”... “shipping_street8”.

Importing more than 2,000 customers always fails. If you have a large customer database to import you might want to to partition your customer lists into blocks of 1,000 per batch.