Each product from your "Product Database" can be linked to more than one "Stock Item".
Each "Stock Item" can be used to refer to the same stock type/product in different locations, or items you wish to have priced separately.
Whenever you select a product in your application that is linked to more than one "Stock Item", you will be asked to select exactly which "Stock Item" (location, etc) you wish use from your Stock Control system.