Jump to content

Oscommerce to Prestashop import CSV. Wrong passwords.


Recommended Posts

Hi !

 

I have exported my oscommerce 2.2 database to a .csv file. Then in Prestashop 1.5 i imported it choosing the right columns.

 

The importation is correct, and i have all my customers in Prestahop, but when i try to login into the store using my client password, it says it is not ok.

 

Any idea ?

 

Txs !

Link to comment
Share on other sites

  • 3 months later...

The PrestaShop import probably expects the passwords to be the real ones instead of the hashes coming from the other base. Of course, it is not possible, as the clear passwords are only known from the user, not from the shop, which only stores the hashes: ie. it is only able to verify the password is correct (resulting to the same hash). This prevent from password stealing we see in some insecure sites (intruders breaks in and steal the user database, including the passwords in clear, often usable on other sites!).

 

The downside is that it is difficult to migrate the passwords...

 

There are some solutions.

- For example, generate new passwords for each of your client, put them in the file to import, and e-mail the new password for each of your client when you advise them of the shop change... These e-mails can end in the spam box...

- Alternatively, just let the users ask the new password via the Forgot password? link. PS will generate a new one they will use. Upside: it is on demand, no massive e-mail sending, only the clients coming back will request the password. Downside: some users can get frustrated their password doesn't work if they are sure of it, and can go away. A personalized message (systematic for a while, or only displayed if the e-mail is recognized) can help.

- Or do a SQL request to restore the old password in the database. But I think the column must be resized, as the old password has three additional characters (colon and two digits, the salt, I think). In this case, the shop can detect it holds an old password and can apply the old password verification. If it matches, it can then hash the password (it knows it from the request) and store the new style of password in place of the old one.

It is a technique I saw in the importosc module I saw in stock PrestaShop, but I haven't seen a clear explanation how it is supposed to work...

Link to comment
Share on other sites

  • 8 months later...
  • 6 months later...

Hello, we have a "shopimporter" module that will be able to import your shops information into PrestaShop. The oscommerce module is no longer supported. 

 Hi, sorry I was not able to find the "shopimporter" module from back-office of Prestashop 1.6.

Link to comment
Share on other sites

  • 9 months later...

You should know that all password stored on osCommerce are encrypted specifically and these passwords are just used on osCommerce system. All passwords (encrypted by osC) will be moved to Prestashop but they are useless on Prestashop, because Prestashop and osCommerce using different encryption algorithms.


I recommend to use "Prestashop Customers Password Migration plugin"by LitExtension, it is extremely helpful to migrate customers password. This plugin able to convert the encryption algorithm from osCommerce to Prestashop automatically. After migrated, your customer can use his old password (on osCommerce store) to login to Prestashop.


Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

I am done with the migration with litextensions software. But unfortunatly they do not help me with my questions. Two things that I having issues with now is

 

1. The passwords are not working. Du you have any solution for only migrate the passwords?

 

2. The old stores url redirect "Migrate Product and category seo url" that I paid extra for do not know if it did work or not. Can anyone tell me how I can check that this migration has been sucessful? Where int the target shop are the old urls stored? In a file? In the db? Can not find it and would like to know if this really worked.

 

EDIT: I have now got help from Litextension.

Edited by helikoptermannen (see edit history)
  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...