Help understanding stock management

[YiannisK]

Hello and happy new year!

I have an issue. I cannot understand how the stock management works on its backend.

 

I have enabled advanced stock management since my products have color-size.

 

In admin backend everything I see is ok, 

- if the product has 1-Small + 1-Medium the list says quantity 2

- If the product has no stock the list says 0

 

Now the problem comes:

 in mysql ps_product table, the specific product which has quantity in advanced stock management might have zero (0) in quantity row.

and other product which is out of stock, in ps_product table, the quantity row may have 2.

 

I understand that when using advanced stock management, Prestashop does not take into consideration the quantity from ps_product table.

BUT the xml export module which I use, searches from that quantity. So some products that are out of stock are included and some that are in stock are excluded from the xml.

 

I did some test orders to see if the ps_product.quantity is reduced, and in some orders it is, but in other products it isn't. 

 

How is this happening?