beretta627 Posted December 28, 2004 Posted December 28, 2004 Hello ... Okay, somehow I have broken tax. When I had a vanilla copy of osc, i configured the rate, class, and zones for tax with success and all was well. However, I have matured (immatured?) my osC and for some reason tax has broken. Not broken as in errors, etc. But broken in the sense that I do not think the customer's zone is correctly identified. California is the only taxable zone at 7.25, with the following row data from the following tables: zones table: California has a zone_id of 12 and a zone_country_id of 223, zone_code of CA, zone_name California in the zones table. geo_zones table: geo_zone_id =1 geo_zone_name=California zones_to_geo_zones table: matches with an association_id = 1, zone_country_id = 223, geo_zone_id = 1. tax_rates table: tax_rates_id=2, tax_zone_id=1, tax_class_id=1, tax_priority = 1, tax_rate= 7.2500 tax_class table has a tax_class_id=1 ---------------- A customer X with an address_book row that contains a entry_state of ca, entry_country_id = 223, and entry_zone_id = 12 goes to check out, and does not get charged tax. So basically, all the information lines up in the database... I posted it up here just in case i'm wrong on that conclusion. My real questions are: which files and when does osC determine the zone of a customer in order to calculate tax? I'm having trouble connecting the dots in order to find when osC says "yes, this customer is from California, lets tax the order." I don't recall touching any file that would make osC tax function break, but I'm not an expert programmer and I don't yet understand the entirety of osC logic to follow all the code. If someone could answer my question to help me figure out the problem I would be very grateful. Thanks for your time reading this... I look forward to a reply! Chris
beretta627 Posted December 28, 2004 Author Posted December 28, 2004 ok, i realized i didnt put a tax_id for the actual products, so that problem is solved... my only problem is now ... when a customer adds himself to the database, the zone information for the state and the country are not being added!!! Help is greatly appreciated, Thanks, Chris
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.