Mass status change

  • Because of some unknown problem my posts were imported into WordPress without defined status. If I try to edit any post, it appears with none of the three options clicked (draft, publish, private). The result is that the imported posts don’t appear on the blog. But, if I edit them mannually and set the status to publish, then they appear on the blog.
    So, basically, what I need is a way to make a mass change of post status. Because I have 700 of them. It must be some way to do it, or at least an advanced edit mode that makes the manual editing faster.
    Does anybody have any hint?
    Thanks.

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

  • https://www.ads-software.com/support/index.php?action=vthread&forum=3&topic=1657

    Thread Starter nando

    (@nando)

    I’m sorry, I have no idea what Jeremiah did in the database. I tried to dive into my SQL, serached inside wd_posts tables but didn’t find any option to mass-change posts status.
    I’m looking forward for help. Thanks!

    Thread Starter nando

    (@nando)

    Ok, I got a great help from IRC #Wordpress and the problem is solved. Just had to run a query in my SQL database and that was it.
    Thanks LaughingLizard.

    Is there any chance someone might be able to share what needs to be done in the sql database to bulk edit post_status? ??

    Use the following SQL commands:

    UPDATE wp_posts SET post_status='STATUS';

    Replace STATUS with private or public. This edits all posts by every user. If you have multiple authors and only want to edit one, you may use the following:

    UPDATE wp_posts SET post_status='STATUS' WHERE post_author='NUMBER';

    Remember to replace NUMBER with the correct ID number of the author.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Mass status change’ is closed to new replies.