Mass action update specific prices

Hi,

You don't need a mass action anymore to do that.
A simpler solution is to go in your products listing in the backend and click on the category in the left explorer. Make sure you have all the products on the page and click on the main checkbox at the top left corner of the listing to select all the products of that category.
Once done, click on the "actions" button at the top.
That will open a popup. There, select the action "update the values" and select the price_value column. Select the type "float" and enter in the input field the value 12.95
Then, validate and that's it.

Please note that this supposes that the products already have their price with taxes in the database.
If that's not the case, then you need to first calculate the price without taxes that you want to user instead of 12.95 in the input field of the popup.

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 :

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'