6 Mar 2012, 11:45 AM
Totally Zenned
- Join Date:
- Jan 2009
- Posts:
- 2,085
- Plugin Contributions:
- 0
Add VAT to all Products (Apart from one Category)
We've just registered for VAT so we need to add VAT to all products, site wide, apart from a sepcific category.
I have an SQL query that's switch it on across the board:```php
UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;
How would I exclude category 350 from this query? Would really appreciate any help here.
