Title: Fix Category Count Author: abda53 Published: November 11, 2015 Last modified: January 14, 2026 --- Search plugins ![](https://ps.w.org/fix-category-count/assets/banner-772x250.png?rev=3439373) ![](https://ps.w.org/fix-category-count/assets/icon-256x256.png?rev=3439373) # Fix Category Count By [abda53](https://profiles.wordpress.org/abda53/) [Download](https://downloads.wordpress.org/plugin/fix-category-count.1.2.zip) * [Details](https://pcd.wordpress.org/plugins/fix-category-count/#description) * [Reviews](https://pcd.wordpress.org/plugins/fix-category-count/#reviews) * [Installation](https://pcd.wordpress.org/plugins/fix-category-count/#installation) * [Development](https://pcd.wordpress.org/plugins/fix-category-count/#developers) [Support](https://wordpress.org/support/plugin/fix-category-count/) ## 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 1. 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 2. Activate the plugin through the ‘Plugins’ menu in WordPress 3. 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 ![](https://secure.gravatar.com/avatar/0685eb955e845624ca8bb10cbc86a85c3aa0901de4d01a03f1d36774c3c988b9? s=60&d=retro&r=g) ### 󠀁[Works Perfectly Under WordPress 6.9.1](https://wordpress.org/support/topic/works-perfectly-under-wordpress-6-9-1/)󠁿 [Alan](https://profiles.wordpress.org/alanwhiteman/) February 20, 2026 After deleting thousands of spam posts, including thousands of orphan categories, I used the latest version of Fix Categories Count to reset the number of categories to 0. It worked flawlessly and very fast. ![](https://secure.gravatar.com/avatar/ac7fe548f03560861ff6f3b39f07fdae631a6bbc910ac77f762a9132266f30ca? s=60&d=retro&r=g) ### 󠀁[Broken](https://wordpress.org/support/topic/broken-714/)󠁿 [davemc50](https://profiles.wordpress.org/davemc50/) August 5, 2024 Wordpress 6.x , no longer works, “There has been a critical error on this website” ![](https://secure.gravatar.com/avatar/1f89772fa54e6505e49146173645c4b127f64c058d2517e7846dee6632cbdf6f? s=60&d=retro&r=g) ### 󠀁[Nice!](https://wordpress.org/support/topic/nice-2569/)󠁿 [Gustav](https://profiles.wordpress.org/4ever16/) July 26, 2018 Worked perfect! ![](https://secure.gravatar.com/avatar/4ee59095a3912d8a795e70a84f3bfb290ef14377239eb379b3ce105110e0ef09? s=60&d=retro&r=g) ### 󠀁[Not good for large sites I think](https://wordpress.org/support/topic/not-good-for-large-sites-i-think/)󠁿 [deadhippo](https://profiles.wordpress.org/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 ![](https://secure.gravatar.com/avatar/ffec112efe0fdcce1be61a38e9c793e162534d6ef6ef74a591e57d91e5c838b6? s=60&d=retro&r=g) ### 󠀁[Many thanks!!!](https://wordpress.org/support/topic/many-thanks-30/)󠁿 [trongnghia203](https://profiles.wordpress.org/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… ![](https://secure.gravatar.com/avatar/1ab06d9da4bc968b059a2bed3b0721f6ae3d304644ae4be648b65e83629ad13a? s=60&d=retro&r=g) ### 󠀁[Simple and works like a charm.](https://wordpress.org/support/topic/simple-and-work-like-a-charm/)󠁿 [alburse](https://profiles.wordpress.org/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. [ Read all 9 reviews ](https://wordpress.org/support/plugin/fix-category-count/reviews/) ## Contributors & Developers “Fix Category Count” is open source software. The following people have contributed to this plugin. Contributors * [ abda53 ](https://profiles.wordpress.org/abda53/) [Translate “Fix Category Count” into your language.](https://translate.wordpress.org/projects/wp-plugins/fix-category-count) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/fix-category-count/), check out the [SVN repository](https://plugins.svn.wordpress.org/fix-category-count/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/fix-category-count/) by [RSS](https://plugins.trac.wordpress.org/log/fix-category-count/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 1.2 * This now works on the latest version of WordPress #### 1.1 * Updated for WordPress 5.0+ and PHP 7.4+ * Fixed all SQL injection vulnerabilities using prepared statements * Added proper input sanitization and output escaping * Fixed security issues with nonce verification * Improved code quality and WordPress coding standards compliance * Fixed bug in update_category_correct_count method * Added proper capability checks * Replaced short tags with proper PHP tags * Added text domain for internationalization #### 1.0 * Initial Development ## Meta * Version **1.2** * Last updated **3 months ago** * Active installations **90+** * WordPress version ** 4.7 or higher ** * Tested up to **6.9.4** * PHP version ** 7.0 or higher ** * Language * [English (US)](https://wordpress.org/plugins/fix-category-count/) * Tags * [category](https://pcd.wordpress.org/plugins/tags/category/)[count](https://pcd.wordpress.org/plugins/tags/count/) [fix](https://pcd.wordpress.org/plugins/tags/fix/)[repair](https://pcd.wordpress.org/plugins/tags/repair/) * [Advanced View](https://pcd.wordpress.org/plugins/fix-category-count/advanced/) ## Ratings 4.6 out of 5 stars. * [ 7 5-star reviews ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=5) * [ 1 4-star review ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=3) * [ 1 2-star review ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/fix-category-count/reviews/?filter=1) [Add my review](https://wordpress.org/support/plugin/fix-category-count/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/fix-category-count/reviews/) ## Contributors * [ abda53 ](https://profiles.wordpress.org/abda53/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/fix-category-count/) ## Donate Would you like to support the advancement of this plugin? [ Donate to this plugin ](http://www.amazon.com/gp/registry/wishlist/2IYL0Q1K48ZTM/)