“In Stock” filter shows products with the selected variation even when that variation is out of stock
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
I’m experiencing an issue with the “In Stock” filter button in the product filter on my WooCommerce store.
The expected behavior is that when a customer selects a specific variation (for example, a size) and then clicks “In Stock”, the filter should display only products where that specific variation is actually available (stock quantity > 0).
However, this is not what happens.
Example:
I have products with size variations (XS, S, M, etc.). Some products have the XS variation defined, but the stock quantity for XS is 0 (out of stock).
When I:
Select the XS size in the filter
Click “In Stock”
the filter still shows all products that simply have the XS variation, even if the XS variation is out of stock.
Expected behavior:
The filter should show only products where the selected variation (e.g., XS) has stock greater than 0.
Current behavior:
The filter shows all products that contain the XS variation, regardless of whether that variation is actually in stock.
Question:
Is there a way to make the “In Stock” filter work based on the stock status of the selected variation, not just on the existence of the variation?
Hello Mark
This feature is already built into the plugin. Please go to WOOF settings → In Stock filter → click the ⚙️ (additional options) button and change "Search in variable products" from "Simple products only" to "Search in products and their variations". Save settings and test again. This will make the In Stock filter check the stock status of each specific variation, not just the parent product.
Screen: https://clip2net.com/s/4nMnWV4
Already tried it, not working unfortunately.
Hello Mark,
Sorry for the confusion. There are actually two things to check in those additional options (⚙️ button):
1. Try switching"Use new DB" → No
This switches from WooCommerce's lookup table to a direct database query, which is more reliable if the lookup table is outdated on your site.
2. If that still doesn't work — regenerate WooCommerce's product lookup table:
Go to WooCommerce → Status → Tools → Regenerate product attributes lookup table and run it. After that switch"Use new DB" back to Yes and test again.
The lookup table is what the"Search in products and their variations" mode relies on — if it's empty or stale, the in-stock variation check simply has no data to work with and falls through silently.