New tax, new tax rule

[starshaker]

Hi there 

 

i want to chance vat from 23% to 24% because tax changed in my country but i also want to not to change the prices in my shop if i change the tax. i mean that if i change the vat to 24% i don't want the prices in my shop to change. i want the prices that i have now. is that possible?

 

[shokinro]

 

 i want the prices that i have now. is that possible?

 

 

Do you mean price include tax is the same?

[musicmaster]

If I understand it well you want to decrease your net prices so that your prices with tax stay the same. That means that you need to multiply all prices with 0.9919354. (=123/124)

 

That means that will get sql like the following (I don't know your tax groups so I don't know whether this is correct for your situation.

$query="UPDATE "._DB_PREFIX_."product SET price=(price*0.9919354838) WHERE id_tax_rules_group='1'";
$query="UPDATE "._DB_PREFIX_."product_shop SET price=(price*0.9919354838) WHERE id_tax_rules_group='1'";

Be sure to make a backup before you try this!