Hi Lisa,


Thanks for posting in more than one thread, I had unsubscribed from this thread a while ago. I didn't really know if my little contribution was useful to anyone or not. I'm glad someone has benefitted. And sorry about the link. I don't know when I deleted it from the server. I figured it was so old that it probably wasn't useful to anyone at this point.

Before I begin the meat of this post, please let me just give thanks to LadyHLG and the many others who know a lot more about mods, php, and programming than I. None of this would be possible without the heavy lifting from the real programmers.

But I'd also like to be blunt: please understand that I am not an expert with this stuff.
I am trying to help out and am posting what I can. But I offer no guarantees.
Always make sure to do proper backups before playing around with your database.
And as I stated earlier, I am not really interested in posting updates every three months. If someone else would like to adopt my methods (and hopefully clean them up a bit) and offer regular updates, please feel free to do so. The updates aren't especially difficult; I am just not in a position to take on that responsibility.

For the sake of clarity, I would also like to say that I don't consider this to be an ideal solution to the WA state sales tax. It would be much better to have a real-time lookup tool much like a shipping rate lookup. So for anyone who might know of a working mod for this, please post your information on this thread: Washington State Destination Sales Tax API
http://www.zen-cart.com/forum/showthread.php?t=102788

Ok, sorry for the verbosity.
It was good timing to post right now. The end of the quarter is upon us, and that means some new tax rates. I don't have the new ones done yet. (I'm always a few days behind on it.)

First, I have restored the link to my previous tax rate upload.
http://www.fashionpatterns.com/downl...tes_090410.zip
But like I said, probably not that useful because it's out of date. It's just an sql file that can (hopefully) be easily imported into the your database.

Second, here's a link to my most current tax_rates_local sql file:
http://www.fashionpatterns.com/downl...tes_100403.zip
Same sort of thing as before. It's just an export of my current table. I have not attempted to re-import it from this sql file. So please be careful and do your backups if you're going to play around with this.

Third, I have attached my personal instructions for doctoring the csv data from the WA DOR.
These instructions are attached directly to this post. (It's small enough to be attached, so I don't have to provide my own link to it.)
excel instructions for WA tax data.pdf
Please keep in mind that these are just my own personal notes to help me update the data each quarter. There may certainly be easier ways to do things. I can also not guarantee these instructions to be error free. But they work pretty well for me.

Fourth, here are the links to my previous post and attachment for uploading the data using MS Access:
http://www.zen-cart.com/forum/showth...078#post727078
http://www.zen-cart.com/forum/attach...2&d=1242085524
Just so everyone knows, importing the data using this method requires a very long time (at least it does for me). Importing an sql file is much quicker and easier. I just don't have a good procedure / tools for converting the data to sql before importing. So there is plenty of room for improvement.

Fifth, I have uploaded my excel sheet from this last quarter – prior to import:
http://www.fashionpatterns.com/downl...ort_100403.zip
As you will notice, it is much larger than the sql file. I have provided it so that you can have a good example of what the data from the WA DOR looks like after I've finished doctoring it.

Since the timing is so close, I will go ahead and post my quarter 3 files after I've finished them.

Hope this helps!
Please let me know how it works out for you.

-Jason