This plugin will allow you to easily repair and fix your category count for posts, pages and custom post types
You may fix specific or all post type categories that you believe are incorrect.
It is always recommended that you have a backup of your database.
Possible Upcoming Features
Show a report after completion of tables updated
If you like, or hate this plugin, please rate it on WordPress. If you are having any issues with it, please leave a comment on the plugin page.
To install this plugin, either upload the entire directory to your wp-content/plugins/ directory, upload the zip file in your admin plugins screen. You may also install the plugin through wordpress.org
Activate the plugin through the ‘Plugins’ menu in WordPress
The plugin may be found in the admin menu under Tools
I have a site with about 30,000 posts and the custom taxonomy count was off. After running this plugin a few times the taxonomy count actually got worse. I had to run it a few times because it timed out.
Not worry, though. I used the following SQL to fix the problem and it ran very quickly.
9300 rows affected. (Query took 2.9573 seconds.)
UPDATE wp_term_taxonomy SET count = (
SELECT COUNT(*) FROM wp_term_relationships rel
LEFT JOIN wp_posts po ON (po.ID = rel.object_id)
rel.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
wp_term_taxonomy.taxonomy NOT IN ('link_category')
po.post_status IN ('publish', 'future')
The number of posts associated with a category may get mixed up (mine is due to the daily import and deletion of the posts with wp all import plugin) and this plugin can correct this error to the actual number of posts. It also works with custom post types. My suggestion would be the addition of wp cron functionality so it can fix the category counts automatically once in a while to ensure all the categories are up to date.