woocommerce products display weird after bulk edits

Hey there Hannah,

Thanks for the help.

I tried as you suggested and that didn’t work.

I went to the link and added a product as described and that didn’t work.

I tried deactivating all my plugins, and that didn’t work. I use no cache plugins.

I went in to customize and set number of products across and number of rows up 1 to 4 across and 5 rows and it still displays wrong, showing me 17 products instead of 20(4 products x 5 rows) but thinks there are 20 per the Showing 1–20 of 29 results at the top of the page, so I feel like there is a cache out there I need to clear but still can’t find it.

After further investigation if you go to Woocommerce > Products > Inventory and if you check the box for Out of stock visibility to Hide out of stock items from the catalog, it appears that it still thinks that it is showing out of stock product with the product count at the top of the page and the number it think are on each page. They are removed though. Same behavior in different browsers so I know it’s not a crazy browser cache thing.

Any ideas?

Thanks. E

• This reply was modified 2 years, 11 months ago by theanciento.

Hey Hannah,

Nothing seemed to fix this, and going back a few database backups this has been an issue for me for awhile. I got this from Github and it fixed it.

https://github.com/woocommerce/woocommerce/issues/22506

add_action(‘woocommerce_product_query’, ‘show_only_instock_products’);

function show_only_instock_products($query) {
$meta_query = $query->get( ‘meta_query’ );
$meta_query[] = array(
‘key’ => ‘_stock_status’,
‘compare’ => ‘=’,
‘value’ => ‘instock’
);
$query->set( ‘meta_query’, $meta_query );
}`

Thanks again for all your help. E