Bulk posts from DRAFT Section

An way to do that is using SQL. You probably have access to the database, so you can run this daily. It’s not automatic, but will solve your problem

UPDATE wp_posts SET post_status="publish" WHERE post_status="draft" AND post_type="post" ORDER BY rand() LIMIT 5000

Just to explain what this line do: It will get 5000 items (LIMIT 5000) in a random order (ORDER BY rand()) and will transform the status to published (post_status=”publish”) on every record that is a post (post_type=”post”) and the status is draft (post_status=”draft”).

Hope it helps 🙂

Related Posts:

  1. Optimize post insert and delete for bulk operations?
  2. WP-CLI Bulk delete posts from specific category
  3. Invalid Post Type error when attempting to filter and Bulk Edit posts
  4. How to remove bulk edit options
  5. How To Add One Tag to Multiple Posts?
  6. How to bulk-untag multiple posts?
  7. how to bulk add one line in the first paragraph of all posts
  8. Bulk delete WordPress posts with phpMyAdmin
  9. SQL Bulk Move old posts by one author to another category
  10. Post in bulk based on category template
  11. How to delete all posts with dead image urls?
  12. Delete 100+ posts or media files from wordpress faster than default?
  13. Bulk replacing content of multiple pages/posts?
  14. Bulk Attach Or Insert Media To Post Without Opening Post Editor
  15. The next_posts_link() works only with original $wp_query
  16. Get Next / Prev 3 Posts in Relation to Current Post
  17. Query *only* sticky posts
  18. Elegant way to include only published posts with get_objects_in_term()?
  19. Using single.php from plugin folder instead of default template folder
  20. Disallow Same Post Title
  21. How can I see a list of pages and post where my custom Gutenberg block is used?
  22. Adding a div class or id inside the_content()
  23. getting video dimensions
  24. In what sequence are the hooks fired when a post is “published”?
  25. Number of posts per page setting is not working?
  26. $post->ID displays wrong ID
  27. how to display post content without post image?
  28. How to allow slashes in single posts when i click in the edit permalink button
  29. Load post content into div with ajax
  30. Why does `url_to_postid` return 0 when testing `page_for_posts` Page?
  31. deleting terms programmatically
  32. wp_enqueue_media() slows down my WP site
  33. Edit menu item title from edit page/post
  34. Including new Javascript only after a comment is made
  35. Don’t post or draft if post already exists
  36. add filter to “quick edit menu” in wordpress admin
  37. URL Rewriting if it is a single post / redirecting post – post type
  38. Archive Page for Custom Post Type is not Working
  39. Multisite – Get current post id
  40. how to remove dash (-) post status from post title on posts listing page wordpress
  41. Static page does not show my posts
  42. Get latest posts from WordPress site without header, menu and sidebar
  43. Errors when uploading images in WP 3.5
  44. Most liked page not displaying posts
  45. How can I replace WordPress standard process of editing posts with making WordPress use a custom page? [duplicate]
  46. Post’s “Read More” redirects to wrong post
  47. How to hide html tags on revision comparison pages?
  48. how to change the number of posts returned in a specific loop without making it global?
  49. Related posts by category not working right
  50. custom post template file not shown, instead all the time 404.php
  51. Display post x of y within category
  52. 2 dynamic sidebars registered, not showing up
  53. How to save meta checkbox WordPress
  54. Displaying post excerpt using wpdb query
  55. All posts display default index.html
  56. How to display Changing post link for 24 hours in x category
  57. Upload attachment from external site
  58. Disable posts generated from image uploads
  59. How to get the latest URL of my blog?
  60. Not all posts showing in query
  61. Related Posts: Changing Function For Posts Per Page
  62. Template for regular posts (no custom post types)
  63. WordPress query portfolio posts
  64. Rand post related question
  65. load more posts by category
  66. Import custom database into wp and keep the post id
  67. Retrieve a specific post’s featured image and show on a different page
  68. How to show multiple posts thumbnail, title and date in widget
  69. Remove all external links from posts
  70. Only the most recent post is showing on my category page (working on localhost, not live site)
  71. Blog Posts – Scroll to view more
  72. After updating to 5.9, when the posts page is loaded in the browser it uses wp-includes/template-canvas.php?
  73. Show only posts with titles/permalinks that do not contain certain words
  74. Manipulated offset and pagination, can’t display last post anymore
  75. Query to fetch custom taxonomy along with post title
  76. Change of author not updating
  77. Mysql update menu_order problem
  78. Single post shows post three times
  79. Change WordPress names duplicate titles (url)
  80. My posts page is missing the page title
  81. Blog Post slider not working
  82. WordPress template next_prev
  83. Disable archiving of old posts?
  84. Customizing individual images on posts
  85. Front end post delete error confirmation and success message
  86. Converting Posts to Pages
  87. Changing a field value on submit using a PHP variable
  88. Randomize access to post
  89. Run Jquery Script after delete post in front end
  90. Shortcode for printing post titles
  91. how to show posts on different pages if number of post per page is one
  92. TwentyThirteen theme Posts page shows posts instead of page content
  93. Not displaying any articles on a custom made file
  94. How can we pass a value from the_permalink() at WordPress?
  95. WordPress Yoast SEO plugin Post Save/Update Issue
  96. Wrap every 2 posts
  97. How to redirect image attachment to its original post
  98. How can I make my blog private? [closed]
  99. How to list first (etc. 5) posts as new?
  100. Add author section on Author archive posts
tech