How to force update all posts after import

Question

I recently imported large number of custom posts into wordpress. all works fine, except one taxonomy which is imported, but not show at the front end, until i click on every post "update" button. I have 810 posts and this is not a solution...

i think it should be the way to run MYSQL command to force all post update without making any changes. Please help me with command, i searched for plugins and cannot find anything suitable

Thank you

Answer 1

There are 2 ways that you could do this. The first and more difficult is to write a program, the other is to do a bulk update. Why do difficult when easy way will work equally well? and especially as this is a once-off requirement

The easy way:

1. In the admin dashboard, select the view with all posts for your custom type
2. Select all the posts (tick them) - You can see more posts by clicking 'Screen Options' at the top right of the view and increasing the number of items per page
3. Click the down arrow next to 'Bulk Actions' and select edit
4. Press 'Apply' - you will get a screen with a selection of changes you can make
5. Make some change, like add a tag or change author (whatever)
6. Press 'Update'

That should do it.

The 'difficult' way:

In case anyone wants to use the code solution, you can add the code below to the functions.php file in your child theme.

function my_update_posts() {
    //$myposts = get_posts('showposts=-1');//Retrieve the posts you are targeting
    $args = array(
        'post_type' => 'post',
        'numberposts' => -1
    );
    $myposts = get_posts($args);
    foreach ($myposts as $mypost){
        $mypost->post_title = $mypost->post_title.'';
        wp_update_post( $mypost );
    }
}
add_action( 'wp_loaded', 'my_update_posts' );

Remember to run this only once and then remove it or comment out the add_action line otherwise it will run every time a new page is loaded.

I included this option in case anyone wants a start template for updating all post titles or some other property in all posts.

Answer 2

First: Get all posts using get_posts or WP_Query.

$query_posts = new WP_Query( array(
    'nopaging' => true,
) );

Second: Do loop for posts and use wp_update_post() for each post and set ID parameter.

while ( $query_posts->have_posts() ) :
    $query_posts->the_post();
    wp_update_post( array(
        'ID' => get_the_ID(),
        'post_content' => get_the_content(),
    ) );
endwhile;

Place this code to init action or header/footer. Update page once and remove code. Place this code in functions.php and all your posts will be updated on page reload.

add_action( 'init', function () {
    $query_posts = new WP_Query( array(
        'nopaging' => true,
    ) );

    while ( $query_posts->have_posts() ) :
        $query_posts->the_post();
        wp_update_post( $post );
    endwhile;
    wp_reset_postdata();
} );

Answer 3

For any future interested people: to bulk update posts one by one, you can use chrome extension web scrapper that will automatize clics on update button on every post.