Zen Cart Logo
Forums / General Questions / Import customers from xls file

Import customers from xls file

Locked

Views: 2,454

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
26 Jul 2007, 11:14 PM
#1
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Import customers from xls file

How would I go about importing all of my customers user names, passwords, email address... everything, into zencart from an excel file that I got from my old site?

27 Jul 2007, 12:16 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Import customers from xls file

You'll need to check out the database structure, and import the data using phpMyAdmin ... into the right tables and fields.
There's a wiki reference posted in this thread:
http://www.zen-cart.com/forum/showthread.php?t=50059

Then you'll need to convert all the passwords to the encrypted Zen Cart format. There's a tool posted here to do that:
http://www.zen-cart.com/forum/showthread.php?t=50059#post284225

Additionally, here is some info on building SQL scripts from excel data, in case you prefer that approach instead of importing via phpMyAdmin's import menus:
http://www.zen-cart.com/forum/showthread.php?t=14096

30 Jul 2007, 9:27 PM
#3
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Import customers from xls file

Awesome! Thank you!

This should make things a LOT easier.