changing all products to start adding tax VAT

[UKclearancecentre]

My prestashop store has been running for just over 12 months now and i am now going to start having to charge VAT (Uk tax) on my products. I have been unable to find a way of enabling VAT for all my products without having to go into each individual product and set the tax from No Tax to VAT at 17.5%. Surely there must be a way of doing this on mass. perhaps with phpmyadmin on the database?

[UKclearancecentre]

I managed to figure out how to do this from within phpmyadmin see the code below

UPDATE `ps_product` SET `id_tax` = replace(id_tax, "0", "1");

Run this SQL query in phpmyadmin and it will change them all in no time. took less than a second to do it on my server for over 400 products
This will set VAT on all the products to the VAT amount set at position 1 in the Payment > Taxes area of the back office, if you want to set it to one of the other VAT levels then change the number "1" to "2" or "3" etc depending on which one is relavent for you

[h4r15]

Thanks for this very useful tips.
It is a nightmare to edit one by one as i have more than 300 products.

[AnnaEw]

Hi there, I need help!
i have a similar problem, but the other way round. I added taxes to all my products and now I need that every product have "no tax" on its info tab... is there a way to do this all at once, without having to edit each product one by one? (I have more than 500 items) :-/

I would really appreciate any help with this! thanks!

[Dave L]

Have a look at:

Payment > Taxes

There is a selection to disable taxes.

[need4speed]

Nice "UKclearancecentre" just what I needed

[turdi]

Hi, is it posible to add quantity of the products using this method?

 

For ex. I have 10 of all the product's. I have imported more than 500 product's and now need to update data.

 

Thanks,