Export customer data

[Guest]

I am creating a seperate "store" and wanted to add my customers to it. How can I export my customer data (Including password) to a comma delimited file?

 

Thanks,

 

-Alfred

[Guest]

The password is encoded, so you can't see it in the database, but you can certainly export your MySQL database and then import it into another store.

 

-jared

[Guest]

The problem is that the new "store" is in an online mall and is not osCommerce. The programmer tried to extract the data but says that there are pieces of it in several different databases. Any tools exist that could be used to extract both the customer data (Name, Shipping address, billing address, email address, password, etc.)?

 

Thanks,

 

-Alfred

 

The password is encoded, so you can't see it in the database, but you can certainly export your MySQL database and then import it into another store.

 

-jared

<{POST_SNAPBACK}>

[Guest]

your programmer should be able to get that info extracted fairly easily via exporting

[Rob123]

The problem is that the new "store" is in an online mall and is not osCommerce.  The programmer tried to extract the data but says that there are pieces of it in several different databases.  Any tools exist that could be used to extract both the customer data (Name, Shipping address, billing address, email address, password, etc.)?

 

Thanks,

 

-Alfred

<{POST_SNAPBACK}>

 

Here is a high level plan of action:

1. Determine the requirements from your new "store". Which fields are required and which fields are nice to have?

2. Export the selected data (from step 1) from the osCommerce database into a CSV.

3. Import the values using an appropiate program/utilitily/gui for your new store.

 

Of course the above is easier said than done but it's very straight-forward. The business challenge for you is to decide what are your required fields and how to handle the new password for your customers.

 

A year ago I helped a friend migrate to osCommerce from a different "store".

He decided to have his old customers click the "Password forgotten?" link.

 

HTH,

Robert

[Guest]

Is there a way to extract the passwords as well? I would assume that it is not a very sophisticated "encryption".

 

Thanks,

 

-Alfred

 

Here is a high level plan of action:

1. Determine the requirements from your new "store".  Which fields are required and which fields are nice to have?

2. Export the selected data (from step 1) from the osCommerce database into a CSV.

3. Import the values using an appropiate program/utilitily/gui for your new store.

 

Of course the above is easier said than done but it's very straight-forward.  The business challenge for you is to decide what are your required fields and how to handle the new password for your customers.

 

A year ago I helped a friend migrate to osCommerce from a different "store".

He decided to have his old customers click the "Password forgotten?" link.

 

HTH,

Robert

<{POST_SNAPBACK}>

[Rob123]

Is there a way to extract the passwords as well?  I would assume that it is not a very sophisticated "encryption".

 

Thanks,

 

-Alfred

<{POST_SNAPBACK}>

 

I hate to disapoint you but the password encyption is quite sophisticated.

The offset in the database is actually a "one-way hash". Since the password function uses a MD5 algorithm, the encryption strength is 128 bit.

 

By definition, a "one-way hash" is impossible to reverse. It is theoretically possible to brute force but that would take too long for your goal.

Passwords are verified/validated by comparing offset of the customer entered password to the one already stored in the database.

BTW, this would also explain why the "Forgotten Password?" link creates a new password and does not retrieve the old one.

 

I hope that I didn't bore the readers too much. If anyone feels that I am grossly incorrect, please feel free to correct me.

 

Hope that clarifies things,

Robert

[Simmy]

I hate to disapoint you but the password encyption is quite sophisticated.

The offset in the database is actually a "one-way hash".  Since the password function uses a MD5 algorithm, the encryption strength is 128 bit.

 

By definition, a "one-way hash" is impossible to reverse.  It is theoretically possible to brute force but that would take too long for your goal.

Passwords are verified/validated by comparing offset of the customer entered password to the one already stored in the database.

BTW, this would also explain why the "Forgotten Password?" link creates a new password and does not retrieve the old one.

 

I hope that I didn't bore the readers too much. If anyone feels that I am grossly incorrect, please feel free to correct me.

 

Hope that clarifies things,

Robert

<{POST_SNAPBACK}>

 

So Rob,

 

Does that mean if you have to restore your database from a backup, your passwords are stuffed??

[Guest]

if you restore the database, then you are restoring what the last passwords were, prior to them being changed, (if the customer has changed them).

[Simmy]

if you restore the database, then you are restoring what the last passwords were, prior to them being changed, (if the customer has changed them).

<{POST_SNAPBACK}>

 

:blink: So does that mean if he uploads his backup to his new store the passwords will work? Or have I missed the point somewhere?

[Rob123]

Hi Simmy,

You can always backup/restore your database. The customer passwords will be whatever they were during the last backup.

 

Alfred said

"The problem is that the new "store" is in an online mall and is not osCommerce."

I was trying to make the following point...

You can export the encrypted password offsets using phpmyadmin or any other tool.

However you should only restore them to another osCommerce database.

If you restore them to another (non-osCommerce) store, the customer passwords will not work.

 

I hope that makes sense,

Robert

[Simmy]

Hi Simmy,

You can always backup/restore your database.  The customer passwords will be whatever they were during the last backup.

 

I was trying to make the following point...

You can export the encrypted password offsets using phpmyadmin or any other tool.

However you should only restore them to another osCommerce database.

If you restore them to another (non-osCommerce) store the customer passwords will not work.

 

I hope that makes sense,

Robert

<{POST_SNAPBACK}>

 

Gotcha now. Was a bit confused for a while there but then it's not too difficult to confuse me!!!

 

B

[Guest]

Oh well... It's unfortunate I have to move my store away from osCommerce, I really like it and will continue to use it for another business I am going to build. Unfortunately the bulk of my sales are coming from my affiliation with this online "mall" and it has become a real burden to update both sites with my inventory. The guy that runs the site was nice enough to port over everything so that I can have my own "site" where my domain name goes straight to my store without parts of the mall showing up. BUT- I don't want to lose out on my 750+ customers that are already registered!

 

Any ideas would be appreciated. I am going to start losing hair over this. :(

 

Thanks,

 

-Alfred

 

Hi Simmy,

You can always backup/restore your database.  The customer passwords will be whatever they were during the last backup.

 

Alfred said

I was trying to make the following point...

You can export the encrypted password offsets using phpmyadmin or any other tool.

However you should only restore them to another osCommerce database.

If you restore them to another (non-osCommerce) store, the customer passwords will not work.

 

I hope that makes sense,

Robert

<{POST_SNAPBACK}>

[Guest]

You may be able to come up with a good way to spin this. Tell them that by moving to the new store, it'll be better for them because you'll be able to offer services x y and z, or better prices, or something. Try to explain how good it'll be for them, and that in order to do that you have to move their account to a new system.

 

Obviously, for security reasons, you can't tell what their password is, so they'll have to reset it. Make sure that they don't actually have to re-register (even if you have to create a universal bogus password).

 

Good luck.

 

-jared