How to store links to the same products of different colors?

Question

PHP

There is an online shoe store. In the admin panel, you need to implement a combination of products that differ only in color and offer to see other colors of the product on the site. Here is an example.

How is it best to store such a relationship of goods in the database?

Answer 1

In this case, variability can be implemented by a parent-link, each new color is a separate record in the table in the parent_id field of which the identifier of the parent product is shown. This is the easiest option. There are other options where you can create tables with product attributes and a table of attributes and product links.