Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tax Rates


loghova

Recommended Posts

Posted

I am attempting to set up osCommerce to only charge sales tax to in state residents. I do not wish to have it charge sales tax to customers out of state. Is this poosible and how is it done?

Posted

After searching the forum for possible solutions my Tax Rates table is screwed.

 

This is the error I recieve after clicking 'Tax Rates' in the Admin Panel.

 

Tax Rates  

Priority Tax Class Zone Tax Rate 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 r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20

 

Any assistance would be appreciated.

Archived

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

×
×
  • Create New...