Delete Spam Customers

[delia]

the issue is in this case - only one client who pays a tiny fee for maintenance costs per month. Not viable to spend a lot of time with any of this - especially reverse engineering anything. She's not yelling and is being patient. I would just like an easy fix here. And I'm not registering with your site to get access to an unproven module.

[balihr]

the issue is in this case - only one client who pays a tiny fee for maintenance costs per month. Not viable to spend a lot of time with any of this - especially reverse engineering anything. She's not yelling and is being patient. I would just like an easy fix here.

OK, no worries, hopefully Scott has an answer for you.

And I'm not registering with your site to get access to an unproven module.

LOL, okay... Sorry to have mentioned it...
Side note: yeah, you need to register, but what's stopping you to register with fake account details? Wilma Flintstone, 345 Cave Stone Road, Bedrock, wilma(at)f-spam.com
Best of luck, I hope you find a solution.

[delia]

So I discovered these crazy fake accounts are simply using the last active country so that all are one country - and the new changes fix the problem! Thanks, Scott, for adding that!

[swguy]

Version 1.2 released - Added a safeguard to prevent deletion of any customer with orders.

[delia]

Version 1.2 released - Added a safeguard to prevent deletion of any customer with orders.

Thanks. Pity the poor shop owner who found out this was necessary!

[swguy]

It never happened but I had a bad dream about it. You *could* have a customer from Zimbabwe who worked for Google and had a yandex.com email address!

[ianhg]

@swguy
I looked at your delete spam customers as you suggested.
I worked out if I add this it will remove customers who have not ordered, but I would prefer to not delete customers who have not ordered in the last month. Is there a way of amending this:

$queries[] = array(   'name' => 'Accounts with no purchase',    'string' => "SELECT customers_id FROM " . TABLE_CUSTOMERS . " WHERE customers_id NOT IN (SELECT customers_id FROM ".TABLE_ORDERS.")"); 

Assuming this is correct, as the plugin was originally yours do you want to amend it to include this or should I simply submit a revised plugin as Remove Customers who have not ordered?
Thanks for the guidance.