Local Sales Tax Mod - Support Thread

That was the file! I guess I missed it (my eyes did start crossing at a certain point.) It's installed, as I said, but I don't know how to integrate it.
Not being very SQL literate, I'm learning an awful lot these last couple of days. If you can tell me what I'm missing, I would greatly appreciate it.
And thanks for pointing me to that file. I did searches, advanced searches, manual searches, and it just didn't come up!

• Russ

Russ,
The the admin under tools is an option called install sql patches.
You can either copy and paste the contents of that file into the text box or you can upload the file there to be run.

A few things before you do this.
Do a back up of you database first. That file is somewhat old and I do not know how current it is or if the structure is compatible with the current version of the mod.

You might want to try contacting the origional author to see if they have a current file they might be will to share with you instead of trying to work with a file that is quite old.

Good Luck!
LadyHLG

Hi,
I ended up just re-doing the whole tax thing - it went to 4 pages. I posted this in the forum, but didn't get any replies. Perhaps you could advise me on the correct procedure? Thanks - btw, the add-on works perfectly!

======================

I'm using LadyHLG's Local Tax add-on. I just spent a considerable amount of time entering in the NY State sales tax, divided by county (ordered by zip codes with the message "xxx county & NYS Sales Tax).

It was a horrible boring nasty bit of work and I don't want anyone else to have to go through it. How can I share my work so other people can use it?

Hi,

I am using Zen Cart v1.3.8a/v1.3.8

does the LadyHLG module still work or do I not need it with this version?

if I do where can I find the 2.2 version?

Thanks.

Russ,
If you like to you can offer your sql download here in this thread, its where most people do, or I guess you could submit it to the downloads section of this site. At least that way the sql could be easily found and people wouldn't have to guess as to how old it is or its compatibility.
Let me know if you need help with this and thank-you for the contribution!

webman1,
The Local Sales Tax Mod works with version v1.3.8a/v1.3.8.
You can download version 2.3 and 2.2 HERE.

LadyHLG

Thanks - I hate to say it, but I do need help with that. How do I best export it so that it can be used by someone else without issue? I'm not even sure how it works - that is, will it automatically get put into the right table on a different database?
My table (for your add-on) is tax_rates_local, which I renamed from zen_tax_rates_local. No idea why it added "zen_" to the name, as there was no other table by that name.
Anyway, your help is, as always, greatly appreciated!

• Russ

LadyHLG:

webman1,
The Local Sales Tax Mod works with version v1.3.8a/v1.3.8.
You can download version 2.3 and 2.2 HERE.

LadyHLG

Great. I have it installed but need to know what you mean by suburb is that county? I see no dropdown for that n the customer fields.

thanks again.

Using zen cart 1.3.8a. Want to use local sales tax module. current download v. 2.3 is upgrade to v. 2.2. Told to load v. 2.2 first but can not find where to download original v. 2.2. Any suggestions (or link to appropriate site) appreciated.

gallantwarrior,
Version 2.2 is available in the downloads where you found version 2.3. Just scroll down a bit and look for version 2.2 at the bottom of the info it says:

2.2 Download includes files for New Install and Upgrade files for version 2.0a and up.
Author: LadyHLG
Version: 2.2
Zen Cart™ Version: v1.3.8
Update added on Oct 09 2008
Download Now!
File size: 30231 bytes

webman1,
The "suburb" field is the second address field in the customer address info. In the past, some people have set that up to use as a county field, but it is not used as that by default.

Russ,
You need to export the entire table and data into an sql file using whatever sql interface you prefer. (I use a program called SQLyog).

The "zen_" is a table prefix, some people use them, some do not, but when exporting for others to use you do not want it on there, so the table name should just be "tax_rates_local".
Does that help?

LadyHLG

LadyHLG:

webman1,
The "suburb" field is the second address field in the customer address info. In the past, some people have set that up to use as a county field, but it is not used as that by default.
LadyHLG

so what do you suggest for NY? is there a way to add a field or change that second address field name?

thanks again.

webman1,
You can change that field but it requires a bit of hacking to accomplish.
I would need to know more about the tax rules for NY before I can make a specific recommendation as to how to set things up.

LadyHLG

LadyHLG:

webman1,
You can change that field but it requires a bit of hacking to accomplish.
I would need to know more about the tax rules for NY before I can make a specific recommendation as to how to set things up.

LadyHLG

there are taxed by county. so when you ship to that county you have to charge sales tax for that county. I have a list of the counties and tax rates.

what page should I hack?

thanks again.

webman1,
I'm afraid I dont know specifically which pages will require hacking to make that into a county field. You could try doing a search through the forums for this, its been a while since I saw anything about it.

As an alternative, you may want to look into the option of setting up counties as zones instead of hacking the pages.
There are directions in the readme file for the Local Sales Tax mod on how do set up each county as a zone.

LadyHLG

I edited the english.php file and it seems to be working. I'll let you know my progress if it does not kill me.:smile:

Florida County Surtax Rates by Zipcode 2009

The attached zip contains a plain text file with a current list of Florida county surtax rates broken down by zipcode. It's already formatted for use with the Local Sales Tax Mod 2.3. I've been testing it for about a month with no problems. Hope this saves someone some time.

Please Note:

-Florida counties and zipcodes aren't contiguous; i.e., hundreds of zipcodes span 2 or even 3 counties. In these instances, the list assigns the zipcode to the county containing the greater population (for that zipcode). If a buyer says they've been charged an incorrect surtax, don't assume they're wrong; do a little investigating with google maps.

-The list is current through December 2009. Several county surtax rates are supposed to change in 2010.

I'm attaching the NY State local tax database, compatible with LadyHLG's Local Sales Tax add-on. It is current as of 8/25/09, and includes the MTA surcharge for applicable areas.

Installation: make sure you have the add-on enabled in "Modules - Order Total". Use "Locations/Taxes - Zone Definitions " to enable NY as a zone. Don't forget to double click on the little folder to the left and configure it for United States. If you have a red dot next to the name, you didn't do that step and it actually tells you that it's not configured.

YOU ARE NOT GOING TO CONFIGURE A TAX RATE. If you've done this right, you should have a yellow dot next to the name.

Use Tools - Install Sql Patches to install my database.

Troubleshooting:

If you don't see anything after this in "locations - Local Sales Taxes", there may be confusion about the table name. Go into your database using whatever your provider offers (MyPHP, etc.) and take a look at the tables in the database. You may have a table called "zen_tax_rate_local." BUT, you may ALSO have a table called "zen_zen_tax_rate_local"! If so, you need to check the zen_tax_rate_local and see if it actually contains anything. You can tell because if it's empty, it won't let you click on the "browse" button. If that's the case, here's what you do:

delete the zen_tax_rate_local table by clicking on it, then click on the Drop tab that's furthest to the right. If you don't see a "Drop" tab, you didn't click on the actual table name, so do that now.

Now, click on the zen_zen_tax_rate_local table, and click on the operations tab. Rename the table to zen_tax_rate_local. Bada bing! Now the rates should appear. :clap:

The local tax module is working GREAT, but I wanted to add a discount to one of my products (6 for $5, instead of $1 each). Since I couldn't get it to work using the built-in stuff, I used the add-on discount module:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_61&products_id=235

While that works, the tax is calculated based on the original total - not the discounted total. I tried changing the priorities of the discount and tax, but no matter how I set them, it still gave the wrong amount. If anyone has any suggestions, I would greatly appreciate it!

Russ-
Discounting and Local taxes have been a problem for a while.
The issue is because of tax classes. Because the Local Tax Mod is set up to calculate tax based on tax classes, a subtotal is determined for all items in whatever specific tax class the local tax is applied to. Then the local tax is based on that subtotal.
If a discount is applied to the cart total the mod has no way of knowing how much of that discount is applied to each tax class.

I'm sure there must be a way to do this, I just haven't been able to figure it out yet.

LadyHLG

Hello LadyHLG

Thank you for this mod, I couldnt try it yet, I need to make sure it will solve my problem

I have a shop that will launch soon but the checkout does not count taxes

also when a customer is not logged in, he sees the right price (including taxes) when she is logged in, she sees prices without taxes (I dont want that)

Do you have any idea how to solve this please and if the mod will fix it? (I dont want to complicate the problem if I install another mod)

I appreciate your kind help

joudesign,
This sounds like an issue with your default cart settings. The mod wont take care of this so you will need to find the right settings in the admin. I would suggest posting and searching in the General Questions forum for some assistance, hopefully someone there will be able to point you in the right direction as to where the setting are that are causing problems.
Be prepared to give as detailed a description of what is happening as you can.

Good Luck!
LadyHLG