As the function name suggests, wp_trash_post() only trashes a post. If you want to have a post completely deleted then you can use wp_delete_post( int $postid, bool $force_delete = false ) instead. https://developer.wordpress.org/reference/functions/wp_delete_post/ When the post and page is permanently deleted, everything that is tied to it is deleted also. This includes comments, post meta … Read more
update_post_meta not working in template_redirect action
You have typo error in $post->ID as you don’t have $post variable, and it really could cause you feel that it doesn’t work, at least it will not calculate new value. So here’s modified approach. I’ve also used different hooks to trigger action when it’s really necessary and not for every comment_status transition. /** * … Read more
Try using save_post hook instead. Check this example: https://gist.github.com/fgilio/38dfbf9d03654b21302a
Update post “A” on comment submition on post “B”
Cannot update newly added User field using wp_update_user
Run a function when a custom post is update?
Update post meta is slow while saving post
Updating a custom post status after an expiry date rather than trashing it
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.