Overview:

Delete Spam Customers allows you to delete accounts that were added by bad guys. The query it uses by default is to check a first or last name with a link, but this can be modified to match the pattern the bad guys are using, or to be based on a date or account id range.

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.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: Set the $query variable in admin/delete_spam_customers.php to

$query = $db->Execute("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: Set the $query variable in admin/delete_spam_customers.php to

$query = $db->Execute("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: Set the $query variable in admin/delete_spam_customers.php to

$query = $db->Execute("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: Set the $query variable in admin/delete_spam_customers.php to

$query = $db->Execute("SELECT customers_id FROM " . TABLE_CUSTOMERS . " WHERE customers_email_address LIKE '%@mail.ru'");

---