I have product table and produk variant
But I want that product variant has other options again
This is my product,
I have a custom cloth that has types of collars , cuff, pocket, plackets, fabric
But that collars and those parts have somes type again, it is called contrast and piping
And then the contrast and piping should choose which fabric they want
Currently I was thinking about the
Collar is a product and has variant contrast and piping
And then when user choose fabric of contrast and piping I get data of product fabric
Here is my design
Product:
- id
- name
- category ( item or custom )
- price
Product Variant:
- id
- product is
- name
- price
How I can belongs the fabric I to the product variant correctly? Because each fabric has own price for the product collars, placket, pocket
I was thinking about to count them easier in query for tracking the top product of collar, pocket, cuff for product category custom