Local Sales Tax Mod (with admin!) for testing

[photophile72]

I uninstal Modules ----> Order Total ----> Tax
it quits displaying the Local Sales Tax even though that is installed,Sort order 250, I turned on Debugin and it show that info but no tax total again....

[LadyHLG]

Make sure you dont have any empty zone taxes set up for the state. That could be causing the $0.00 sales tax as well.

LadyHLG

[photophile72]

Still having the same problem with Tax $0.00 Showing Up in checkout total. If we turn off Modules --> Order Total --> Tax but Leave Local Sales Tax on... No Tax shows up at all see attached screen shot. But if we turn it on then we get Two tax listings one the correct one under local sales tax and another just $0.00. I deleted all the other Zones for our state etc If it helps I reset the admin to what I sent before...

[LadyHLG]

I found it!!
It wasn't the Local Tax Mod at all, it was a cart admin setting.
The setting can be found under Configuration -> My Store -> Sales Tax Display Status

When turned on this setting displays sales tax even when its $0.00!
I have turned it off and no more $0.00 sales tax!

Mystery Solved!

LadyHLG

[berchman]

If I am dealing with a couple hundred zip codes, does anyone know a way to import the data into the DB and have is show up properly in this Mod?

Having to type one-by-one is going to take a long time.

[LadyHLG]

There is no specific set up for uploading data, but it can be done. I guess it would depend on whether or not you currently have the needed data in some type of file or database that can be used to create an upload.

LadyHLG

[berchman]

I have the data in an excel spreadsheet. I have hundreds of zip codes all with varying degrees of % above the flat state rate.

If I could import these it would save me hours and hours of input time.

Is there a standard format for the data to be imported? Meaning

zipcode | taxrate | name | (etc) ????

Once I have the excel file, where in the DB do I import?

Any help would be GREATLY appreciated.

[LadyHLG]

The fields that you need to populate are:

zone_id = zen cart zone id to apply tax to

local_fieldmatch = what field in the order table to base tax on for zip code it would be postcode

local_datamatch = actual data we are matching should relate to local_fieldmatch (ie. "Sacramento", "90001")

local_tax_rate = rate to apply

local_tax_label = Label that will appear in cart checkout

local_tax_shipping = true/false to apply specific tax to shipping

local_tax_class_id = tax class id to apply rate to


I have to admit, this is the kind of situation where I tend to get a bit lazy and pull the data into MSAccess to organize.
I might be able to help you get the data into an sql file to upload once you get it ready to go.
What state is this for?

LadyHLG

[berchman]

I am setting this up for New York.
I am working on getting every zip code with the proper percentage increase from the base state rate.

I found reference online that placed every zipcode within a specific county.

I can get this into a single excel spreadsheet with the columns you posted above.
If you could look over my file before I were to import that would he a great help.

[LadyHLG]

Have to looked at this post?
http://www.zen-cart.com/forum/showpo...&postcount=103

bushkillfarms posted his zip code sql for NY.

Just didn't want you to put time into this if this file will work for you.

LadyHLG