Updating UK Vat rise to 17.5%

[Alex Clarke]

Alex, I had lowered prices and needed to show the "real" price so just did the change (though do need to round some of the resulting prices to "nice" amounts). I guess we're all going to handle this in different ways.
cheers
Guy

Indeed. As with the VAT reduction last year some of my clients chose not to pass on the savings to their customers (i.e. they adjusted their gross prices).

Hope things are working well for you.

[daparky]

How have you come up with this calculation?

I always do a database update with a formula like this:

1) Times the base price by the old VAT rate (8.6870 * 1.15)
2) Divide the result by the new VAT rate (9.99/1.175)

Explain yours :)

[Calljj]

Simple math to calculate required effect of taxation:
1.15/1.175 = 0.978723404255

Therefore keeping retail price the same:
base price = base price * 0.978723404255

Convert to sql statement:
update products set products_price = products_price*0.978723404255

Explain your calculation in an sql statement that is simpler than the above example? ;-)

[daparky]

Something like this...
UPDATE products SET price = (price*1.15) / 1.175

[Calljj]

umm. no, thats not more simpler.. the numbers might look nicer, but it ain't simpler!

[tbrides]

Hi,
Maybe somebody subscribed to this thread could help me with my issue.
See my thread

http://www.zen-cart.com/forum/showthread.php?t=150182