Bulk deleting customers: Does this option exist in the admin panel ???

We have a huge number of bots that has signed up as customers, and I need to delete about 1000 of them.   If I could even select and delete a full page of customers at a time it would be workable.   But the only solution I see on Version 4.200 is moving the screen to the right to get to the edit button, clicking EDIT, clicking DELETE, and then confirm DELETE on every single customer.   That is a lot of steps for each one, not time effective when I am trying to run a business.

I see some people going into the server database and mass deleting bot customers, but most of us that run businesses do not have the ability to do things like this...  I would be willing to bet that most of your users accomplish everything through the ADMIN PANEL.  Most users have a web programmer install and set up the store, and then the businessmen runs the store using the ADMIN PANEL.

I did a google search on this issue, and see that many people have been requesting this option for YEARS. This feature is standard in most other store software.  If the option is there, and I just did not see it, then I take full blame for being a dumbass and apologize :)   I put a crazy number of hours into running all aspects of our business, and there is no way I would have the time to learn to go into servers manually and add program lines, etc. etc.  I know there are those that would just say " learn to do it ", and I probably could learn eventually, but it would take so much time, my business would be badly damaged, customers would be unhappy, so just " learning to do it " would be a really bad business decision.  Development Team:  Please realize the need to make things easy for users like us that do everything through the Admin Panel.

Thanks !

JetPilot wrote:
No, there is no option at default nopCommerce. And right, many people asked for this already.

Regards,
Tom

Definitely this plugin will help you.
https://www.nop-station.com/bulk-delete-customer

I am doing this exact process right now. I have over 1000+ dummy / junk customer accounts in my database with nothing but spam and junk data.

This process is a 5 click/type process to delete ONE customer.  (5000+ clicks)

1.) Click on Company
      a.) Past google from clipboard (not typing that over and over)
2.) Click Search (because the default [ENTER] button is linked to Export Customer List)
3.) Click Edit
4.) Click Delete

After a little bit of time searching for a simple solution for this I find posts saying this has been an issue for YEARS? The only option that appears to be a simple fix is a $10 plugin someone wrote !? Thanks for the contribution, but if I am going to pay $10 for a patch from the community for my instance. I would rather donate $10 to the project to fix this for ALL users.

This should be as simple as Filter by company (in my instance) select all and delete. You already have this functionality for Exporting Customers. This should only take a developer what an hour to implement a Delete Selected option?

Yes, I agree it should be a built-in feature.  You may be able to save a little time in your manual process if, rather than clicking the Edit button, you right-click it and "open in new tab" (or window).  Then, you would not have to Search all the time but you do need to keep track of where you are in the list and you would need another click to close the extra tab.

If you have access to a SQL tool, then you could write some SQL to do it.  In your case, looking for Company = 'google' does require a join to Attribute table.   What I've done in the past is to change the customer's Role from Registered to Guest, and then let the "Delete Guests" scheduled task take care of the deletion  (so that my SQL would not have to to the validations that the task does, like check for shopping cart, and also delete any related records).   I'll post some code later.

mhsjaber wrote:

Does this plugin actually delete the customers from the database or just mark them as deleted? I need to free up space in the database so just marking them will not help me.

Also, does it delete any corresponding data in other customer tables (dbo.CustomerRole etc.) in the database, or just the actual dbo.Customer table? Anything that would cause an issue if just the actual customers were deleted from the dbo.Customers table...

New York wrote:


Just read this one before posting the last comment! Sorry. Did you have a solution as far as a direct SQL query was concerned?

dashdesigns wrote:

It will just mark them as deleted, not delete them permanently. All data from other tables will remain same.

I cannot believe after all of these years NOPCommerce has not added this function or better validation. My customers that use this product complain on the time they spend on maintaining SPAM accounts. Another solution I found to work in the US based customers is to block all international traffic from our sites on our Firewall. Sonicwall has a subscription based service that will block all IPs that are not USA based. Most of the SPAM is coming from China and Russia IP addresses according to my logs.

There are plugins in the marketplace that can block spammers: examples.  Also, the web.config can be used to block IP addresses.