I'm trying to import customers into magento with a csv file, using Magento built in customer importer.
It's working OK (customers name, email and password goes into database), but the customers billing and shipping addresses are not.
Here's my csv header:
'id', '_website', 'firstname', 'lastname', 'email', 'password_hash', 'billing_firstname', 'billing_lastname', 'billing_company', 'billing_postcode', 'billing_city', 'billing_street1', 'billing_telephone', 'billing_country', 'billing_region', 'shipping_firstname', 'shipping_lastname', 'shipping_company', 'shipping_postcode', 'shipping_city', 'shipping_street1', 'shipping_telephone', 'shipping_country', 'shipping_region', 'is_subscribed', 'group_id', 'dob'
I also tried to put these tags into header, but still nothing.
'postcode', 'city', 'street1', 'telephone', 'country', 'region',
If anyone had this problem and know how to do this, please help,
Thanks in advance,
Best Answer
OK, I found a solution to do this:
Go to Magento admin->System->Import/Export->Dataflow profiles. (NOT to Magento admin->System->Import/Export->Import!)
Then, select profile: Import Customers (or create if it not exists).
I set the Store value in Profile information box to 'Default store view'. Then, upload Your csv, and run the profile.
It worked for me and goes every value into magento database correctly - shipping and billing addresses too.
Here is my CSV header:
I don't know if group_id is required or not, but you must have a group column (I set 'General' value for it.)
I found it a little buggy, so don't panic if everything are set correct and You get an error message like: 'required column website not set' - or similar, I refreshed the Import Dataflow page, run the profile again, and it worked - of course You set everything correctly.
Hope it helps,