Page 1 of 1

Tip - updating tax settings

Posted: Wed Mar 23, 2011 5:59 pm
by Tony Barnes
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:

Code: Select all

UPDATE isc_products SET tax_class_id=1 WHERE prodistaxable=0

Re: Tip - updating tax settings

Posted: Wed Mar 23, 2011 9:20 pm
by Martin
Another piece of sh*t upgrade code missed out then... Quelle surprise!!! :roll:

Harsh? No, not really, not after a year of debugging some really flippin awful convoluted rubbish related to inventory changes... :evil:

Re: Tip - updating tax settings

Posted: Thu Mar 24, 2011 5:29 pm
by Tony Barnes
I tell you one thing, it confused the shit out of me trying to work out what was happening!!

Still, at least the fix is easy :D