How to design "product options" in an online store?

Question

Database design

How to design an online store with a simple list of products - I know. It's done. The fun starts when you now need to add possibly "custom properties" to products. That is, it can be a) color b) size - for example.
Depending on these characteristics and their combinations, the price may differ. The title too. Pictures too. Availability in stock.
How to make it easier and more correct? Just add a ProductCustomProperties child table with a link to Products and move the price, name, etc. into her?
Also! Not all products I have can have CustomProperties. That is, for example, some kind of "Hand Cream" - I always have it with one modification, or without modifications - which is the same thing. How to be here?
What are your tips? Who did this?

Answer 1

You add two tables, one with links of modifier id and product id, another table of modifier id, customPropertyKey, customPropertyValue

Answer 2

EAV
json
In a good way, you should have an understanding that you have a SKU
And then, starting from this knowledge and accounting requirements (accounting and warehouse), design something