Support » Fixing WordPress » Faster way to assign categories to hundreds of imported posts?

  • Setting up a new site with an import from my old WebCrossing instance. (And if anyone ever needs help converting SGML export files to RSS 2.0, just let me know.) I’m retroactively rolling through seven years of old posts and assigning them to categories to replace the taxonomy I had on my old site. As you might guess, this is extremely time-consuming.

    Can someone suggest a plug-in or database hack that will allow me to do this more efficiently? Ideally I’d have an admin drop-menu or a checkbox form on the initial display page. I’ve been through a number of lists of plug-ins, but haven’t found one that works yet. WP 2.0; old hand at web databases, but a newbie here, so forgive me if I missed something obvious.


Viewing 5 replies - 1 through 5 (of 5 total)
  • I know there is a batch categories plugin, I haven’t used it myself yet and I have no idea if it play well with WP 2.0/2.0.1. Try to find it, I can’t remember where it is, but let me know and I can post it for you if you can’t find it.

    Also, please report back here if it does work and all that, it would be very helpful to anyone else in the same situation!


    I tried using Batch Categories 0.91 from, which is linked on one of the codex pages. Errored out on install, don’t know if that’s because it’s out of date (it was posted in 2004) or because I’m not savvy enough.

    I’m guessing I might also be able to do this with a direct database hack, but no idea how to do that. Suggestions welcomed.



    the plugin doesn’t work for me either using wp 2.0.5. it must be outdated. any help is appreciated.



    If you have phpmyadmin, you should be able to mass-edit the entries directly in the database. Otherwise, you’re talking about typing up a LOT of SQL.

    I’m in the same situation, but I can’t figure out the appropriate syntax for what I need to do. The posts I’m looking at have no category assigned to them, not even “unfiled,” and I’d like to assign all 1200+ imported posts to a single category.

    Does anyone know what the syntax would look like?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Faster way to assign categories to hundreds of imported posts?’ is closed to new replies.