in

dashCommerce

An ASP.NET Open Source e-Commerce Application

Region Code Tax Provider Question

Last post 08-19-2008 11:40 PM by Clint. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 08-18-2008 11:52 AM

    Region Code Tax Provider Question

    So... I cannot find any documentation on this subject, but it SEEMS as if it might fit the bill.  In most states in the USA you only have to charge your local sales tax if you are shipping to a customer within your state.  Thus we only need to add shipping for Utah at a rate of 6.6%.  However I put the Region Code in as UT and the rate and it doesnt work.  Exactly what IS the Region Code field... is it zip/postal code?

     

    Thanks

    Corey

  • 08-19-2008 9:21 PM In reply to

    • Clint
    • Top 500 Contributor
    • Joined on 08-13-2008
    • Posts 4

    Re: Region Code Tax Provider Question

    Hi Corey,

    From what I can tell, the region code is referring to the zip code. I entered 38111 in the settings and then used it in the billing/shipping information at checkout, and the tax reflected an amount other than 0.

    I agree with you. This should be something you can setup by state, not just b zip code. What is it, a thousand or so zip codes just for the state of Tennessee? I'm not going to enter all that.

    Or, you can pay the $100 for a year subscription to the dashCommerce tax provider web service.

    http://www.dashcommerce.com/Product-Mettle-Systems-dashCommerce-Tax-Web-Service_3.aspx 

    If I have some time, I'm going to see if I can create my own "provider" that will allow me to set it by state.

    Filed under:
  • 08-19-2008 9:42 PM In reply to

    Re: Region Code Tax Provider Question

    Yes it does refer to the zipcode, but it doesnt seem to work all the time.  I was actually able to modify that to the state, but again it doesnt work all the time.  I am still trying to figure that one out.  I setup the system to make the user login for checkout but I still do not get tax. 

  • 08-19-2008 10:23 PM In reply to

    • Clint
    • Top 500 Contributor
    • Joined on 08-13-2008
    • Posts 4

    Re: Region Code Tax Provider Question

    Answer

    Hey Corey,

    I'm not sure what's going on on your end. I'm not experiencing the same thing.

    I found a listing of all the ZIP codes in Tennessee and created a SQL script that inserted a record for every zip code with a tax amount of 0.0925.

    Assuming you needed to do something like this for Utah, I created you a file to do the same for you: 0.0660 for each zip in Utah.

    Here you go:
    www.clintbray.com/clients/Corey10e/UT_taxCodesForCorey_01.txt 

    Hope this helps.

    Enjoy,

    Clint

     

  • 08-19-2008 11:14 PM In reply to

    Re: Region Code Tax Provider Question

    Okay been troubleshooting.  That file I think solved my problems at one point... 

    Okay.... Thanks for the file I do appreciate that... do you have one for IL too?    Anyway it ONLY calculates the tax after you enter a credit card number etc... it doesnt do it on the cart.aspx page even if you are logged in.  I think personally it should be calculating the tax there if you are logged in... if not then it should display a message that they need to login to calculate or something to that affect.

     Corey

  • 08-19-2008 11:40 PM In reply to

    • Clint
    • Top 500 Contributor
    • Joined on 08-13-2008
    • Posts 4

    Re: Region Code Tax Provider Question

    Here's one for IL:

    www.clintbray.com/clients/Corey10e/IL_taxCodesForCorey_01.txt 

    I assume the sales tax in IL is 6.6 as well. If not, do a search and replace in the file before you execute it in SQL.

    I'm only offering payment via PayPal and I'm not requiring the end user to register/login to my site. So, again, I'm not going to have the same thing going on as you.

    Hope you can get it figured out.

    Cheers,

    Clint

Page 1 of 1 (6 items)