How to turn on VAT for all products at once?

[SystemOAD]

Hello,

Im starting a new lingerie store and need to know how/where I turn the VAT on for all my products (I am importing about 1000 products by csv).

I cant really site down and turn VAT on for each and every product individually as it would take so long to do this due to the number of products we have imported. I can delete all products and re-import if this should be done before I import them so either way is ok for me, I just need to make sure to add the 17.5% VAT to every product please.

Kind Regards,
Nath

[rocky]

If all your products have the same tax, you could run an SQL query like the following in phpMyAdmin to add tax to every product:

UPDATE `ps_product` SET `id_tax` = 1

Change ps_ to your database prefix and 1 to the ID of the tax you want all products to have.

Remember to back up your ps_product table first in case anything goes wrong.