Advanced Stock Management

[cikcak]

Hey,

 

I can`t deal with strange thing. I have decided to use advanced stock management. So I add all products to warehouse and going to recount my warehouse.

 

I have created a little script to count how many available orders have product A and set that quantity in ps_stock_available. So for example: product A has -3 quantity (3 active orders with total quantity = 3). (Before this update it was -1).

 

I have made an order with A product. So now quantity: -4. I cancel with order and quantity: -1. Why? What did I forget?

 

I have tried to look all tables in mysql and I can`t figure out where he is saving this value. I found that in order_details table it saves product_quantity_in_stock. Even I change this value it go back to old value. How it is possible? 

 

If im not using advanced stock management - it works good. But with advanced stock and stock depends on warehouse it won`t work correct.

 

BTW: in warehouse this product has zero stock.