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

[kitcorsa]

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

[kitcorsa]

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

[kuroi]

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.

[kitcorsa]

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

[andreitero]

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.

[kitcorsa]

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

[kuroi]

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.

[daparky]

Thanks for this :)

[andreitero]

Thanks Kuroi, it works perfectly!

[-Jc.]

Thanks Guys -worked first time! -Jc.