Out of Stock Items don't appear on Product list

[peggy king]

this has happened to me before, and now again.  No out-of-stock products will display on my products page.  PS returns a total of 2900 products, I probably have more like 3800, but the ones that are out of stock won't display.   I've cleared cache, I've re-indexed, I've tried deleting temp image files via my .ftp site.  I know they are still there because they are there when I open my 3rd party shop manager software. Using 1.6.1.16

Edited December 28, 2017 by peggy king (see edit history)

[tuk66]

I hope you haven't set 'Allow ordering of out-of-stock products' on Preferences > Products. This is the default rule. You can also set if to show every product on the Quantities tab.

You can check all products that have set Deny or Allow orders (not Default) using this SQL query:

 

SELECT DISTINCT id_product FROM `ps_stock_available` WHERE out_of_stock != 2

 

[peggy king]

thank you for taking the time to reply - no, I don't have 'Allow ordering of out-of-stock products' set to "on".  I made no changes in my set up prior to this happening.  My store has been live for several years, and this suddenly happened.  I do remember once before I had a problem with only particular items showing up on the product list page.  It was any with the attribute set to "no".  So I just checked that, and it will return no items that have the status set to no.

p.s. I have no html knowledge.

 

Edited December 28, 2017 by peggy king
add info (see edit history)

[peggy king]

ok, I have no idea what is going on.  I didn't do anything.  But all my listings are now back on my product list!