Of course it's possible. I made a number of scripts for the purpose. A few of them I posted on my site, for example:
See also the 'Hyperlink' section here.
It's difficult for me to give you a specific advice because you didn't post some screenshots or samples, but I guess each product has a unique code number which can be used for GREP search and making a hyperlink. You may have a data base/excel/etc. file containing the info about the product numbers and their URLs which can be used by script.
Since you have zero knowledge about scripting, I recommend you to hire a scripter who can develop a script, or adjust an existing one for you.
I am not the author of the script: I took it from the forum, or maybe from this site. (This is its author).
The script was tested in CS3 but you're on CC. Something may have changed since then.
Maybe you have something in your layout that prevents the script from working properly.
I google-translated the error message from Spanish:
ya hay otro objeto con ese nombre means There is already another object with that name
I think this happens because you have several hyperlinks with the same name. Removing line 90 is a quick & dirty solution in this situation, but you'll get generic names.
Alternatively you may generate a random number and add it to the name. I used this approach (BTW it's also quick & dirty here). See the screenshot at the very bottom of the page.
You may modify the line 90 like so:
myHyperlinkDestination.name = myURL + "_" + String(Math.random()).replace(/^0\./, "");
which should give you a unique name for each destination.
Last note: I don't have your file so can't test it and tell you what exactly goes wrong; it's only guessing.