OsCommerce import customer database

[jelf]

I need to find a good method of importing a database of around 3,000 customers from another shopping cart (csv) into a new oscommerce installation.

Anyone have any tools or links which would help.

Thanks,

 

[Houdas]

It depends on the structure of the database (mysql i presume) table the OS commerce uses. Should be quite an easy task in PHP - I could help you, send me a short example (a couple of rows) from the CSV file along with the structure of the mysql table for customers and I'll see what could be done.

 

[fm1234]

It's actually easy to do jelf, any database management software will do it including phpMyAdmin. The only catch is the passwords, which will probably end up useless.

If that happens, and if this is an active/current customer list, I'd recommend e-mailing them ahead of time to let them know that on x date their password will be reset automatically by the system, and the next time they log in just to hit "Forgot My Password" to get a new one.

Next, before uploading the CSV just set all the passwords to the same random value. Then upload it and let the customers who actually come back handle the change.


Frank

 

[Bofu2U]

It's actually easy to do jelf, any database management software will do it including phpMyAdmin. The only catch is the passwords, which will probably end up useless.

Frank has a good point. Check how the password's are saved (encrypted/hashed etc) because if they just use md5 you're fine, if they use md5 + salt, you're fucked (unless you rehash them), and md5 + salt + offset etc etc you're screwed)

Just wanted to follow up so you had some keywords to look for (md5 etc)