I am in the process of creating a site that accommodates multiple sellers (multi-vendor). Sellers can perform Crud on their products. My query concerns methods of data separation for sellers. Which methods are available to ensure sellers can only interact with products they have created.
A couple of ideas I had:
- Add a seller ID against product in product table
- Create separate product table for every seller
Apart from the above two any further suggestions and wondering how this is usually solved?