Description
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
Please Read
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.
Screenshots
Wrong Category Count 
Fixed Category Count 
Admin view page
Installation
- 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 www.remarpro.com
- Activate the plugin through the ‘Plugins’ menu in WordPress
- The plugin may be found in the admin menu under Tools
FAQ
Why does the category count get messed up?
That is a great question.
Reviews
deadhippo
December 29, 2017
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)
WHERE
rel.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
AND
wp_term_taxonomy.taxonomy NOT IN ('link_category')
AND
po.post_status IN ('publish', 'future')
)
Source: https://stackoverflow.com/questions/18669256/how-to-update-wordpress-taxonomiescategories-tags-count-field-after-bulk-impo
trongnghia203
September 20, 2017
Many thanks, brother. Although I don’t know how comes the wrong number of posts in category… But your plugin is saving my wordpress life…
alburse
April 9, 2017
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.
Marinos
September 3, 2016
Thanks !!!!!
Contributors & Developers
“Fix Category Count” is open source software. The following people have contributed to this plugin.
Contributors
Translate “Fix Category Count” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0
- Initial Development