Calculate tax only by country and state/province ( do not include zip codes)

I need to calculate tax base on country and state/province only. Tax will be calculated only for US (CT only) and Canada (couple province).

1. One option is to add all zip codes for US/CT and Canada/Provinces.I know this is a very time comsuming process as each state can have 1000's of zip codes. Store all zip codes one by one along with the tax rate.

Anybody has a list of zip codes for US and Canada(provinces)

2. Second is make changes (exclude zip codes) in the code behind.

Hoping someone has a work around I can borrow for this.

Thanks.

Using Tax.CountryStateZip, you can select the country & state, and use wildcard (*) to capture all ZIP. Does that not work for you? :)

Sorry. Can you explain more  about use wildcard (*) to capture all ZIP? Where can I use wildcard(*)?

I can add data to TaxRate table as:

CountryID  StatProvince Zip Percentage
1          11                6.35            for only US/CT (one state)
2          65                7.25            for Canada/Manitoba
2          66                6.95            for Canada/New Brunswick


6.35 apply for all zip codes in US/CT state.
7.25 apply for all zip codes in Canada/Manitoba province.

Just leave ZIP empty.

Leave Zip field empty in the table. IS it right?

Do I need to make any changes in the code behind?


Thanks.

As far as I know, nope. You don't need to do anything with the code. :)

Thanks a lot! I will try it.