UK VAT Changes 2010 - Updating Prices & Specials Prices

[pafranklin]

Hi there,

 

We are just a few days away from the UK VAT rate increasing back to 17.5%, but I would like to keep my gross prices the same and not increase them form our customers, so I am looking to identify a script that can reduce the net prices in phpMyadmin once I have changed the tax rate back from 15% to 17.5%.

 

I believe that I need to change both the product price and the specials price? Is this correct?

 

I have started to work on a script but would like someone to have a look at this before I attempt to use it as I am not sure that these will work???...........

 

a. To update products_price:

UPDATE products SET products_price = products_price /1.0217

 

b. To update Specials net prices

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217

 

Any help would be appreciated please?

 

Many thanks.

 

Paul

[♥geoffreywalton]

Paul

 

If you are nervous add

 

where product_id ='1234'

 

to only change one product price, check the field name required, I do not have access to phpmyadmin at the moment.

 

You could also search the forum for 17.5 or 175 to get all the queries from last year.

 

site:addons.oscommerce.com 17.5

 

G

[pafranklin]

Paul

 

If you are nervous add

 

where product_id ='1234'

 

to only change one product price, check the field name required, I do not have access to phpmyadmin at the moment.

 

You could also search the forum for 17.5 or 175 to get all the queries from last year.

 

site:addons.oscommerce.com 17.5

 

G

 

Thanks G!

 

I have tested, checked and implemented, but would advise others to double check before using the same approach.

 

Please note that I have used this approach to change the VAT from 15% to 17.5% but WITHOUT increasing the product prices which I wish to keep the same!

 

First I identified one product and tested with the following two scripts which I ran through phpMyadmin

 

To update (reduce) products_price:

UPDATE products SET products_price = products_price /1.0217 where products_id ='6966' (This is for the one specific produict that I selected to test)

 

To update (reduce) Specials

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217 where products_id ='6966' (This is for the one specific produict that I selected to test)

 

Once tested I ran the following to change every product price and every specials price.

 

UPDATE products SET products_price = products_price /1.0217

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217

Next I updated my tax rate from 15.00 to 17.5% and went back to check. There were a few small roundings of 1p here and there but for the main part no prices have changed dramatically.

 

I hope that this helps someone else.

 

Best wishes.

 

Paul

[Guest]

Thanks G!

 

I have tested, checked and implemented, but would advise others to double check before using the same approach.

 

Please note that I have used this approach to change the VAT from 15% to 17.5% but WITHOUT increasing the product prices which I wish to keep the same!

 

First I identified one product and tested with the following two scripts which I ran through phpMyadmin

 

To update (reduce) products_price:

UPDATE products SET products_price = products_price /1.0217 where products_id ='6966' (This is for the one specific produict that I selected to test)

 

To update (reduce) Specials

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217 where products_id ='6966' (This is for the one specific produict that I selected to test)

 

Once tested I ran the following to change every product price and every specials price.

 

UPDATE products SET products_price = products_price /1.0217

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217

Next I updated my tax rate from 15.00 to 17.5% and went back to check. There were a few small roundings of 1p here and there but for the main part no prices have changed dramatically.

 

I hope that this helps someone else.

 

Best wishes.

 

Paul

 

Paul, thanks very much for this.

 

If it is of help to others, using a figure of 1.0217395 works more accurately if you have products with big prices (and stops rounding up from 49.99 to 50.00 for example)..

 

Thanks again.

[Fyod]

Thanks for this! I've been looking everywhere for a fix. Will try asap.

[♥geoffreywalton]

Jordan

 

Glad it worked.

 

Bet you are glad not to be in Eire where the VAT is significantly higher.

 

Cheers

[Fyod]

Worked a charm. I first tested one product just in case and then hit the whole DB.

Thanks again! Saved me tons of time.

[Guest]

Jordan

 

Glad it worked.

 

Bet you are glad not to be in Eire where the VAT is significantly higher.

 

Cheers

 

I sure am... :-)