Products stop displaying in category page only on explicitly saving

Question

I have setup a CRON job for updating the stock in my Magento store regularly.

I have set the Magento configuration as not to show any product with respect to which all the associated products are out of stock. But it is not happening automatically.

The product still shows up on the product page and disappears only when I go to the product page in configuration and save it again explicitly.

Can someone kindly let me know why this is happening and how can I resolve this?

Any Help would be appreciated. Thanks in Advance.

Answer 1

All stock data is indexed in cataloginventory_stock_status_idx table.

Keep in mind, that if you make any changes in your cataloginventory_stock_item it won't work untill you make reindex process which you can initiate from magento backoffice or using for example magerun.

Another option is to regenerate it programatically:

$process = Mage::getModel('index/indexer')->getProcessByCode('cataloginventory_stock');
$process->reindexAll();