UK VAT increase Jan 2011... keep prices the same

With the VAT increase today in the UK to 20% here are the instructions how to iuncrease your VAT to 20%

1)log into you admin section.

2)Back up your database

3)click on the locations & taxes > tax rates

4)click on the UK tax rate and click edit

5)change the VAT rate to 20.0000

your site will now be using the current 20% vat rate.

KEEPING PRICES THE SAME
If you would like to keep your prices throughtout your websiter the same as they are before when at 17.5% ie price at 17.5% gross was 117.50 with net of 100 if at 20% you would also like the keep the gross at 117.50 you will need to change the net of the items. Here is a SQL script to change your entire website so no prices change.

update products set products_price = (1.175*products_price)/1.20;

to use this script do the following

1)log into your admin section

2)back up your database

3)go to tools>sql patches

4)copy and paste the above code into the box and click run

you will need to go throught an manually change the specials prices as these are not changes also change the postage costs if you dont want these to change also

For completeness you should also update the price sorter i.e.

update products set products_price = products_price * 1.175 / 1.2, products_price_sorter = products_price_sorter * 1.175 / 1.2, products_last_modified = now();

and specials can be updated by

update specials set specials_new_products_price = specials_new_products_price * 1.175 / 1.2, specials_last_modified = now();

This assumes that all products are VATable (otherwise a conditional query based on your tax classes is needed)

And yes, if you're accounting for VAT in your shipping costs (and you should be if you're VAT-registered) don't forget to tweak your shipping module costs.

Thanks for extanding this a bit further. I forgot to add onto mine that i went to store manager and updated the price sorter there

Is there a way to increase specials price for a manufacturer?
I'm not too good with SQL, I've tried:

update specials set specials_new_products_price = specials_new_products_price * 1.175, specials_last_modified = now() where manufacturers_id = 8 ;

But it doesnt work.

update specials set specials_new_products_price = specials_new_products_price * 1.175 where manufacturers_id = 8, specials_last_modified = now() ;

Neither of the above will work because the manufacturers_id isn't in the specials table.

Try

UPDATE specials s, products p
SET s.specials_new_products_price = s.specials_new_products_price * 1.175, s.specials_last_modified = now()
WHERE s.products_id = p.products_id
AND p.manufacturers_id = 8;

Untested, but should work.

Thanks for this :)

Thanks Kuroi, it works perfectly!

Thanks Guys -worked first time! -Jc.

Hi there,

I have done all the above, thanks works perfect, however my coupons do not display correctly now, if I set up a coupon in the admin for £3, when customers use it on the checkout page it does not show correctly as £3...

Does this need changing too? It was a new coupon set up after I made these changes.... not an old coupon. Any ideas?

Bump anyone?

Hello anyone here?

i cant replicate the problem sorry, make sure you updated the prices from the store manager

Hi there as per the topic of this thread I did not update the prices from the store manager, but by running the sql scripts detailed above, and now if I set a coupon as £3 in the admin, firstly on the checkout page it shows as £3.02, and then in the totals it takes off £3.50!

It just doesnt make sense? Can anyone help!!