I have 10,000 products and each product has around 150 different configurations; based on 3 attributes that have 50 options each. The problem is this potentially creates
one billion two hundred fifty million skus!!
I only want to sell one of each possible combination of the three attributes.
I'm no database expert but wouldn't it be better to create a database table which holds the configurations for the products which have been sold for (for which there would be a few thousand) and then only show configuration options which have not been sold already and are listed in the separate database table?