I want the admin to have an option when adding a product in marketplace such as for example he is adding a shirt.
So he would have option add any number of options and (Combination of options). Each combination can have different price and quantity.
This is like WooCommerce in Wordpress handles variable products.
As of now i have made following tables
products:
id | sku| brand_id | vendor_id | name | image
attributes:
id | name
products_attributes:
id | attribute_id | product_id | attribute_value
By this structure i am able to store multiple attributes for a single product but unable to achieve a combination feature.
Use case : Adding a Shirt having below details
color : black , size: M , price : 10$, stock: 10
color : black , size: L , price : 20$, stock: 5
Thanks