Tip - updating tax settings

Tips, Tricks, How To Guides, etc..
Post Reply
Tony Barnes
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Tip - updating tax settings

Post 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
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: Tip - updating tax settings

Post 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:
Tony Barnes
Posts: 744
Joined: Thu Jun 18, 2009 8:59 am

Re: Tip - updating tax settings

Post 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
Post Reply