Shopping Cart Software

Shopping Cart Software ClickCartPro XCS Version
corner image corner image

HMRC Vat Increase From 17.5% to 20%

HMRC Vat Increase From 17.5% to 20%

Postby GreenbarnWeb » 31 Dec 2010 22:34

On sales of goods and services from the 4th January 2011 the Vat rate will increase from 17.5% to 20%.
How to change the Vat rate in ClickCartPro XCS and CCP6.
In the admin goto: Home > ClickCartPro XCS > Commerce: Orders and Checkout > Manage EU Tax Rates
Update High Rate
Change EU Tax Rate* from 17.5 to 20

You will need to delete the contents of the customer’s carts, goto:
Home > ClickCartPro XCS Core > Raw Database Admin
Click the link SQL Statement: Submit a Raw SQL Statement
In the SQL Statement* box enter
delete from gbu0_cart

Note for customers using prices including vat:
If you want to increase your prices by the 2.5%, we recommend you do this via directly editing the product table prices. If you try to add a global 2.5% increase to the database you will be left with prices that are not exactly to two decimal places and this will cause problems with the vat calculation and display.

How to export the product tables:
In the admin goto: Home > ClickCartPro XCS Core > Raw Database Admin
You need to export the gbu0_prod and gbu0_prodoptionsel tables.
To down load the table csv files to your local computer via Home > ClickCartPro XCS Core > Manage Download Files

How to edit your product csv files.
Save a back-up copy of the table files.
Edit the prices using open office Calc or MS Excel.

How to Import the product csv files.
In the admin goto: Home > ClickCartPro XCS Core > Raw Database Admin
You need to import the changed gbu0_prod and gbu0_prodoptionsel table csv’s files.
Howard Galpin
http://www.greenbarnweb.com
http://www.clickcartpro.co.uk - UK Customised version
http://www.clickcartpro.eu.com - European Customised version
GreenbarnWeb
Site Admin
 
Posts: 1184
Joined: 29 Jul 2009 10:58

Return to General E-Commerce Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron
corner image
Valid XHTML   Valid CSS   w3c wai aa
GreenbarnWeb.com © 2001 - 2014
corner image