Product out_of_stock issue

[david.bonntech]

Hey folks,

I noticed that a lot of my products were set to "Deny Orders" when stock availability is 0. I went in to the data base and ran an SQL query to update the out_of_stock column from 0 -> 2 (because 2 is "Default")

 

When I went back to check my products, it had updated this status to "Default" but when I try to add a product to cart it comes up with an error "You already have the maximum amount available"

 

When I manually change to "Allow" then change back to "Default" it allows me to add products to cart.

 

I tried changing the quantities to 9999 with an SQL query and it only updates quantities that don't have attribute combinations.

 

Can someone help me figure out why it's not allowing me to add products to cart?

 

thanks

Edited February 10, 2014 by david.bonntech (see edit history)

[CartExpert.net]

Hi.

 

You need to set the out_of_stock in ps_stock_available also.

 

Regards.

Robin.

The CartExpert Team