Probably your already solved this (hopefully not by hand).
This part of your question is intriguing:
I found that if I open a post through WordPress front-end and then click “update” the custom field data and the post content “sync”
Do you mean back-end, right?
If so, I think a bulk update would solve this problem.
In wp-admin/edit.php
- increase the number of post shown (Screen options)
- select all
Bulk actions -> Edit- “change” some parameter, e.g. mark the same Author, o same Ping, or insert a temp tag you’ll delete later
Maybe, before increasing the number of posts shown, do a little test to see if it works.
Related Posts:
- How to update custom fields using the wp_insert_post() function?
- Change slug with custom field
- Better post meta efficiency?
- Change post format using custom field
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- What Is meta_id In wp_postmeta?
- Add custom field automatically (add_post_meta) with value based on number of words of article
- Duplicating Table of Contents for Paginated Post
- How can I sort posts by the date and a custom meta field?
- How to display Common posts from specific Tag & Category with Shortcode
- Cannot retrieve a custom RSS field from posts
- Redirect to another page using contact form 7? [closed]
- Customize rel=canonical tag for single blog post
- How to I retrieve the ID from the Posts page?
- Get post meta retrieving wrong value
- if in category but only with post meta
- Saving Post Data in Another Database
- Add multiple meta keys to a post at once
- saving/reading custom field value does not work – no value gets POSTed
- How To Use Custom Fields With .mp3 Links
- Post meta not working
- get_post_meta shortcode returns empty field
- How do you update post date (year only) in a separate custom field?
- When working with a post, almost all wp_postmeta are deleted
- WP_Query sort by meta_value_num or date
- Creating Ordered Query using Meta_key
- Using Post ID and Page ID in same function
- How can I create a menu items from meta box based on users input
- Display a custom field rating system in the front end
- get value from post to sidebar
- How enter custom post meta or custom field on box post list archive page?
- Display a post by ID attribute with shortcode
- Global $post not working in OOP function WordPress
- How can I get a post field value using javascript?
- Automatic value for custom fields for posts
- How to generate numbers indistinguishable for the IDs of the posts
- UberMenu list current user’s posts as menu items
- Modify WP_Post before processing
- Use WP_Query in shortcode
- Understanding and using metaboxes in posts
- Save re-arranged draggable post items to wordpress database
- Accessing post->ID outside of the loop for listing child pages
- I would like to give special promotion for the first 100 posts in my blog? Can anyone tell me how to do that?
- how to set beforsend option in wordpress ajax methods
- Change post_date to post_modified date on post template?
- Query how many items to show in shortcode
- Converting a dynamic piece of code using WordPress Loop into a static one using Post ID
- How can I create a list of page titles from custom meta values?
- Guest Author – How to display posts on /author/ archive page
- Display post category in foreach loop with category link
- do_shortcode within post query
- WordPress Custom Fields (Checkboxes with multiple values)
- WP_Query orderby not working with meta_value_num and menu_order
- Why WP_Query(‘showposts=5’) shows only 1 post?
- is there a way to show the the post title after the image?
- Get Meta Key Value While Saving Post
- Most liked page not displaying posts
- How to get rid of shortcodes in post content once and for all
- get_the_content(“more…”) returns full text
- How to make number of blog posts a custom field?
- Is there a straight-forward way to iterate over all shortcodes in a post?
- How can i display gallery shortcode output under Post text
- Assign / update custom field value for all posts (How can I assign only to posts without custom field value?)
- How do I correctly set up a WP-Query to only show upcoming event-posts?
- Update Post Meta for a logged in user
- Store multiple custom field as post meta per post(css, js, html, 2 link) [closed]
- How to VAR_DUMP a $variable during checkout process (Is my product meta callable?)
- Two Custom Post Types Many to Many Relationship
- get_post_meta not working on publishing
- How can I add extra word in permalink when someone click download button?
- Force the “Choose from the most used tags” meta box section to always be expanded
- Automatically add custom fields value to wordpress post
- Meta value does not save for scheduled posts
- Custom Posts Query and meta_query Sort Order
- Is there a way to notify specific users when new posts are published to specific pages?
- How to create a shortcode to print specific values stored in a post meta array?
- Run Shortcode of post’s custom field in functions.php / Plugin
- What’s the best way to render Visual Composer in posts, not pages?
- MySql query to get posts with all meta and terms
- How to compare two posts including their meta fields on a scalable base?
- Categories list into registration form
- display-posts shortcode attributes have no effect
- Shortcode and whitespace formatting problem
- Getting value from get_post_custom
- Add a custom meta box in the post options that loads some html code in the header
- Calling Different Custom Post Timestamps in a table
- Creating a post from data returned from HTML form
- Is it possible to paste a link without tags and make it directly a link in a post?
- Query Posts With Over 1000 Views
- List authors with the last post title and order by last post date
- Saving custom fields to a custom taxonomy
- Hooking into the post editing screen for an existing page only
- Query Posts by Custom Field
- Shortcode to display the latest news article within a page
- Display post category in foreach loop
- How to automate featured posts number? [duplicate]
- Which PHP page is the Default Posts Page
- Shortcodes on my website stops working after theme update [closed]
- Is it possible to retrieve all posts with a certain value for metadata?
- shortcode in a custom metabox