Hi,
You can't do it with an "update the values" action, as it will set the same price for both currencies.
And you can't also select some variants of a product based on a characteristic value with the mass actions system.
So you would have to directly run a complex MySql query in your PHPMyAdmin.
Something like that :
Code:
UPDATE #__hikashop_product as p
LEFT JOIN #__hikashop_product as pp ON pp.product_id = p.product_id
LEFT JOIN #__hikashop_product_category as pc ON pp.product_id = pc.product_id
LEFT JOIN #__hikashop_category as cat ON pc.category_id = cat.category_id
LEFT JOIN #__hikashop_price as price ON p.product_id = price.price_product_id
LEFT JOIN #__hikashop_currency as currency ON price.price_currency_id = currency.currency_id
LEFT JOIN #__hikashop_variant AS v ON p.product_id = v.variant_product_id
LEFT JOIN #__hikashop_characteristic AS c ON c.characteristic_id = v.variant_characteristic_id
SET price_value = XXX
WHERE cat.category_name = 'YYY'
AND c.characteristic_value = 'ZZZ'
AND currency.currency_code = 'AAA'
where XXX is the new price, YYY the name of the category, ZZZ the value of the characteristic, AAA the currency code AND #__ the table prefix of your website.
Note that I didn't test it...
If it's a one time thing and you only have a few products with a few variants to modify, I would recommend to simply modify them via the interface provided in the backend of HikaShop.
