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
Importing Customer Info
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: Importing Customer Info
FireFold has the same question..
Except take 20,000 and make it 200,000.
Except take 20,000 and make it 200,000.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Importing Customer Info
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.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Importing Customer Info
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
http://bugs.ablecommerce.com/show_bug.cgi?id=7124
Re: Importing Customer Info
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?
Can i set a random password and then send out a mass email with a forgot password link?
Re: Importing Customer Info
Any idea's on setting a random password for imported users?