Yeah, this was actually a nightmare . We had to create "canonicals", which ended up being a mix of regex, machine learning and good old manual human labor. Fortunately, we could usually rely on the datasheet as the 'source of truth', but even that approach failed when faced with the overwhelming amount of part data we were shifting through.