ozog Posted February 19, 2007 Share Posted February 19, 2007 I have a file that lists the taxes by state, county, and local with zip codes. This is how the tax table looks: Postalcode Stateprov Stateprovtax City Citytax County Countytax Districttax Salestax 90001 CA 0.0625 FIRESTONE PARK 0 LOS ANGELES 0.01 0.01 0.0825 90001 CA 0.0625 FLORENCE 0 LOS ANGELES 0.01 0.01 0.0825 90001 CA 0.0625 LOS ANGELES 0 LOS ANGELES 0.01 0.01 0.0825 90002 CA 0.0625 LOS ANGELES 0 LOS ANGELES 0.01 0.01 0.0825 90002 CA 0.0625 WATTS 0 LOS ANGELES 0.01 0.01 0.0825 90265 CA 0.0625 TWAIN HARTE 0 VENTURA 0.01 0 0.0725 How can I get OSCommerce to integrate this into the tax table where it looks up the zip code and city and to get the final sales tax(i. e. .0825) as some zip codes, as you can see, have a differant sales tax. Link to comment Share on other sites More sharing options...
ozog Posted February 20, 2007 Author Share Posted February 20, 2007 isn't there anyone who can help? Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 Andrew, I had a smililar question but resolved with my state tax folks. I have a small business in Alabama, just outside a small town. When selling via internet I am only required to charge tax for sales in Alabama. The sales tax is based on MY location... 4% State and 2% County: Total 6% If I sell to someone in Gulf Shores, Alabama, where they have a 3% city tax, I still charge only 6% because the sales originated in the State of AL, County and my business was not in the city thus I only had a 6% sales tax charge... If I had to do what u are thinking, I would have to have the sales tax rates for every little one horse town in Alabama... So the bottom line is the slaes tax rate shoudl be purely based on your business location.... SteveRF Link to comment Share on other sites More sharing options...
ozog Posted February 21, 2007 Author Share Posted February 21, 2007 Because of the company I am affiliated with, I have to charge sales tax to the shipping location in all 50 states. It does not matter where I am. It only matters where I ship the sold item to. That is why I need to charge tax to every little one horse town. Link to comment Share on other sites More sharing options...
DailyLunatic Posted February 22, 2007 Share Posted February 22, 2007 Andrew,I had a smililar question but resolved with my state tax folks. I have a small business in Alabama, just outside a small town. When selling via internet I am only required to charge tax for sales in Alabama. The sales tax is based on MY location... 4% State and 2% County: Total 6% If I sell to someone in Gulf Shores, Alabama, where they have a 3% city tax, I still charge only 6% because the sales originated in the State of AL, County and my business was not in the city thus I only had a 6% sales tax charge... If I had to do what u are thinking, I would have to have the sales tax rates for every little one horse town in Alabama... So the bottom line is the slaes tax rate shoudl be purely based on your business location.... SteveRF Always check with the laws for your state. YMMV. Oklahoma DOES have you have the sales tax rate for every little one horse town, & county, in the state. VERY big pain configuring for city, county, and state taxes, all based on zip. Total of several hundred different taxing zones. I don't figure I will be having that much sales volume for OK and am looking for a way to disallow shippments withing state just to bypass this issue. Any ideas on how to do this are welcome. Sterling (a.k.a. DailyLunatic) Useful Threads: Basics for Design. Useful URL's: Knowledge Base, SQL Tutorial, My Setup: Master Products v1.2, Need help installing Bundled Products v1.4. Link to comment Share on other sites More sharing options...
DailyLunatic Posted March 7, 2007 Share Posted March 7, 2007 I have a file that lists the taxes by state, county, and local with zip codes. This is how the tax table looks: Postalcode Stateprov Stateprovtax City Citytax County Countytax Districttax Salestax 90001 CA 0.0625 FIRESTONE PARK 0 LOS ANGELES 0.01 0.01 0.0825 90001 CA 0.0625 FLORENCE 0 LOS ANGELES 0.01 0.01 0.0825 90001 CA 0.0625 LOS ANGELES 0 LOS ANGELES 0.01 0.01 0.0825 90002 CA 0.0625 LOS ANGELES 0 LOS ANGELES 0.01 0.01 0.0825 90002 CA 0.0625 WATTS 0 LOS ANGELES 0.01 0.01 0.0825 90265 CA 0.0625 TWAIN HARTE 0 VENTURA 0.01 0 0.0725 How can I get OSCommerce to integrate this into the tax table where it looks up the zip code and city and to get the final sales tax(i. e. .0825) as some zip codes, as you can see, have a differant sales tax. Try this Its for FL, but with some tweeking you should be able to make it work. I'm about to sit down and do the same thing for OK. Sterling (a.k.a. DailyLunatic) Useful Threads: Basics for Design. Useful URL's: Knowledge Base, SQL Tutorial, My Setup: Master Products v1.2, Need help installing Bundled Products v1.4. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.