Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 11-28-2008 12:36:32
New VAT rate change
Hello
Is there an easy way to change an items VAT rate to the new 15% rate or will I have to change the price for an item manually?
Currently, an items price includes VAT at 17.5%
The new rate change comes in on Monday I believe, so I need a quick solution to this.
Thank you
Mark Bowles
Cornweb
Offline
#2 11-30-2008 09:10:39
Re: New VAT rate change
Yes, you can do a mysql command.
Something like change all prices to = $price / 117.5 * 115
I am just looking how to change the VAT rate as VAT is automatically added on. I assume that's covered on another post.
Last edited by amdowney (11-30-2008 09:12:02)
Offline
#3 11-30-2008 17:13:08
- llucalari
- Member
- Registered: 09-08-2004
- Posts: 7
Re: New VAT rate change
Hi
I couldnt get the price change to work, what about product options price - will I have to update all the prices with the new VAT rate manually? Any help - please
Offline
#4 12-01-2008 09:42:24
- llucalari
- Member
- Registered: 09-08-2004
- Posts: 7
Re: New VAT rate change
Back up your database first - I take no responsibility for lost data.
Change product table source to CSV and save Public_HTML\Data\Tables\Product.csv as a backup
Change product table source back to sql
Got to sql statement submission
Select 'Product' table – select UPDATE
In SQL staement box type in
UPDATE product
SET product_regprice=product_regprice / 117.5 * 115
This does no rounding up so you might get some odd looking prices.
Offline