Hi,
Mmm. I'm not sure that everyone is talking about the same thing here.
If you want a link to a product page, you can directly enter the HTML of a A tag wherever you want with the href attribute containing the URL of the product in that way:
mywebsite.com/index.php?option=com_hikas...=show&product_id=XXX
You can have the text you want in your A tag.
Regarding the possibility of changing the product name of the link generated by the HikaShop tag system to something else stored in a custom product field of the product, it's actually quite easy to do.
First, copy the file plugins/system/hikashopproductinsert/hikashopproductinsert_view.php to templates/YOUR_TEMPLATE/system/hikashopproductinsert_view.php and edit that copy and change the line:
echo $product->product_name;
to:
echo $product->FIELD;
where FIELD is the column name of the custom field. That's it. You'll now be able to create links to the product page with the text of the link coming from a custom field of the product.