VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: neiman on January 20, 2015, 19:04:25 PM

Title: How to change the products tax without changing the price?
Post by: neiman on January 20, 2015, 19:04:25 PM
Hi,

I'm wondering how to change the products tax rate without changing the price?
Title: Re: How to change the products tax without changing the price?
Post by: Jörgen on January 20, 2015, 20:18:11 PM
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



Title: Re: How to change the products tax without changing the price?
Post by: neiman on January 21, 2015, 09:30:03 AM
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?
Title: Re: How to change the products tax without changing the price?
Post by: AH on January 21, 2015, 09:44:23 AM
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