Magento 1: Importing customers to Magento using Import/Export Profiles (Magento 1.3*) Print

  • 79

This knowledgebase explains how to setup a simple .csv file in order to import your existing customers into Magento using Magento Import / Export Profiles.

The Magento 1.3* Customer Import Profiles functionality is a little buggy. The following simple fields will enable you to import an email address, firstname and surname. First you need to create a .csv file with the following column titles in the first row:

email    firstname    lastname    password_hash     website    group_id

Ensure that you enter a password hash in the password_hash column (it can be random characters). If you leave the password_hash blank, Magento will generate and send two emails to the customer with their new password details.

1. Login to Magento Admin
2. Go to System > Import Export > Profiles.
3. Select Import Customers
4. In the Profile Wizard, ensure that you are importing to the correct store and that you have selected CSV / Tab separated as the data type.
5. Select Upload File from the LHS menu, use the Browse button to browse to you .csv file that you created.
6. Click Save and Continue Editing to upload the file
7. Select Run Profile from the LHS menu, select the file that you uploaded (using the drop down) and click the Run Profile in Popup button

If you get an error Skip import row, is not valid value for field group_id, be sure that you are using the text name for the group_id (e.g. General). Also ensure that you have entered a website value (e.g. base).

Note:

You will either need to direct the user to click the forgot password link when logging into your site or you could create a macro (using iMacros for Firefox - http://www.iopus.com/imacros/firefox/?ref=fxtab) to go through your list of email addresses and click the forgot password link for you. An example iMacro script that would accomplish this is:

TAB T=1
TAB CLOSEALLOTHERS
URL GOTO=https://www.example.co.nz/customer/account/forgotpassword/


TAG POS=1 TYPE=INPUT:TEXT FORM=ACTION:https://www.example.co.nz/customer/account/forgotpasswordpost/ ATTR=ID:email_address CONTENT=customer1@gmail.com
TAG POS=1 TYPE=BUTTON ATTR=TXT:Submit
TAG POS=1 TYPE=A ATTR=TXT:ForgotYourPassword?
TAG POS=1 TYPE=INPUT:TEXT FORM=ACTION:https://www.example.co.nz/customer/account/forgotpasswordpost/ ATTR=ID:email_address CONTENT=customer2@yahoo.com
TAG POS=1 TYPE=BUTTON ATTR=TXT:Submit
TAG POS=1 TYPE=A ATTR=TXT:ForgotYourPassword?


Was this answer helpful?

« Back