I've got a bit of a doozy here. Hopefully someone can point me in the right direction.
I'm using both Peter Mosier's instructions on how to set up Canadian taxes, and the Canada Taxes Order Total Module.
I'm building a store which sells both books and DVD's, this is causing a real problem when it comes to properly calculating the taxes on the shipping charges. For provinces which charge PST and GST on shipping (Saskatchewan, Manitoba, Quebec, & PEI) if you purchase only books then only GST should be applied to the shipping. If you purchase books and dvd's then both PST and GST need to be applied to the shipping.
I cannot find any method to calculate the taxes on the shipping in that manner, so right now we're always charging PST & GST for those above provinces.
Basically I need to do the following:
If the cart contains a non-book (DVD's) >AND< the shipping address is in SASK, MAN, QUE, PEI >THEN< charge GST & PST on shipping. Otherwise if the cart contains only books >THEN< charge only GST.
Is there an addon or technique I've missed that would do this? Right now it looks like we'll need to do a chunk of new coding to check against tax classes and shipping locations.