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

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?

  • 79 Пользователи нашли это полезным
Помог ли вам данный ответ?

Связанные статьи

Magento User Guide (Official and Free)

Magento offer a paid ebook User Guide (which costs around USD$20). What a lot of people don't...

Magento 1: Skip import row, required field sku not defined, Skip import row, required field store not defined

This knowledgebase explains how to solve the "Skip import row, required field "sku" not defined"...

Error - There was a problem with reindexing process (Catalog URL Rewrites)

Magento has a tendancy to append a number to URL's (such as -1) in order to keep them unique....

Magento 1: Add the Magento contact form to a CMS page as a static block

Magento has a built-in contact form that does the job, but isn't the easiest to edit. You may for...

Error - There was a problem with reindexing process (Product flat data) indexes

If re-indexing the Product flat data index gives an unknown re-indexing error or "Some problem...