I use nopcommerce to create some kind of "warehouse" - many vendors, many products etc. "MultiVendors" option is really great but also im little bit confused when i use it. For example when i have two vendors and they have same products with same name, same code and same or different price then i must add row for each product for each vendor in product table with the same name but different VendorId.
My idea is create another table to store VendorID and ProductId, and also table to store price or other product attribute, and table to store PriceId and ProducutId. What do you think about this?:)