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
Printable View
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
Why delete account without listings?
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.
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 ;)
Thanks Alex!