Do you think they have a master database of products?
Then an inventory table that vendors are inserting their products into? This table has a key referencing the product from the master catalogue?
So me, as a consumer, I’m searching through the master database of products. I see my search results. I click a result and on the product detail page I see the product details and a list of vendors who have it (which is a query to the inventory table using the masterProductKey)?
# MasterProductTable id: ID title: String description: String
# InventoryTable id: ID title: String description: String vendorId: ID masterProductId: ID