Overview:

Delete Spam Customers allows you to delete accounts that were added by bad guys. The query it uses by default is to remove accounts from Zimbabwe (the last entry in the countries list), but it can be modified to match whatever patterns the bad guys are using. In version 1.1 or higher, multiple queries can be performed to catch different patterns.

Installation Instructions:

1. Back up everything! Try this in a test environment prior to installing it on a live shop.
2. Copy the contents of the unzipped folder to the root directory of your shop.
3. Run the delete_spam_customers.sql file against your database, using Admin > Tools > Install SQL Patches.
4. Run Delete Spam Customers from under Admin > Customers.

Major Versions

• 1.1 03/01/2021 - Permit multiple queries to be done
• 1.0 06/11/2019 - First Release

FAQ

Q: I got hit with a block of spam signups and the customer IDs were 550 to 599. How do I delete those?
A: Add a new query in admin/delete_spam_customers.php as follows:

$queries[] = array(
   'name' => 'New Accounts',
   'string' => "SELECT customers_id FROM " . TABLE_CUSTOMERS . " WHERE customers_id BETWEEN 550 AND 599");

Q: I got hit with a block of spam signups and the company field for those customers is always "google". How do I delete those?
A: Add a new query in admin/delete_spam_customers.php as follows:

$queries[] = array(
   'name' => 'New Accounts',
   'string' => "SELECT customers_id FROM " . TABLE_ADDRESS_BOOK . " WHERE entry_company = 'google'"); 

Q: I got hit with a block of spam signups between 08/01/2019 and 08/30/2019. How do I delete those?
A: Add a new query in admin/delete_spam_customers.php as follows:

$queries[] = array(
   'name' => 'August Accounts',
   'string' => "SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created > '2018-08-01' AND customers_info_date_account_created ≤ '2018-08-30'"); 

Q: My spam signups all use email addresses from @mail.ru. How do I delete those?
A: Add a new query in admin/delete_spam_customers.php as follows:

$queries[] = array(
   'name' => '.ru emails',
   'string' => "SELECT customers_id FROM " . TABLE_CUSTOMERS . " WHERE customers_email_address LIKE '%@mail.ru'");

---