How to change the products tax without changing the price?

[neiman]

Hi,

I'm wondering how to change the products tax rate without changing the price?

[Jörgen]

Do You mean the final price ?
The answer is no, You can´t.

You have to adjust the base price to compensate for the change in tax. Higher tax, lower base price. Lower tax, higher base price.

regards

Jörgen @ Kreativ Fotografi

[neiman]

That was what I meant. Is it somehow possible to lower all base prices at once or should I change every products price individually? Can I for example lower the base prices by removing a certain percentage of the price?

[AH]

You can change prices by working directly on the database table xx_virtuemart_product_prices in phpmyadmin.

xx = your database table prefix.

And using a MYSQL statement

UPDATE xx_virtuemart_product_prices SET product_price = product_price * .9

Reduces all prices by 10%

Make sure you try this on a backup before working on it in live

You could also use CSVI component - but that is really overkill