Ecommerce Product Variants

I am confused about how to implement Variants for each product. Also note that each variant has its own price.

Size - Small - Price - 200 , Size - Medium - Price - 400

what would be the best way to save this on database?

currently i am thinking about creating one to many relationship of product > Variants.

Variants Table Schema : ID , product_id , size & price

Open to suggestions

Level 15

yeah that´s the way I would do it.

Level 36

no, that's not the right way. Not a variant owns products but the product does.

You have to have multiple tables:

That way you can handle everything and are flexible on the requirements

Level 5

have a look here for some example code. its L4 and old, but probably quite relevant

Please or to participate in this conversation.