How can I delete all listings in my database, but without deleting the categories ???? I had a problem importing the csv, and I have to delete all records Besides importing the csv appears blank category or new categories ,will be a problem in truth csv ???? THANKS!
Hello, You can remove listings through Dashboard > Business listings After that upload csv again there is no need to leave category field empty in the csv file. Just upload it as it is. All your old categories will overwrite and new will be uploaded.
I can truncate the database from my server dasboard, but wich tables I have to truncate to remove all locations ? because I see that the locations information is organized in multiple tables
Hello, Go to function.php present in your theme directory and add the code given below Code: global $wpdb; $wpdb->query("DELETE FROM $wpdb->posts WHERE post_type='listing' and post_status='publish'"); Sending image for reference Firstly save that code in the bottom of function.php file and then refresh your dashboard and website, It will delete your all publish listings after that remove that code and again save your file.
