How to remove all customers who have never ordered before?

[ebookba]

My site is hit by registration spam, and removing each customer manually from the admin is not feasible.

I am now thinking about using phpmyadmin to do the job. What should be the mysql line to remove these spam from database?

Thanks in advanced.

[Ajeh]

There are a number of tables that need to be addressed:
address_book
customers
customers_info
customers_basket
customers_basket_attributes
products_notifications

You would need to verify the customers_id against the table:
orders

If nothing is found, then clean up the customer tables ...

It would be a good idea to also check against the table:
customers_info

for when the customer's account was created so that you do not delete customers that are new, without orders, but may have not had time to complete or make an order yet ...

[dgent]

I tell you what ive found with the spammers, is they always select the first country on your country list. So I have made my first country option 'Please Select' so then I know which ones are spam.

[ebookba]

Thanks for replies.
Actually the spammers on my site come from the same source and use the exact same address when registration. But because I'm not very familiar with server programming, I still cannot figure out a way to mass delete them from database.

[dgent]

Thanks for replies.
Actually the spammers on my site come from the same source and use the exact same address when registration. But because I'm not very familiar with server programming, I still cannot figure out a way to mass delete them from database.

Well thats easy then. If they all use the same address just search for that address in the customers table, and it will bring up all the customer with that address in a big list. Then you can mass delete.

[MagicMan]

Sounds like there are quite a few of us having the same bogus customer issues. Mine are all coming from China. I have recorded the ip addresses and have blocked them on my hosting server. This has taken care of it for me. I blocked out the entire range of them. I know, this stinks.

[toujours]

Hiya,

I seem to have the same problem on one of my sites, starting about the 10th of the month. I've successfully deleted all of the offending "customers," but from what I can tell, they've set up a proxy in Sweden. I don't want to block potential customers coming from Sweden, so I'm loath to set up an .htaccess deny. Does anyone have others ideas how to prevent more of this from trickling in?

Thanks in advance...

[freya]

I am having the same problem. How do I do the search in myPHPadmin? They use one of two addresses with bogus names. And they are all from China.

[freya]

I couldn't do the search as it didn't turn up anything, but I did manage to do bulk deletes by going into the address book in phpMyAdmin and deleting entire pages of spam customers. 30 at a time is much quicker than one. I am going to try the suggestion that makes them pick a country. Maybe that will slow them down. (Thanks for that suggestions, BTW.) :)

[dgent]

I couldn't do the search as it didn't turn up anything, but I did manage to do bulk deletes by going into the address book in phpMyAdmin and deleting entire pages of spam customers. 30 at a time is much quicker than one. I am going to try the suggestion that makes them pick a country. Maybe that will slow them down. (Thanks for that suggestions, BTW.) :)

It works, I confirmed it last night, with no sign ups. Go into phpadmin and change the '-Please Select' country ID to 0. Thats all you have to do. You don't need to chanege the code in create_account.php.