Which table is for the product quantities?

[MikeM.]

Hi there,

I have a hard time finding the product amounts in the prestashop.

 

This is the current setting on my products:

 

Use the advanced stack management for this product:  TRUE/CHECKED

 

Use the stack management based on the assigned warehouse: FALSE/UNCHECKED

 

Manually input the stock quantities: TRUE/CHECKED

 

 

I need the following information:

 

In which table

In which table can I find the quantities/amounts of the product combinations

In which table can I find the quantities/amounts of the product by settting it normaly through the "quantities tab"
In which table can I find the name of the product combinations?

Edited February 9, 2015 by MikeM. (see edit history)

[bellini13]

In which table can I find the quantities/amounts of the product combinations

 

ps_product_attribute

 

In which table can I find the quantities/amounts of the product by settting it normaly through the "quantities tab"

 

 

ps_product

 

In which table can I find the name of the product combinations?

 

ps_attribute_lang

[MikeM.]

ps_product_attribute

 

ps_product

 

ps_attribute_lang

I set the quantity of product id 148 to 1000

 

checking the database, it's neither in one of these tables.

 

PS_Product:

 

PS_Product_Attribute [correct because there are no available combinations on this product]:

 

PS_Stock:

 

 

 

the rest is unnecessary to show.

 

 

 

I found it in:

 

PS_STOCK_AVAILABLE

 

A message to prestashop.

please do not save things tons of times...

 

 

seems like I had it bugged a few days ago, and now it works.

 

althrough I am still not happy with prestashop, even the source is like "what the heck is this?" as a php scripter myself...

Edited February 9, 2015 by MikeM. (see edit history)

[reno123]

I had exactly the same case...

 

It wouldn't be so difficult to find if "PS" could have readable database schema -> this PDF in Development Section is completly unusefull .....