Tax by ZIP code instead of by State

[mrdalej]

I have a 2 week old store and I am in California and I have my store set up to tax anyone who enters CA in their address and just today a customer entered his correct City and Correct Zip but he choose a state besides CA and he did not get charged sales tax?

 

How do I force osCommerce to use zip codes instead of State or combine the two or I am very open to suggestions and thanks group;

 

dale j

[Velveeta]

I have a 2 week old store and I am in California and I have my store set up to tax anyone who enters CA in their address and just today a customer entered his correct City and Correct Zip but he choose a state besides CA and he did not get charged sales tax?

 

How do I force osCommerce to use zip codes instead of State or combine the two or I am very open to suggestions and thanks group;

 

dale j

To my knowledge, there isn't a contribution for this... I just did a quick search of the contributions area, but only looked at the first page, and didn't see anything that might fit the bill... However, this wouldn't be too hard to code... You could just make a new database table that mapped zip codes to cities and states, or just to states, and then query that table whenever they enter their zip code, and correct the state abbreviation at the same time if it's different... I found a comma-separated text file that also includes lat/lon coordinates for most zip codes, but you could just exclude that info and stuff a database table with the rest of the info, and it wouldn't be too hard to code the part that does the check and corrections... The link to that file of zip codes is here... I don't have much on my plate for tonight, so I may just write this up as a contribution myself, it seems like a pretty handy addition :)

 

Richard.

[mrdalej]

To my knowledge, there isn't a contribution for this... I just did a quick search of the contributions area, but only looked at the first page, and didn't see anything that might fit the bill... However, this wouldn't be too hard to code... You could just make a new database table that mapped zip codes to cities and states, or just to states, and then query that table whenever they enter their zip code, and correct the state abbreviation at the same time if it's different... I found a comma-separated text file that also includes lat/lon coordinates for most zip codes, but you could just exclude that info and stuff a database table with the rest of the info, and it wouldn't be too hard to code the part that does the check and corrections... The link to that file of zip codes is here... I don't have much on my plate for tonight, so I may just write this up as a contribution myself, it seems like a pretty handy addition :)

 

Richard.

Thanks you are a gentleman & a scholar. I too looked for 20 minutes before I posted my question and concluded there was no such thing.

 

Thanks again and I will check back in the early AM;

 

dale j