I need to bulk update all wordpress posts on a scheduled time

This is what I used, if I’m understanding you correctly.

UPDATE wp_posts SET post_date=NOW(),post_date_gmt=NOW(),post_modified=NOW(),post_modified_gmt=NOW();

Worked for me.

Related Posts:

  1. wp_update_post() example… how to update the_content in a textarea?
  2. Why wp_update_post() does not update GUID?
  3. What are the limitations of wp_update_post()?
  4. wp_update_post does not update post_name
  5. How to disable saving/changing update date for certain admin users?
  6. “Internal Server Error” with wp_update_post
  7. wp_update_post using post_name
  8. how to get last revision id created after wp_update_post
  9. why wp_update_post cant update when value is empty?
  10. update a post with wp_update_post
  11. Updating posts not working
  12. Update a post’s info when clicking on a javascript button
  13. What ‘function’ will ‘update’ a post?
  14. wp_update_post meta causing 500 error
  15. Updating post_parent by id (many times)
  16. wp_update_post making my post sticky
  17. Is it possible to “Update” pages via SQL?
  18. Update post meta is slow while saving post
  19. Update post (published) date when changing category
  20. recursively update content
  21. wp_update_post ignores if/else
  22. $wpdb->update query incrementing value on it’s own!
  23. Update button (sometimes) greyed-out
  24. Set a post to draft once depending on a post meta value (passed certain date)?
  25. wp_update_post behaves differently for different user role
  26. Fatal error: Call to undefined function wp_cache_get after update attempt
  27. How to avoid infinite loop in save_post callback
  28. wordpress function to change post status [duplicate]
  29. Connection lost. Saving has been disabled… (Updating Posts/Pages)
  30. Why doesn’t wp_update_post() update the post_status field?
  31. Post/Page Publish/Update button not clickable once I make an edit
  32. Automatically fill custom field value on post publish/update
  33. Scheduling posts to update once per day with wp_cron
  34. Fill post titles from post content?
  35. Keeping post_date same as the pending post_date on privately publishing the post
  36. How to generate slugs?
  37. change a post status when users update posts?
  38. What does wp_update_post() do that the $wpdb class does not?
  39. How can I bulk update all posts without making changes?
  40. Can I edit the wp_post > post_content right before its inserted/updated?
  41. wp_update_post based function works on existing posts, but not new posts
  42. Updating post title using wp_update_post
  43. How do I batch create revisions of all posts?
  44. post_status => publish not working
  45. Change the post date from a meta box
  46. How Can I Set the Post Author of a Post I Just Created With PHP?
  47. Change sticky status of posts from phpMyAdmin
  48. How to show Published date and/or Modified date
  49. Display success message after wp_update_post
  50. How to catch and modify custom field values when a page is updated
  51. wp_insert_post_data filter hook identify current action
  52. custom post scheduler for drafts
  53. Allow Post Author to be 0 on Update
  54. How to get the Tags on Publish post hook?
  55. When User Meta amended update Title and Slug of Post programatically
  56. Updating / Saving items generated by wp_terms_checklist on frontend
  57. wp_update_post not working
  58. Changing random post publish time for repost
  59. Clear cache on post of one type when something happens to post of other type
  60. Updating posts exceeds maximum execution time
  61. wp_update_post is not updating category
  62. wp_update_post deletes post meta in CPT
  63. How to automatic update date and time when save custom post type
  64. Use /prefix/postname as a slug in post_name?
  65. $wpdb->update() always need a second try
  66. Update post if exist from PHP
  67. wp_update_post creating revisions instead of updating the post
  68. How to change post status from “draft” to “publish”?
  69. Is there a before_save_post hook or something similar
  70. Odd behaviour for the update button when displaying a WP_List_Table
  71. Wp_editor doesn’t send the required data
  72. SQL / wp_update_post: change post custom field to CPT post taxonomy
  73. How to use wp_update_post with ajax on frontend
  74. Trash Bin for Categories?
  75. Bulk update published posts date randomly using wp-cli?
  76. remove_action(‘save_post’) in function that was triggered by save post not working
  77. Updating a custom post status after an expiry date rather than trashing it
  78. Update post “A” on comment submition on post “B”
  79. wp_update_post gives 500 internal error
  80. update_post_meta not working with transition_comment_status
  81. update_post_meta not working in template_redirect action
  82. wp_trash_post() duplicates post to trash
  83. Change the term based on the value of a $variable using wp_update_post in submitting a form
  84. Set a post expiration and delete a post when expirate
  85. How to update the children of a post?
  86. Bulk Post update_post_meta
  87. update flamingo_inbound post type after insert
  88. save_post affect creation and deletion
  89. how to update editor content from metabox
  90. Can I override the permalink/slug on creation
  91. Update a Post after a user uploads a video
  92. Comparing pre-saved post_title to post-saved post_title
  93. Change custom post status to draft before today
  94. Setting a featured image while creating the post
  95. Function working in single.php but not working in custom template file
  96. How to create posts with a specific date in bulk
  97. wp_update_post does not change post status from draft to publish, returns 1
  98. How can I use wp_after_insert_post with $current_screen?
  99. Update post / page using API + python
  100. Set post status to draft after validating post meta values in save_post hook

Leave a Comment