wp_update_post() is a PHP function, and you can’t trigger a page update with MySQL. You need to at least use PHP, but it’s possible that some plugins actually require manually pressing update.
For WordPress and WooCommerce content your best bet would be to use the REST API or WP CLI from the command line.
Related Posts:
- wp_update_post() example… how to update the_content in a textarea?
- Why wp_update_post() does not update GUID?
- What are the limitations of wp_update_post()?
- I need to bulk update all wordpress posts on a scheduled time
- wp_update_post does not update post_name
- How to disable saving/changing update date for certain admin users?
- “Internal Server Error” with wp_update_post
- wp_update_post using post_name
- how to get last revision id created after wp_update_post
- why wp_update_post cant update when value is empty?
- update a post with wp_update_post
- Updating posts not working
- Update a post’s info when clicking on a javascript button
- What ‘function’ will ‘update’ a post?
- wp_update_post meta causing 500 error
- Updating post_parent by id (many times)
- wp_update_post making my post sticky
- Update post meta is slow while saving post
- Update post (published) date when changing category
- recursively update content
- wp_update_post ignores if/else
- $wpdb->update query incrementing value on it’s own!
- Update button (sometimes) greyed-out
- Set a post to draft once depending on a post meta value (passed certain date)?
- wp_update_post behaves differently for different user role
- Fatal error: Call to undefined function wp_cache_get after update attempt
- wordpress function to change post status [duplicate]
- Connection lost. Saving has been disabled… (Updating Posts/Pages)
- Why doesn’t wp_update_post() update the post_status field?
- Automatically fill custom field value on post publish/update
- Custom function to rearrange attachments when creating posts – Almost there
- Fill post titles from post content?
- Keeping post_date same as the pending post_date on privately publishing the post
- Endless loop with wp_insert_post and wp_update_post
- How to generate slugs?
- What does wp_update_post() do that the $wpdb class does not?
- How can I bulk update all posts without making changes?
- Can I edit the wp_post > post_content right before its inserted/updated?
- wp_update_post based function works on existing posts, but not new posts
- Updating post title using wp_update_post
- How do I batch create revisions of all posts?
- post_status => publish not working
- Change the post date from a meta box
- How Can I Set the Post Author of a Post I Just Created With PHP?
- Change sticky status of posts from phpMyAdmin
- How to show Published date and/or Modified date
- Display success message after wp_update_post
- How to catch and modify custom field values when a page is updated
- wp_insert_post_data filter hook identify current action
- custom post scheduler for drafts
- Allow Post Author to be 0 on Update
- How to get the Tags on Publish post hook?
- When User Meta amended update Title and Slug of Post programatically
- Updating / Saving items generated by wp_terms_checklist on frontend
- Changing random post publish time for repost
- Clear cache on post of one type when something happens to post of other type
- Updating posts exceeds maximum execution time
- wp_update_post is not updating category
- wp_update_post deletes post meta in CPT
- How to automatic update date and time when save custom post type
- Use /prefix/postname as a slug in post_name?
- $wpdb->update() always need a second try
- Update post if exist from PHP
- wp_update_post creating revisions instead of updating the post
- How to change post status from “draft” to “publish”?
- Is there a before_save_post hook or something similar
- Odd behaviour for the update button when displaying a WP_List_Table
- Wp_editor doesn’t send the required data
- SQL / wp_update_post: change post custom field to CPT post taxonomy
- How to use wp_update_post with ajax on frontend
- Trash Bin for Categories?
- remove_action(‘save_post’) in function that was triggered by save post not working
- Updating a custom post status after an expiry date rather than trashing it
- Cannot update newly added User field using wp_update_user
- Update post “A” on comment submition on post “B”
- wp_update_post gives 500 internal error
- update_post_meta not working with transition_comment_status
- update_post_meta not working in template_redirect action
- wp_trash_post() duplicates post to trash
- Change the term based on the value of a $variable using wp_update_post in submitting a form
- Set a post expiration and delete a post when expirate
- Update all WordPress posts’s title and content then display them in a table
- How to update the children of a post?
- Post meta data not showing in frontend, until hitting ‘update’ button
- Bulk Post update_post_meta
- save_post affect creation and deletion
- how to update editor content from metabox
- Can I override the permalink/slug on creation
- Custom Post save causes 500 error
- Update a Post after a user uploads a video
- Comparing pre-saved post_title to post-saved post_title
- Setting a featured image while creating the post
- Function working in single.php but not working in custom template file
- Update user from external script
- wp_update_post does not change post status from draft to publish, returns 1
- How can I use wp_after_insert_post with $current_screen?
- Suitable hook when creating, updating and deleting posts programmatically
- Taxonomy Child Not Updating Unless I Click Update Twice
- How to Auto Update WordPress Post after specific time?
- Bulk post approval and publishing doesn’t work