Mass action to update products' canonical url

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5

Hi,
I'd like to create a mass action to update products' canonical url to something like /en/category/subcategory/item/product_alias, where product_alias is the alias of the product being updated.
Is there any way to use some kind of variable containing product_alias when modifying canonical url?

Thank you very much
Kind regards

Hi,

There is no concatenation feature for now for mass actions.
So that's not possible. You would need to do that by writting yourself the MySQL query in your PHPMyAdmin.

That's what I've already done as a workaround.
Thank you very much!
Regards

may be I am wrong but I have this for "set canonical URL" and it is work great
/muzhchinam/krossovki-new-balance/new-balance-996/product/{product_id}-{product_alias}