Thank you Nicolas,
I forgot to mention that in my import process from the third party DB there is a potential risk that some products share exactly the same name although the "product code" is always unique, so to avoid potential alias conflicts i would like to add the product_code at the end of the alias as a standard rule. Also, many users / clients will identify first the product by its reference (product_code) than by its name, so in my opinion this is not breaking the SEF logic as many people will search at google by product code.
Do you see any inconvenience in this practice?
How can we add this in a stable way in our system so it does not reset for each hikashop update?
Thank you.