-
July 17, 2020, 01:12 PM
#1
Senior Member
Bulk Remove Users Without Listings
Hi,
How would I go about bulk deleting using accounts that do not have any listings? It would have to be segmented by account type as I do not want to delete any admin accounts.
Thanks,
Jason
-
July 17, 2020, 05:33 PM
#2
Master
Why delete account without listings?
-
July 17, 2020, 11:08 PM
#3
Senior Member
I have a subset of listings and users that are received via an xml feed that is updated daily and at any given time the 'find a dealer' page can have 1000's of user accounts. It's cleaner to only display dealers with vehicles, plus it helps the database not be as cluttered.
-
July 18, 2020, 01:06 PM
#4
Member
You can use SQL Query to do that,
For example:
DELETE FROM {your_database_prefix}_accounts WHERE `Type` = 'dealer' AND `Listings_count` = 0;
This Query will delete all users with type: "dealer" and Listings_count equals 0
Dont forget backup your database before
-
July 20, 2020, 05:50 AM
#5
Senior Member