Real Quantity problem ?

[Ray UK]

Hi all,

 

I have a problem In the back end of our store.

 

The Real quantity is showing as 200, but physical and usable are 0

I cannot remove any of the 200 because it just brings up an error

 

(

[PrestaShopException]

 

Property Stock->physical_quantity is not valid

at line 837 in file classes/ObjectModel.php

 

831.

832. $message = $this->validateField($field, $this->$field);

833. if ($message !== true)

834. {

835. if ($die)

836. throw new PrestaShopException($message);

837. return $error_return ? $message : false;

838. }

839. }

840.

841. return true;

 

 

See attached piccie.

 

The problem is that we are out of stock of this item, and it is still showing as available because of this 200 qty :/

 

Im on PS 1.5.4

 

( I think at one point I was setting up another warehouse, and may have added stock to that ? But deleted that warehouse.. could this be a cause and how can I now remove the stock )

 

Any help is appreciated.

 

Thanks

 

Ray

Edited August 1, 2013 by MerseyRay (see edit history)

[vekia]

try to change the value of the stock in the database (ps_stock_available)

search for field related to the product id, if it is duplicated - remove one of them and then set correct stock value