Once again we use a CSV file to import existing customers into our new Magento shop.

Firstly create a test customer and add an address for them.

Export the file. This we will use as our template.

ZenCart doesn’t have a CSV file for customer details but it does have similar fields in the database and this can be accessed through your server. I go through cPanel and select phyMyAdmin.

The two fields you need are address_book and customers. Select your database then, at the top of the screen select export.  Select address_book, check the CSV  option (or CSV for excel) and save the file. Repeat for customers.

You now have two separate files with all the necessary information to be able to compile a Magento customer file ready for importing.

It is then a case of copy and pasting from the zencart customers into your Magento CSV template. To do this faster combined the two files into one.

Open your address files then select the first blank cell at the end of the data – mine was M1.  Then select data, from other text, your customers file and insert as comma separated into your worksheet starting at the first blank cell (M1 in my case).

Now read across and the customers details should more or less match. Basically name, address, email and password login.

For those lines that do not match I delete the first few cells on a row (A-L) and shift them up. Usually that realigns them. Doing it this way every line will need to be checked carefully for the correct customers details but it will save time copying and pasting later on as we can now do entire columns in one go.

Once finished delete the CSV files as this is information that, while secure on a host, is not secure on a personal computer.