In one of the implementation, we need to handle one scenario like we have generic products:
- Each product can have multiple brands
- Each product can be purchased from multiple vendors at different price and for multiple brands.
So, 1 brand can be available with multiple vendors and each vendor can sell multiple brands.
One example: Let’s say, we have Mouse as one of our product which is now short in our inventory. So, Mouse can be of any brand like Dell, HP, iball, etc. now, the price for the Mouse from any of these brands can vary based on the vendor from whom we are going to buy. So, may be the same Mouse with same spec is offered by vendor 1 at $60. While the same product is offered by vendor 2 at $55.
So, how can we maintain product, brand, vendor and price together in the system and handle the inventory, warehouse and Purchase Ordering.
Any suggestions would be highly appreciated.
Thanks in advance!