Change VAT and Keep Same Prices

[teomar]

Hello,
Recently my Country changed the % of VAT from 23% to 24%. Is there any way to make the change without changing one by one the products and keep the same final prices ?

Thanks in advance

[jenkinhill]

All prices are calculated from the base price, so maybe if you multiplied the base price by something like .95833 then the final proce would be about right?  Of course there will be some changes due to rounding, but all prices could be changed in the db just by one sql query.

Or make an override price for all products the same as each product current 23% selling price, again using sql.

Otherwise you have to do it one product at a time in the backend.

[Studio 42]

Hi,
you can use my tool here http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm.
Set the multiplicator in the price tab eg. x0,9919354838709677 and "process". But you can process 1000 products by 1000 products only but you have a "next" page button, so you can do the full shop in some steps.
Remember to backup your shop before doing your changes.