Bulk move of questions between categories...

Question

I have started adding questions to a category ( more than 100 ). I want to create 2 subcategories and move 50 to one category and 50 to another. How can I do bulk moves ? I tried doing it from the database ( update qa_posts - categoryid, catidpath1, catidpath2 etc ) but that didnt help. Any other tables to update ?

 

Thanks

Answer 1

Just update the categoryid on the posts in the database, then click to recalculate categories in the stats section of the admin panel.