Showing results for 
Search instead for 
Did you mean: 

one billion skus

one billion skus

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?


If so, how would I do this?