Filter ‘In stock’ shows ‘out of stock’ products

Hey there,

Thanks for starting a new thread and all of the cross-linking!

All my products only have one variation: delivery-time, where buyers can select a half-hour time block (1 out of 4) for delivery. Stock and price are being set for ‘every delivery’ time. The products shown on the image were set to out of stock.

WooCommerce and variations can show some unexpected results in terms of filtering by stock, because of how variations work – for example, if some variations are out of stock, and others aren’t, should the main variable product be shown as in or out of stock? It sounds like you’re working with a bookings-type plugin, which could further be muddying the waters.

I did some testing with the following setup:

1. Create a variable product
2. Create an attribute and add one term (color -> purple)
3. Set up the variation with a price and set it to out of stock
4. Check the Products screen > variable product showing as out of stock

Link to image: https://cld.wthms.co/EqCdW5

5. Set filter to out of stock > product shows up
6. Set filter to in stock > product does not show up

I’m not able to reproduce the same behavior on my end, which makes me wonder- what happens if you set up a similar product – does it work correctly on your site? If so, that points to a problem with how those specific time booking products are working.

Can you please give it a try and let me know how it goes?

The only thing I can come up with is that all those displayed (out of stock) products were set from ‘in stock’ to ‘out of stock’ in updated database 3.6.1. while running on WC 3.5.8.

It’s possible, but I believe what I’ve asked about above is more likely in this case.

Hello @fernashes,

Thank you for your reply. I have set up a simular product and that works fine => https://1drv.ms/f/s!AoBAVIWWn-_ngQyt96l2UWzzck5X
The other ‘out of stock products’ are still showing when filtering on ‘out of stock’. I will try to discover if there is a problem with how those specific time booking products are working. It must be in those specific (shown) products, because all other products work in the same way and there is no problem with the other products when filtering.
I also tried re-updating the database (it is now scheduled running on background).
To be continued.

Hi Hannah / @fernashes

It seems I have worked it out. I have set all the ‘out of stock’ products that were shown after filtering on ‘in stock’ to ‘in stock’, saved them and set them back to ‘out of stock’. That worked like a charm. It did not matter if I did reset the stock status through quick edit or in the product it self. There were also a few ‘in stock’ products that were only showing after filtering on ‘out of stock’. For those products it also worked resetting stock status.

Now filtering on ‘in stock’ all current in stock products are being presented => https://1drv.ms/u/s!AoBAVIWWn-_ngRAnNrad0xMmFGAe

Thanks for your help

• This reply was modified 5 years, 10 months ago by EdwinWerner.