ColdFusion question - calculating sales tax
Posted on 2006-07-10
I am using Cartweaver shopping cart for ColdFusion. Cartweaver does not have an option for the below question as far as I can tell, so I'm wondering how i can get this done with custom code. (I'm *slightly* under pressure!!)
The company I work for is in Texas. I just found out (with 99% of the website done) that we don't charge a flat Texas sales tax. Normally, if you are in Texas and buy something in Texas, you are charged the flat Texas sales tax.
My company bases it's sales tax on the final destination of the product. We have 5 warehouses in 5 different states. If an item is being *shipped* to anyone living in one of those 5 states (even if someone out of state purchased it), the purchaser's tax is based on the local rates in that state.
Our warehouses are located in New Jersey, Texas, California, Nevada, and Tennessee. So if someone in Oklahoma buys an item but has it shipped to New Jersey, he/she will be charged the New Jersey tax. If they live in Oklahoma and the item is shipped to Oklahoma, there is no sales tax.
Question 1: is there a way to code tax based on the shipping address (or zip code maybe?)
Question 2: California (and I think Nevada) charge city tax instead of state, which means I'd need to enter 100s of different tax percentages for that. I assume if I can find the code, I can just modify the percentage rate.