Page 1 of 1

Importing Customer Info

Posted: Wed Sep 10, 2008 7:42 am
by heinscott
Has anyone had to import a lot of customer information into your store? Right now, I am looking at close to 20,000 customers, and I am wondering the best way to go about doing the import. For starters, it looks like the DataPort utility does not create an address record for each customer... Is that true? Also, what about importing passwords? I guess the big question I need to ask is... How many tables are affected each time a customer is created? I think that I will need to touch the Users, UserPasswords, and Addresses tables in order to get all the information in manually.
Please let me know if you have any information for me that could help. I'll be writing something to do the import (at least for the passwords) in the meantime.
Thanks,

Scott

Re: Importing Customer Info

Posted: Wed Sep 10, 2008 7:43 am
by Robbie@FireFold
FireFold has the same question..

Except take 20,000 and make it 200,000. :shock:

Re: Importing Customer Info

Posted: Wed Sep 10, 2008 8:41 am
by jmestep
If you use an xml import the dataport will provide the right info- I'm not sure about how to get the passwords' encryption changed. I have done a couple of Able 5 store exports and those users imported correctly into Able 7 with all the data intact. You could format your xml using that xml format or the Able7 store export format as a pattern. I think I posted the xsd schema on the forum, but I can't find it now.

Re: Importing Customer Info

Posted: Thu Sep 11, 2008 12:27 am
by mazhar
Well guys i think you want a CSV import. We have already created an enhancement that DataPort should be capable to import User Password and User Primary address information including the telephone and fax numbers.
http://bugs.ablecommerce.com/show_bug.cgi?id=7124

Re: Importing Customer Info

Posted: Mon Jan 26, 2009 12:26 pm
by kastnerd
Id like to import my wholesale customers, But the password it used MD5+ Hash witch is basically impossible to decode.
Can i set a random password and then send out a mass email with a forgot password link?

Re: Importing Customer Info

Posted: Mon Feb 02, 2009 2:41 pm
by kastnerd
Any idea's on setting a random password for imported users?