Understanding default stock management (with multi store)

[Sickboards]

Hello I am faced with doggy stock management in 1.5.1

So I am trying to figure out how the stock is stored in the database because it seems messy (at first glance)

 

I am running with the default stock setting, 2 stores and attributes.

 

What I have found:

 

Example product a shoe with multiple sizes:

size | stock

1 | 1

2 | 0

3 | 2

4 | 2

total stock for the product = 5

 

What I see in:

in ps_product_attribute

all quantities for the attributes are set to 5 (I would have expected that this would reflect the actual stock)

 

Further more

in: ps_stock_available

it shows the actual quantities (1,0,2,2) so what is the use of the ps_product_attribute table?

[Raphaël Malié]

Hello,

the quantity field in ps_product_attribute is updated only for retro-compatibility with some old modules.