Creatin Products Database with Multiple Color Variations


I found this Q&A already, that describes my problem and a more or less satisfying answer: Create products with color variants Basically, I want to set up a database for products with different color variations. Here the solution is given of setting up a product-table, a color-table, and a product-color-table as a combination of both.

Unfortunately, most of my products are available in ~180 different colors and we have about 8000 different articles. Additionally, every product has at least one standard color (up to ~5 standard colors) out of the 180 colors in which the product is cheaper than in other colors.

Do I really have to set up a database as described before, which would lead to over 1 Mil articles, or is there another way? I thought of setting up a product-color-table in the sense, that there are 180 columns for each color and I just assign them values like “available, not-available, standard” or so. And then all the other information that don’t really affect the price of the products in yet another table.

But since I’m new to setting up databases I don’t really how I can realise it. Would that actually work? Can anyone give me any tips on how I can solve that and set up my tables?

Thanks in advance

PS: In case my description was confusing here is an example of an onlineshop I found that has the exact thing I want to do: When you tap on “Ciew colour range” you can see all the different colors. But then there are also other articles that are available in less colors or different standard-colors.