Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Newbie and Canadaian taxes


Recommended Posts

I am not sure if I am doing this properly or not. I am trying to post a message about oscommerce and installing correct Canadian taxes. I have watched a contribution article in the contributions section, however I cannot get my site to work properly. I am not blaming the article since it probably is me. The problem is I cannot get it to work and there seems to very little other sources out there addressing the Canadian tax system with oscommerce. Is there anyone with experence in the canadian tax setup that could steer me with hints or directions. When I go to my tax zones this is the info on that screen.


Tax Zones


Tax Zones Action


Displaying 1 to 1 (of 1 tax zones) Page 1 of 1






Number of Zones: 0


Date Added: 04/13/2005

Last Modified: 04/16/2005






Tax Zones



When I click on the details button this is the message I get there. Can anybody help?


Country Zone Action

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1


select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 2 order by association_id limit -20, 20

Link to comment
Share on other sites



I had the same problem last week and found this under contributions...




The problem is we have the GST and various provincial scams, I mean, schemes! The contribution also helps with the PST and HST for the provinces... You may also want to note that Shipping is subject to provincial tax but not GST - this contribution explains that too!


BTW I'm still trying to figure out how to deal with PST Exempt companies... If anyone knows how to deal with that I'd like to know...



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...