We want to use manufacturers product numbers for our products, and assign them a location in the warehouse. The problem we have is that the manufacturers product is purchased from multiple suppliers depending on the price available. We need to be able to allow for multiple suppliers to be listed under each product to streamline stock levels, purchasing and purchase orders.
I can't believe that this isn't already a thing, currently we don't have an easy work around as all the products we purchase are used as components in our finished product.