Changing VAT rate

[Guest]

Hi, due to the impending change in Value Added Tax in the UK, a client of ours needs to have the total price of all their products recalculated. The product tax was originally entered manually, but there are now so many products that we need to find a way of instantly changing the "price including VAT" inside the admin control panel.

 

I have seen that this can be done under Tax Rates, where this is currently set to 15.00%. We need to set this to 17.5%, however as far as I'm aware the tax values were set manually on each product, so I don't think this value / field is being used.

 

Is there a way to make this value override the manually inputted value for each product, without going into each product on the site? (There are thousands!)

 

Also to check if the VAT field *is* being used, is it safe to temporarily change the tax rate, see if the product prices update, and then change the tax rate back?

[satish]

Use easy populate.

 

or if its just the tax rate then just edit the tax rate.

 

Satish

[Guest]

Can you tell me what "easy populate" is? Never heard of that...

[♥geoffreywalton]

Easypopulate is a contribution/add on that allows you to update products from a spread sheet.

 

Use the site admin to see what price is held for a specific product, then use phpmyadmin to see what values are actually there.

 

Than you can use an sql command like

 

UPDATE products SET products_price = products_price * 1.11111 WHERE products_id = 654

 

Feel free to cnge 1.111 and 654 for your values

 

For more info on sql statements see www.w3schools.com

[Guest]

Easypopulate is a contribution/add on that allows you to update products from a spread sheet.

 

Use the site admin to see what price is held for a specific product, then use phpmyadmin to see what values are actually there.

 

Than you can use an sql command like

 

UPDATE products SET products_price = products_price * 1.11111 WHERE products_id = 654

 

Feel free to cnge 1.111 and 654 for your values

 

For more info on sql statements see www.w3schools.com

 

Ok, so really I need to create a spreadsheet with all the new "including VAT" prices for each product? Or would I use phpmyadmin? Either way it sounds like it needs to be done manually, which isn't going to happen as I have something like 10,000 products!

[Guest]

Ok, so really I need to create a spreadsheet with all the new "including VAT" prices for each product? Or would I use phpmyadmin? Either way it sounds like it needs to be done manually, which isn't going to happen as I have something like 10,000 products!

 

AFAIK the database stores prices net, so you should be able to just change the VAT rate to 17.5% through admin.

 

To check - get to phpmyadmin or whatever equivalent...

 

SELECT p.products_price, pd.products_name FROM products p, products_description pd WHERE p.products_id = pd.products_id

 

Which will give the product name and the price, which you can cross-check with the actual site to check if they are net or gross. I wouldn;t do them all, just a few.

 

If not - does the client ONLY sell standard rates products - or are there any lower/zero/exempt?

 

Davin

[Guest]

AFAIK the database stores prices net, so you should be able to just change the VAT rate to 17.5% through admin.

 

To check - get to phpmyadmin or whatever equivalent...

 

SELECT p.products_price, pd.products_name FROM products p, products_description pd WHERE p.products_id = pd.products_id

 

Which will give the product name and the price, which you can cross-check with the actual site to check if they are net or gross. I wouldn;t do them all, just a few.

 

If not - does the client ONLY sell standard rates products - or are there any lower/zero/exempt?

 

Davin

 

I'll try and set up in phpmyadmin, will see how we go...

[satish]

If all products have same VAT then an sql query will do.

 

 

Satish