Customers without passwords, how to generate new passwords for them?

Hi guys,

So I have added all of our in-house customers to our nopCommerce database. I am not able to migrate their existing passwords, so I have a bunch of customers in our nopCommerce database that do not have a password. What would be the best way to generate a password for them (when they attempt to login the first time)?

I was thinking of duplicating/modifying the 'Forgot Password' mechanism along with some code that checks the email they enter during login/registration. Basically- if email exists and password is null, then send them an email with a link to the 'Forgot Password' form.

Has anyone attempted anything like this before? If so, how did you solve this issue? Thanks in advance guys!

I think the process you described is the best way around this. :)