Deleting View Count Post Meta

Resolved fippy
(@dgilfillan)

5 years, 9 months ago
Hi, I’ve successfully implemented sorting a custom query by views by storing the view counts for different time frames, for each post, as a meta keys… as you outlined in:

https://ww.wp.xz.cn/support/topic/how-to-sort-a-custom-query-by-views-all-time-monthly-weekly-or-daily/

The trouble I’m having is that clearing the cache in WPP does not remove/clear the values in the meta keys.

Can you advise how to clear them at the same time, so I can reset all counts to zero.

Thanks in advance
- This topic was modified 5 years, 9 months ago by fippy.
The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author Hector Cabrera
(@hcabrera)

5 years, 9 months ago

Hi @dgilfillan,

For this you’ll need to either update each meta field value directly in the database (which might be a lot of manual work if you have a lot of posts) or you could do this programmatically and save yourself some time: Assign/update the custom field value for all posts.
Thread Starter fippy
(@dgilfillan)

5 years, 9 months ago
Hi Hector,

thanks, I think I’ve managed it following the advice you gave… I created a snipped that ran ONLY ONCE with the following:
```
function update_my_metadata(){
    $args = array(
        'post_type' => 'post', // Only get the posts
        'post_status' => 'publish', // Only the posts that are published
        'posts_per_page'   => -1 // Get every post
    );
    $posts = get_posts($args);
    foreach ( $posts as $post ) {
        // Run a loop and update every meta data
	update_post_meta( $post->ID, 'views_total', '1' );
	update_post_meta( $post->ID, 'views_daily', '1' );
	update_post_meta( $post->ID, 'views_weekly', '1' );
        update_post_meta( $post->ID, 'views_monthly', '1' );
    }
}
// Hook into init action and run our function
add_action('init','update_my_metadata');
```
- This reply was modified 5 years, 9 months ago by fippy.
Plugin Author Hector Cabrera
(@hcabrera)

5 years, 9 months ago

Awesome, thanks for the update. Make sure to remove that code from your site when you’re done though, otherwise your post meta will be reset every time someone views a page on your website (you can also just comment out the add_action(...) line if you wish to use the code again in the future.)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Deleting View Count Post Meta’ is closed to new replies.

Tags