You would normally have to save the Quantity on hand of your product at the present time. You should put all your product info in one table, put there anything you think is related to it, ie Price, Location (Default - if you have multiple location), supplier, etc.