Zen Cart custom software development, Zen Cart modules, Zen Cart Expert eCommerce with Zen Cart!

Zen Cart Delete Spam Customers

Zen Cart Delete Spam Customers

The Delete Spam Customers mod allows you to easily remove accounts added by bad guys.

Donate: This is free software. Show your appreciation by supporting my efforts. Donate

Relevance: Zen Cart™ 1.5.4 and above

Current Version: 1.0

Support Thread: Delete Spam Customers Support Thread

Cost: Free, but donation appreciated

Installed Cost: $60.00 Buy Professional Installation by That Software Guy

Installation Difficulty: Moderate

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:

  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 * 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 * 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'"