NEW UK VAT 15% not 17.5% problem

[chilsta]

Thanks very much for your help and the detailed info Chris.

I will try it now. So glad I don't have to go through and manually edit all the prices :)

[cjhearn]

You're welcome. I've just realised it's probably a good idea to bookmark / print this page for when VAT goes back up...!

[cjhearn]

Another update! Just found you also have to update any shipping costs you have in Modules > Shipping with the new ex-VAT costs.

If it's any help, I used the VAT calculator at http://www.taxcentral.co.uk/taxcentr...or/default.asp to calculate the new shipping rates.

[edwinlloyd]

May I ask how to change another element?

If I price a product by attributes (base price = 10, attribute one adds 5 and attribute two adds 7), the method shown in the earlier post adjusts the base price, but how do I adjust the attributes value so that they still come to the original price with the new VAT?

Thanks,
Edwin

[cjhearn]

I found I had to do this exact thing too earlier today but I only have a couple of attribute-priced products so edited them manually using the VAT calculator I mentioned earlier.

If you've got a lot of attribute-priced products you could use:

UPDATE products_attributes SET options_values_price= options_values_price *1.175;
UPDATE products_attributes SET options_values_price= options_values_price /1.15;

I also realised that you should go through all the products and make sure the prices are correct as the calculations may mean prices are out +/- 1p.

[edwinlloyd]

Spectacular. That seems to be working. I can see that there will still be lots of manual checking, but that will definitely reduce the errors I introduce. Thanks.
Are you shutting up shop until midnight, or are you selling with invoices showing 15% VAT already?

[cjhearn]

We sell from a physical shop which closed at 3pm yesterday and wasn't open today (Sunday) therefore any orders placed after closing time yesterday won't go through our tills until tomorrow when the new rate is officially in force. This has at least meant I've had enough time to (hopefully) find and make all the necessary changes.

It would have been good though if, when changing the tax rate in the Locations / Taxes menu, ZC then gave the option to make changes to base prices, attributes, specials and any other places prices hide automatically. Ah well... hopefully won't have to do it again until the end of next December! hehe

[kitcorsa]

thanks to cjhearn for the advance on what i started.

i have ran this mysql patch on my site and all went fine with no errors.

please backup first though

[cjhearn]

Yeah, sorry kitcorsa for stealing your thunder ;) I was just happy to have found something I was able to help with!

Hope things all go well for you following this changeover.

[stubbsy]

I added the WHERE clause because I have VATable and non-VATable products in my catalogue. You may want to go to Locations / Taxes > Tax Classes and double-check that your 'Taxable Goods' class is ID 1 before running the above SQL.

If you've got any Specials set up you'll also need to run the following SQL:

UPDATE specials SET specials_new_products_price= specials_new_products_price *1.175;
UPDATE specials SET specials_new_products_price= specials_new_products_price /1.15;

One question, you say you have VATable and NONVATable products in your store, when updating the specials pricing does this also change the price of products on special which don't have VAT on them?


Thanks

Dave