VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: Diondk on May 10, 2014, 22:08:58 PM

Title: Change VAT to 21% but keep sales price
Post by: Diondk on May 10, 2014, 22:08:58 PM
Hi,

A few months ago the dutch government raised the VAT from 19 to 21% and a new customer still has is VAT at 19 %.
He wants to change the VAT settings to 21% but keep the same sales price as it now.

How can i make this happen? the customer has over 800 products and i dont want to recalculate everything.

Kind Regards,
Dion
Title: Re: Change VAT to 21% but keep sales price
Post by: GJC Web Design on May 10, 2014, 23:08:05 PM
as only one price is stored by VM (except for over ride prices) - the base price - you can do a general mysql query to manipulate that price in the jos_virtuemart_product_prices table..

if you times all the base prices by 0.983411 then the retail price will remain the same for an increase Vat of 21% -