Magento – Products out of stock with inventory

backendinventorystock

My inventory is updated frequently via webservices/cron. My issue is that if a product goes "out of stock", the check box remains "out of stock" even when new inventory is showing up. For example, a product had a quantity of 0 for a couple of weeks so the "out of stock" box was checked at the backend automatically. Now the stock levels have updated to 300 and the product will not automatically display at the front without me needing to manually uncheck the "out of stock" box at the back. With thousands of products in my catalogue and stock levels constantly updating, it's not practical for me to do this. Can anyone tell me how to have Magento automatically display an item as "in stock" when the inventory is above 1?
Thanks in advance

Best Answer

This is actually a feature of Magento. This allows you to set a product "out of stock" (if you have reasons to) independent from the product qty. The simplest solution would be to modify the cron that sets the product quantities to set the 'is_in_stock' flag on the inventory item to 1 it the qty is 1 or above. Maybe you should post some code from your cron and we can help you change it to fit your needs.

Related Solutions

Magento – Magento Low Stock RSS has stopped refreshing

I don't see a reason for this. The block has a cache time out of 10 minutes, after these 10min you should get a new copy.

You should log the queries this block creates and make sure what they produce as output.

You can try to comment $this->setCacheLifetime(600); to get a fresh copy every time.

Stock Management – Fix QTY at 0 Doesn’t Change Product to Out of Stock

I confirmed that the issue was in fact that some fields were not being updated that needed to be. These fields ended up being qty and stock_status in the table cataloginventory_stock_status. I found a couple ways to fix this. You can update each item in the script using the assign function that the Mage_CatalogInventory_Model_Stock_Status has. Simply place it in the if ( $product ) loop.

The other way is to use the rebuild function that the Mage_CatalogInventory_Model_Stock_Status has. You call this outside the if loop and it will rebuild all the stock statuses on the site based on their newly updated qty. This is the method I used, and my edit was simply adding this function call after the if loop, right after the fclose line.

fclose($handle);

$stockStatus = Mage::getModel('cataloginventory/stock_status')->rebuild($website_Id);

It increases the script run time by about 30-40%, but the script is still quite quick and now it works fully.

Best Answer

Related Solutions

Magento – Magento Low Stock RSS has stopped refreshing

Stock Management – Fix QTY at 0 Doesn’t Change Product to Out of Stock

Related Topic