Which tables are used to calculate stock based on product attributes

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 年 前
Hi,

Im building a custom report in Sql. Can someone please tell me where i can find the stock quantity of my products (or in which tables )when i use product attribute combinations (size).

Best Regards,
Jaco Steketee
7 年 前
Hello,

You can find the Stock Quantity of a product's product attribute combination in the ProductAttributeCombination table in the column "StockQuantity".
The "ProductId" column holds the id of the product to which the product attribute combination is related.

Hope this information was useful!

Regards,
Anton
7 年 前
GREAT!!! Thank you very much!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.