Frenzy Posted January 3, 2011 Share Posted January 3, 2011 With the UK VAT change, is there an easy way i can change the vat rates on my products in a one hit - Rather than selecting each item individually in BO and changing the rate to 20% (which is set up ready to go) Link to comment Share on other sites More sharing options...
davidsiti64 Posted January 3, 2011 Share Posted January 3, 2011 Frenzy I can't help but I've just completed all the individual items on our webb site happy new yearDavid & Sitiwww.viennaclothing.co.uk Link to comment Share on other sites More sharing options...
mothwolves Posted January 3, 2011 Share Posted January 3, 2011 Hi FrenzyYou need to export products (there are a few free export modules on the forums) export prod ID , tax and name fields...edit the tax column to 20% in excel save as a csv then re import ensuring you keep the product ID's intact via the standard import tool.Thats how I did it anywayHope this makes sense.RegardsWaynehttp://www.techideal.co.uk Link to comment Share on other sites More sharing options...
DutchCoding Posted January 4, 2011 Share Posted January 4, 2011 Cant you just change the Old VAT to 20%? wouldnt that change it on all products? if not do you have access to your MySql ? then it would take ONE query. otherwise a quick module should do. let me know what version your running. Link to comment Share on other sites More sharing options...
spid3r1987 Posted January 4, 2011 Share Posted January 4, 2011 all i did was goto "back office>payment>taxes>"click edit on the UK VATand then change the vat rate to 20%worked for me :S Link to comment Share on other sites More sharing options...
Eck! Posted January 4, 2011 Share Posted January 4, 2011 For product attribute combinations the magic number to go from 17.5 to 20 is 1.021277.In other words: UPDATE `product_attribute` SET `price`=`price`*1.021277 Link to comment Share on other sites More sharing options...
DutchCoding Posted January 4, 2011 Share Posted January 4, 2011 Nice Eck! Link to comment Share on other sites More sharing options...
Melah Posted January 26, 2011 Share Posted January 26, 2011 I am still having problems with the VAT change. I have changed the Taxes rate to 20% but when a product is added to the cart the vat charged is 17.5%. Any advice on why this is happening or how I can change it would be greatly appreciated. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts