As per my experience, need to set up a relational database structure with Drupal for your project.
The goal is to set up a database with relations between nodes. In your case, it will be a product database. The main essence of this phase is : The relation should hold data as well.
In case of multi-vendor e-commerce store:
Seller/ Sales-channel C --- (Price K)-Product A-(Price X)- Supplier V--City Q
Seller/ Sales Channel D --- (Price L)-Product A-(Price Y)- Supplier W--City R
From this data, a view/ table should be generated which displays all information correct without duplicates.
Please note that, Commerce couldn’t hold data in the relation, Entity Reference ( other reference modules) seem unable to store data as well. Views & Relation alone are insufficient since a view of all products will generate duplicates if relations with their data & end points are to be displayed as well.
So I need to use the following modules:
- Views
- Relation
- EVA
- Views Field View
After enabling the required modules, the three content types can be created which is pretty straight forward. Now the relations have to be created. This will be two relations, not directional, including two content types (product/supplier and product/sales channel). More over those relations need to have extra fields where things like prices, minimum order quantity etc. gets stored.
I am working more than 10 years in Drupal CMS- I am working since Drupal 4. Please allow me few time to have a chat.