Customers able to have several logins.. with the same email address!

[JRR]

Is there an obvious way to stop people from being able to create several accounts using the same email address? (I thought we had sprayed for that!)

I've rummaged through the settings but I must be overlooking something obvious.

And, now that I have a few customers who had two or more accounts, is there any way to merge them into the latest version AND include previous orders?

Trying to tie up loose ends here...

Thanks!

[ridexbuilder]

The system *should* disallow registration using the same email address, though I noticed the same problem recently on one site. I assumed it was due to upgrading an old version of osCmax. I haven't investigated the cause, however.
In the database, I always thought the customer email was as a key field. Looking in the customers table, for the above mentioned site, I see that it is an indexed field but not a secondary key. This suggests the create_account code isn't checking for duplicates properly..
I believe this is where the problem was introduced:

      $check_email = tep_db_fetch_array($check_email_query);
 //---PayPal WPP Modification START ---//     
      //if ($check_email['total'] > 0) {
      if ($check_email['total'] > 0 && tep_paypal_wpp_create_account_check($email_address)) {
//---PayPal WPP Modification END ---//
           $error = true;

           $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
      }

I'll have some further thoughts on the subject (hopefully).

As for merging records, that becomes complex. Fortunately on the above mentioned site, the duplicated records didn't have sales attached and I was able to delete the duplicated customer records.

[ridexbuilder]

I suggest altering that section to the following:

      $check_email = tep_db_fetch_array($check_email_query);
 //---PayPal WPP Modification START ---//     
      if ($check_email['total'] > 0) {
      // disabled WPP mod - if ($check_email['total'] > 0 && tep_paypal_wpp_create_account_check($email_address)) {
//---PayPal WPP Modification END ---//
           $error = true;

           $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
      }

Note: untested but I can't see the point of the check being exclusive to PayPal Pro.

[JRR]

Jeeze ridexbuilder (Jim, isn't it?) didn't you get enough beer already?

In case people are coming in late the file to edit is create_account.php in /catalog

I've made the change, now let's see if it works from today on. I can see more beer in your future if it does!

Thanks!

John :-#)#

[ridexbuilder]

LOL. Nope wrong name.
"There's life, Jim but not as we know it."

You're the Guinea Pig. Should be easy enough to test that it prevents an additional signup. Now I'll need to visit my dozen or so client sites, to make the wee change. None of the clients use Website PayPal Pro, so there shouldn't be a problem.

EJ

[JRR]

Hi EJ and anyone else reading,

Turns out that I had about 30 duplicate customer registrations in the 5,000+ list of customers so finding them was going to be tedious without some tools.

I downloaded the customer list from osCmax and stuffed it into my spreadsheet (Liberoffice) and sorted by email.

Then searched online for finding duplicate data in a column...

Then ran the formula and which highlighted the duplicates, then I simply deleted all the customers who were not duplicate/triplicate/? leaving the customers with two or more email addresses.

Then I opened my database - taking great care to opening it using the Read/Write user, NOT the ADMIN otherwise you might break your database!

I then looked for orders under the last name in osCmax and if found, then went to orders in the database and changed them (if more than one) to the last user number. then I deleted the earlier user.

Hope that is clear enough!

John :-#)#

[ridexbuilder]

Well done. That's pretty much the approach that I'd have gone for; I did say it'd be a bit complex.