Warehouse inventory by multiple locations

[jdaf_2412]

Good day
I have 4 warehouses with different products, I have created 4 virtual columns (within the products table) to verify their quantities for each warehouse, up to this point everything is perfect.
The problem is that within each warehouse I have different locations (shelves), the same product can be in warehouse 1 distributed in 4 other sub-locations, I have thought about the matter but I have not solved it.
What I would like is that when selecting the product it would show me how much there is for each sub-location.
Add that the sub locations are not fixed and it is necessary to add new ones or that some may be empty momentarily.
Thank you

[TeeSee1]

One way to implement your setting is..

Four tables..

products: p_id, name, etc

warehouses: wh_id, wh_name, etc

shelves: sh_id, sh_name, wh_id (ref), etc.

inventory: i_id, p_id (ref), sh_id (ref), qty , VC to get wh  ...  you probably want something to prevent duplicate records ( no duplicate combination of product and shelf)

With this setup you can have a view like this

If you are not familiar with table design you can start by reading this

https://support.google.com/appsheet/answer/10106580?hl=en&ref_topic=11918148