SQL command to update VAT on all products and services with a certain vat amount

Using my Dolibarr
1

UPDATE public.llx_product
SET tva_tx = 12
WHERE tva_tx = 6;

2

Hi @egils
No need for that
Home → Admin Tools → Global VAT Update

1 Like
3

I disagree, I had some products with 25% VAT that I wanted to keep that way :grinning:

Your solution would have changed all products in the llx_products table which is not what I wanted.

4

Hi @egils,
No, it does exactly the same thing as in your sql example, it will only change those ones with 6% to 12%

1 Like