Translations not working on product pages

Hi,

Sorry, we had miseed your thread.

From what I can see, it's probably an issue with the canonical URL.
If you set a canonical URL in the main product information, but not for each language, and you have the "force canonical URLs on listings", then the canonical URL will be used for all the languages and thus, based on the language tag in the URL it will switch to the language of the canonical URL when displaying the page.

So either:
- configure the canonical URL for each language of each product
- turn off the "force canonical URLs on listings" setting in the HikaShop configuration. This won't be a problem for your SEO as the canonical URL will still be the only one referenced by search engines, regardless of the URL used to access the product page.

Hi,

The translations are stored in the file administrator/language/overrides/en-GB.override.ini or language/overrides/en-GB.override.ini on your website.
A mass action "update the values" can only target the columns in the database. So you can use that action, like you did for the product_canonical column.

Generating dynamically the canonical URLs in the translation override file can be done with a PHP script, however, it's not simple. It will require a couple dozen of lines of code to do this at the very least.

Did you try first turning off the "force canonical URLs on listings" setting ? Does it fixes the problem ?
Do you need that setting to be turned on ? For what reason ?