Support » Fixing WordPress » Add multiple posts to a new category retrospectively

  • Resolved iansdell

    (@iansdell)


    I have a blog with more than 3,000 posts, and I’d like to add all of them to a new category.

    Using WordPress’s built-in bulk edit facility would mean applying the process to 214 ‘Edit Posts’ pages, 15 posts at a time.

    Does anyone know of a less laborious way of achieving what I want to do?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • vtxyzzy

    (@vtxyzzy)

    BACK UP YOUR DATABASE FIRST!

    This SQL should do what you want (replace the 7 with the term_taxonomy_id of the new category):

    INSERT INTO wp_term_relationships
    (object_id,term_taxonomy_id,term_order)
    SELECT ID,7,0 FROM wp_posts
    where post_type = 'post'
    and post_status = 'publish'

    If the category order is important to you, replace the 0 with a number higher than the maximum number of categories assigned to any post to make this the last category.

    MichaelH

    (@michaelh)

    Not saying anything about the solution but just to point out that you can change the “Screen Options” Number of posts per page to 999 and thus bulk edit ‘almost’ a thousand posts at one time.

    With that said, I would certainly follow vtxyzzy’s wise advise BACK UP YOUR DATABASE FIRST!

    vtxyzzy

    (@vtxyzzy)

    Thanks, Michael. That is a safer solution. It should automatically take care of the category order.

    iansdell

    (@iansdell)

    Perfect … thanks guys!

    Wow, never saw that one Michael.
    Note: it makes things quite slow on my older PC so OK for a one time operation but set it back later to 20 or something so that yo do not think that WP “freezes”.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Add multiple posts to a new category retrospectively’ is closed to new replies.