
Zen Cart Delete Spam Customers
The Delete Spam Customers plugin allows you to easily remove accounts added by bad guys.Donate: This is free software. Show your appreciation by supporting my efforts.

Relevance: Zen Cart™ 1.5.4 and above
Current Version: 1.0 (version history)
Support Thread: Delete Spam Customers Support Thread
Cost: Free, but donation appreciated
Installed Cost: $120.00 Buy Professional Installation by That Software Guy
Installation Difficulty: Difficult - requires customization based on what's happening.
Installation Instructions: click here
Location: Zen Cart Plugins, under Admin Tools
Download: Delete Spam Customers in Zen Cart Plugins
FAQ: click here
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:
- Back up everything! Try this in a test environment prior to installing it on a live shop.
- Copy the contents of the unzipped folder to the root directory of your shop.
- Run the delete_spam_customers.sql file against your database, using Admin > Tools > Install SQL Patches.
- 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'");