Add Customer(s) through database?

[Tig]

I have a client that has an excel spreadsheet of over 600 doctors offices (that will be customers) that need to be added. Rather than do them one at a time I'd like to add them through phpMyAdmin and I think I have everything set except password.

Is there something I can insert in the table that will assign a random password?

Alternately I could use the 'reset customer password' mod but, again, with over 600 customers to add that might be a bit daunting.

Much Thanks!

[DrByte]

If you pre-generate some random passwords, then this thread may be of some help for reference: http://www.zen-cart.com/forum/showth...225#post284225

[Tig]

Thank you for the prompt reply!

... so I would randomly assign passwords (I'm sure there are word generators out there that can easily put out 600 within certain criteria), run the file and it should encrypt everything?

[DrByte]

That's the concept. The script in that post, if I recall correctly, assumes that you've already got the customer records loaded to the server, and just need to flip the unencrypted passwords into encrypted form so they can be used for real logins.

You'll have to load the database content manually yourself, and you'll have to communicate the customers' passwords to them separately on your own as well.

Loading the database involves 3 tables: address_book, customers, customers_info.
More information here: http://www.zen-cart.com/wiki/index.p...er_Information

[Tig]

... and here I thought there was only one table in the database that needed modification.

Thank God you guys are here! I would have screwed that up royally.

Thank you very much for your help. I still have to get the client list (large corporation; takes forever to get anything) but I think I should be ok.

... if not you'll definitly hear from me.

[DrByte]

I suggest some practice first, even while waiting on the list.
Create some customers and see how the data gets stored in various tables and cross-referenced with record/id numbers between the tables.

Then work on building a dataset that you can import to replicate the process.

Then test the encryption thing.

Then when you get your list you'll be ready to roll.