Add Customer(s) through database?

Locked

Results 1 to 6 of 6

This thread is locked. New replies are disabled.

25 Jun 2008, 19:27

tig

Zen Follower

Join Date:: Apr 2006
Posts:: 123
Plugin Contributions:: 0

Add Customer(s) through database?

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!

25 Jun 2008, 19:32

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Add Customer(s) through database?

If you pre-generate some random passwords, then this thread may be of some help for reference: http://www.zen-cart.com/forum/showthread.php?p=284225#post284225

25 Jun 2008, 19:40

tig

Zen Follower

Join Date:: Apr 2006
Posts:: 123
Plugin Contributions:: 0

Re: Add Customer(s) through database?

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?

26 Jun 2008, 00:01

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Add Customer(s) through database?

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.php/Developers_-_Database_Schema#Customer_Information

26 Jun 2008, 11:05

tig

Zen Follower

Join Date:: Apr 2006
Posts:: 123
Plugin Contributions:: 0

Re: Add Customer(s) through database?

... 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.

26 Jun 2008, 16:27

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Add Customer(s) through database?

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.