Drafts Scheduler
[resolved] Plugin to Bulk move published articles to draft (4 posts)

  1. mikenash100
    Posted 3 years ago #

    Is there a plugin to move already published articles to draft folder in bulk?

  2. Jeff Rose
    Plugin Author

    Posted 3 years ago #

    No need for a plugin. Simply select ALL on screen, then from the actions drop down, choose edit, then change the published status.

    You can adjust the number of posts per screen from the SCREEN OPTIONS pulldown.

  3. aquapan
    Posted 3 years ago #

    if you want to do all of them bulk you can in phpmyadmin with this sql line :

    UPDATE wp_posts SET post_status = 'draft' WHERE (post_type ='post' and post_status = 'publish') ;

    *** warning this will set ALL posts to 'draft' status so make sure you are ABSOLUTELY CERTAIN you want to do this :) ***

  4. Lubyg
    Posted 2 years ago #

    Excellent on the SQL Command aquapan! I just reversed it to set drafts to publish in a WP Network. Of course, I selected my table for the subweb and changed the prefix since I installed WP Better Security which changes the prefix of the table name. To reverse it just change swap out the words draft and publish making sure your other parameters are correct for your WP install.

    Thank you!

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Drafts Scheduler
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic