I know, i know its crazy, the problem is the colors relay. you see designers have always been allowed to set up there own products so when they are setting up each product the can enter there own flavor of black or they can can get really creative with colors like "Firecracker" or "Valentine".
so there are multiple black, reds, blues etc ontop
the sizes are similar but not as bad but i have seen things like "Up to 6 months" or "5 year old" for childs clothing.
If i group the sizes i can get the 300,000 down to 1000, with the colors 400,00 down to 5000ish but not sure how feasible this would be. Im investigating getting this changed and controlling the color and size creation at our end but this is what ive inherited.
from a knowledge point of view though is it possible to have two or more mini dimension in r.e. my last post?