Technical Guidance Request for 3 Critical Optimizations on Woodmart Theme

Hello Woodmart Support Team,

We are actively using the Woodmart theme on our WooCommerce store which currently has over 40,000 products. Recently, we have been experiencing serious performance issues, especially on:

– Product search results
– Shop page pagination

Since we are using your theme, we would kindly like to request your technical guidance or direct implementation support regarding the following 3 critical optimization points, which we believe directly affect performance:

1. MySQL FULLTEXT Search Optimization

Default WooCommerce search is extremely slow on large databases.

– Is Woodmart fully compatible with MySQL FULLTEXT-based search?
– Is it safe to apply FULLTEXT indexing at the database level while using Woodmart?
– Should this be implemented by us with your instructions, or directly by your team?

2. Disabling “Product Result Count” on the Shop Page

(“Showing X–Y of Z results” section)

– We detected that this section generates heavy COUNT SQL queries.
– Is there a safe Woodmart setting to disable this without custom code?
– If disabled via code, could this cause theme update or compatibility issues?

3. Reducing Stock Status Meta Query Load

WooCommerce performs frequent _stock_status meta queries which cause heavy load on large databases.

Does Woodmart add or customize these stock-related queries?
Is it safe to optimize or limit these queries on shop and category pages?
In which scenarios could this optimization create risks?

Our Request:
Since we are using the Woodmart theme, for these 3 specific topics, we kindly request:

– Either direct implementation by your team,
– Or step-by-step safe technical guidance so we can apply them correctly on our side.

Best regards,

Hello,

I will do my best to answer all the questions one by one:

1. MySQL FULLTEXT Search Optimization
Our theme doesn’t perform search queries directly to the database. They are made by WooCommerce and WordPress core functions. So these questions are not directly related to our theme.

2. Disabling “Product Result Count” on the Shop Page

This option also is a part of the WooCommerce plugin. And yes, you are free to disable it completely or use our custom layouts to control all the elements on your product archive pages https://xtemos.com/docs-cat/woocommerce-layouts-builder/?theme=woodmart

3. Reducing Stock Status Meta Query Load

Could you please specify the query in question? The _stock_status meta might be used in various places.

Kind Regards

Hello Woodmart Support Team,

On our WooCommerce website, we have already disabled the product result count display on shop and category pages.
However, during our performance analysis, we detected that the following method is still actively running and generating queries:

XTS\Modules\Product_Category_Filter_Walker->get_filtered_product_cat_counts

We observed that:

– This method still generates product count queries,
– And it creates significant database load on our 40,000+ product store.

We would kindly appreciate your technical clarification and guidance on the following points:

Our Questions:

1. Is it expected Woodmart behavior that this method continues running even when the product count display is disabled?

2. Is this method triggered by:

– AJAX filters,
– Category filter walker logic,
– Or another Woodmart module?

3. Is it possible to:

– Completely disable this method, or
– Optimize it so that it runs only when absolutely necessary?

4. If it can be safely disabled:

– Do you provide an official setting or filter hook for this?
– Will disabling it cause any compatibility issues with future theme updates?

Our Goal:
If product counts are not displayed on the frontend, we want to ensure that these heavy queries do not run at all on the backend, in order to reduce database load.

Since we are using the Woodmart theme, your theme-level technical guidance on this matter is extremely important for us.

Thank you very much in advance for your support.

Best regards,

Hello,

The method get_filtered_product_cat_counts is part of our theme’s categories filter widget. It’s essential for calculating the number of products in each category based on the selected filters. If you remove this method, you won’t be able to display the number of products for that category, and you won’t be able to hide categories with zero products. If you need help removing it, we can provide instructions.

Kind Regards

Yes, we want to remove it. However, we still want the filter to continue hiding categories with zero products.

After all, in the search results, only the categories that belong to the matching products are shown. Therefore, we believe that categories with zero products will already not appear.

It’s impossible to hide categories with zero products, and therefore, the actual calculation cannot be performed. How can we determine which category on the page needs to be hidden if we don’t know how many products are currently displayed from each category?

You are right, let’s disable the calculation completely. We will manage the hiding of empty categories ourselves.

In the child theme, you need to create a file that will override the Product_Category_Filter_Walker class.
To do this, place the file class-product-category-filter-walker.php at the following path:

themes/woodmart-child/inc/modules/product-category-filter-walker/class-product-category-filter-walker.php

https://drive.google.com/file/d/1f6kJk4amufABBSOhq1Ej-VYiseOkrWtD/view?usp=drive_link

Then, in functions.php, include this file by adding the following code:

/**
 * Override Product Category Filter Walker class.
 */
if ( ! class_exists( 'XTS\Modules\Product_Category_Filter_Walker' ) ) {
	require_once get_stylesheet_directory() . '/inc/modules/product-category-filter-walker/class-product-category-filter-walker.php';
}

[Author]

Posts