Tip - updating tax settings
Posted: Wed Mar 23, 2011 5:59 pm
In 6.1.1 the tax is done a bit differently, so now you can set up zones, etc, properly that reflect VAT. However, products that were previously set up as taxable, do not have this new setting changed, so international orders don't work correctly, as they have all the tax taken off no-taxable products.
Anyway, long story short, if you use the 4 standard tax options Default Tax Class, Gift Wrapping, Non-Taxable Products, Shipping - then you need to run this SQL statement in your database to set up all your existing non-taxable products as non taxable for international purposes:
Anyway, long story short, if you use the 4 standard tax options Default Tax Class, Gift Wrapping, Non-Taxable Products, Shipping - then you need to run this SQL statement in your database to set up all your existing non-taxable products as non taxable for international purposes:
Code: Select all
UPDATE isc_products SET tax_class_id=1 WHERE prodistaxable=0