cancel
Showing results for 
Search instead for 
Did you mean: 

Spam signups

Highlighted

Spam signups

Hi I would like to delete spam signups based on the data in the name field.  I can delete them based on the email field using SQL but a lot of spammer but http in the name field.   I can't do it in the admin section because there are over 40000 of these accounts.  I would prefer to do it via sql or possibly php script.  Any suggestions?

2 REPLIES 2
Highlighted

Re: Spam signups

@tonycanada16f1 

 

Try below query running:

DELETE FROM `customer_entity` WHERE email like "%qq.com%";

Suggesting few articles to read as well:

https://inchoo.net/magento/delete-spam-customer-accounts-magento/

https://magento.stackexchange.com/questions/292135/how-to-remove-spam-customer-account-through-exten...  

Manish Mittal
https://www.manishmittal.com/
Highlighted

Re: Spam signups

Hello @tonycanada16f1 ,

 

Prevention:

Most of the spambots will be filtered out by activating Magento’s built-in captcha for the registration form. So it's better to use the captcha.

It can be easily activated in administration under Settings->Customer->Customer Configuration->CAPTCHA. there are several options, as well as forms to be activated on.

you can check the following guide 

 

https://inchoo.net/magento/delete-spam-customer-accounts-magento/

 

Thanks 
Problem solved? Click Kudos & Accept as Solution!