Title: Showing empty categories
Last modified: February 26, 2021

---

# Showing empty categories

 *  Resolved [Ordog](https://wordpress.org/support/users/ordog/)
 * (@ordog)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/showing-empty-categories-3/)
 * Hello,
 * First of all, this is a great plugin and thank you very much for building this.
 * We’ve modified our store to show empty categories by using the below function:
 * `add_filter( 'woocommerce_product_subcategories_hide_empty', '__return_false');`
 * This now works on category pages but it doesn’t show empty categories in the 
   search results. Other categories show just fine, it’s just empty ones that do
   not.
 * Is there a function that I can add to change this in your plugin please?

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

 *  Plugin Author [ILLID](https://wordpress.org/support/users/mihail-barinov/)
 * (@mihail-barinov)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/showing-empty-categories-3/#post-14109889)
 * Hello,
 * Yes, it is possible. Please use following code
 *     ```
       add_filter( 'aws_terms_search_query', 'my_aws_terms_search_query' );
       function my_aws_terms_search_query( $sql ) {
           $sql = str_replace( 'AND count > 0', '', $sql );
           return $sql;
       }
       ```
   
 * You need to add it somewhere outside the plugins folder. For example, inside 
   functions.php file of your theme or use some plugin for adding code snippets.
 * Also after adding this code you will need to go to the plugin settings page and
   click the ‘Clear cache’ button.
 * Regards
 *  Thread Starter [Ordog](https://wordpress.org/support/users/ordog/)
 * (@ordog)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/showing-empty-categories-3/#post-14110651)
 * That’s spot on and works a treat – thank you very much!
 * I’ve just realised that I haven’t reviewed your plugin so I’ll do that now which
   is the least I can do to show my gratitude.
 *  Plugin Author [ILLID](https://wordpress.org/support/users/mihail-barinov/)
 * (@mihail-barinov)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/showing-empty-categories-3/#post-14110842)
 * Glad to help. And thanks for your review.

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

The topic ‘Showing empty categories’ is closed to new replies.

 * ![](https://ps.w.org/advanced-woo-search/assets/icon-256x256.png?rev=3303984)
 * [Advanced Woo Search - Product Search for WooCommerce](https://wordpress.org/plugins/advanced-woo-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-woo-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-woo-search/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-woo-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-woo-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-woo-search/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [ILLID](https://wordpress.org/support/users/mihail-barinov/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/showing-empty-categories-3/#post-14110842)
 * Status: resolved