Magento – Out of stock item not changing even the quantity is greater the 0

ce-1.9.0.1statusstock

I have version 1.9 loaded the problem is, I update the stock via csv file. When the item goes 0 it change to "out of stock" but when the quantity increase greater then 0 it doesn't change back to "in stock". It still says quantity 29 "out of stock" and all out of stock items do not show on our front end. so I am losing customers on item which I actually have in stock.
I have over 50000 items so can not change everything manually.

Any idea how can I resolve this issue please? Magento should change the status automatically when quantity become greater than 0.

Best Answer

You have to change the status for each product.

The good thing is that it has been done before:

How to set a product to be in/out of stock programatically

You have to loop through your products and apply the snippet in the above link.

Related Solutions

Magento – Products out of stock with inventory

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.

Magento 1.8 – Stock Quantity Not Increasing After Cancellation

You can try below code for cancelling an order.

$orderModel = Mage::getModel('sales/order');
$orderModel->load($orderId);
if(!$orderModel->canCancel()) {
$orderModel->cancel();
$orderModel->setState(Mage_Sales_Model_Order::STATE_CANCELED, true)->save();
$orderModel->save();
}

In your code, actual code is missing for cancel the order, you had never called cancel() function of class Mage_Sales_Model_Order

Best Answer

Related Solutions

Magento – Products out of stock with inventory

Magento 1.8 – Stock Quantity Not Increasing After Cancellation

Related Topic