Mass change VAT rule pricing

[guesswhatiforgot]

Hi Forum,

We are currently trying to find a solution to our tax problem! We are soon going to be tax exempt for the vast majority of our items, well over 1000 individual products, and each are currently set with the UK standard rate of 20%. We need to remove this VAT, but keep the current VAT included price, as turning off the rule in the international tag brings the items price down to the VAT excluded price. Is there an SQL command we could run to somehow copy the VAT included price over to the VAT Excluded price, and then turn off the tax rule? Or even a module or customer group rule that could save us from editing all the items individually?

Regards,