Reset page/post views

[stefanpieter]

Hello :-)

When copying a page or post to create a new design it also copies over the page views from the original post/page. How do you reset the view count for a page/post?

Thank you for the great work.

[lesterchan]

Just update the "views" post meta of that post to 0.

[stefanpieter]

Just update the "views" post meta of that post to 0.

How is this done in the WordPress admin panel? Apologies if I am missing something.

[lesterchan]

https://designmodo.com/wordpress-post-meta/

[TuringTux]

When you have access to the underlying database (e.g. by installing the Adminer plugin), you can execute the following query to reset:

start transaction;
delete from wp_postmeta where meta_key = 'views';

This will start a transaction to delete all the view data. It isn't gone yet, so if you change your mind, you can just execute rollback;. If you are sure you want to delete the data, execute commit;.

---

Btw: If you want to get a table containing the view data for each post, page and file, you can use:

select p.ID, p.post_title, cast(m.meta_value as signed integer)
as view_cnt, p.guid as url, p.post_type
from wp_postmeta m, wp_posts p
where m.meta_key = 'views'
      and m.post_id = p.ID
order by view_cnt desc;