Mass manage / delete (child) categories

  • hielkio

    (@hielkio)


    5 years ago

    Hi folks,

    I thought I was creating the right structure when importing my address CSV file with around 9000 rows in it. What I did wrong, was creating a category for every item / row.

    Isn’t there a “faster” method to delete child-categories? Or child-child-categories..
    I’m absolutely no developer, but more a designer.

    Anyone who has a query example? Or some other solution maybe.
    There must be a query available to do such. In that case I don’t think it would be very hard for the WP developers to attach that to some function in the backend. But maybe I’m completely wrong here ??

    Thank you for thinking with me!

    • This topic was modified 5 years ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    The category term queries are more complicated than you may realize. If you are sure there are no child terms to be deleted which are assigned to posts it greatly simplifies things. You are right in that a SQL expert could likely whip up a query in short order. I’m not that guy though ??

    Did you know you can increase the terms per page up to a max. 999? Use the screen options tab at upper right of the category list table. You could then at least bulk delete everything on one long page. The problem with doing large bulk deletes is it’ll take longer than the default 30 sec. max. execution time for PHP. You can increase the max. time with this line added to wp-config.php:
    set_time_limit( 300 ); // 300 second max. execution
    It’s not a good idea to leave it that long all the time, but for specific actions it’s OK. You can specify almost any time limit. I think 300 sec. will be OK for 999 category terms, but it largely depends on your specific server resources.

Viewing 1 replies (of 1 total)
  • The topic ‘Mass manage / delete (child) categories’ is closed to new replies.