Welcome @FromTheEdge
This does not answer your immediate question. The number of Product Code-Alias pairs and using Advance Rename will resolve that in all likelihood. Answer @PassThePeas and you will get an excellent answer.
If you want to get a sense of the power of Directory Opus, see
Source Menu for Directory Opus 13.