VAT problem...

[mythandmagic]

Hi,

Hope someone can help me out here.

i was using my site without any of the VAT options, but the prices were inc VAT.

Now i require to show that prices inc the VAT, but when i tick the box to show that prices inc vat in business settings it adds another 17.5% on top.

Is there a way to do this so i dont have to change every single price in the shop ?

[fergusw]

In V7? No.

V9 has Vat Inclusive and Vat Exclusive models.

Your best bet is to programmatically remove the VAT amount.

i.e. you (or someone else) could run an update against the price field in the database removing the VAT e.g. [(inc VAT amount) / 1.175], or even [(inc VAT) * 0.8510638

[mythandmagic]

lol, thanks for that....

But can you dumb that down a bit, like step by step what to do ?

[NormanRouxel]

The price field is stored in pence. Make sure you only put integer values back after conversion.