Moving Wordpress Custom Field Value into Default Editor/Excerpt

Question

I am in the process of migrating posts between an old and a new website. ACF was used on the old website and when I import the posts into the new website it creates the custom fields "banner_description" and "main_description".

I would like to do away with these custom fields and have the values from each be put into the default Excerpt and Editor text boxes.

banner_description -> Excerpt

main_descriptoin -> Default WYSIWYG Editor

How would I go about doing this?

Answer 1

Utilize the wp_update_post() function to update the content and excerpt of each post you want. Pull in the ACF data you need with the get_field() ACF function so you can set the content and excerpt accordingly. You can call the update function via the init action.

Note: Recommended to only add and run this init action once and then remove the function so it won't be called every time a page loads.

function update_posts_content_excerpt() {
  $args = array(
    'post_type'      => 'post',
    'posts_per_page' => -1,
    'post_status'    => 'publish'
  );
  $posts_array = get_posts( $args );

  // Loop through those posts 1 by 1
  foreach ($posts_array as $post) {
    $post_id = $post->ID;

    // Get current value of the ACF fields
    $banner_description = get_field("banner_description", $post_id);
    $main_description = get_field("main_description", $post_id);

    // Create array of data to update for the post
    $post_update_data = array(
      'ID'           => $post_id,
      'post_excerpt' => $banner_description,
      'post_content' => $main_description
    );
    // Update the post into the database
    wp_update_post( $post_update_data );
  }
}
add_action('init', 'update_posts_content_excerpt');