Local Sales Tax Mod - Support Thread

I do have the configuration set to Shipping...

I hope I understand this module correctly, I set the local tax rates so that I have the ability to charge additional tax based on City, Zip or suburb.
The state of KS I can get an excel sheet of all the cities and the tax rate (this includes the state sales tax too). So I just want to be able to dump the City and Tax value into the database so that when a person orders something, it pulls their local tax rate and charges them that tax.

If this is how this works, I wonder if I have a bad file? It's as if the script continues to loop through the database and is pulling and displaying every tax in the local tax database. KS has 798 cities, so I'm getting a list of 798 cities and a tax value at checkout. Once you reach the city that the person is shipping to, from that city on the same value is displayed and totaled for the total tax which ends up being astronomical.

I DL the script from the zencart website and didn't alter it in any way but that's how it's reacting.

any addiitonal help would be great

thanks!

CMJohn

I cant say for sure what would be causing the results you are seeing without knowing exactly how the file was set up, can you send me or show me where you got the file?

LadyHLG

Thanks so much for this Mod--I can't wait to use it!

I have just downloaded & installed it but the link to add the taxes isn't under Locations/Taxes --> Local Sales Taxes.


Any tips? I tried searching the forums but couldn't find anything that specifically addressed this.

I have Zen Cart 1.3.9d (from v1.3.8 install).

KathyM,
Generally speaking, if the link isn't showing then some of the files are not in the right place.
Have you renamed your admin folder? If so did you remember to account for that when you were uploading the files? The mod admin folder would still be called admin so you would need to either manually move those files over or rename the admin folder in the mod to match whatever you renamed your admin to.

Hope that make sense
LadyHLG

Quote:

---

supersnow,
If the tax has suddenly stopped showing up I guess the obvious first question is have you made any recent changes that might be causing problems?

---

As a test I rolled back to the version when local taxes was working and now it isn't working again. So I can't figure it out. With the version of the store when I had just installed the files that you sent me now is not showing the local taxes. I just can't figure it out!

It just doesn't show at all no matter if the person is exempt or not.

LadyHLG--D'oh... thank you for your fast & accurate reply! Fixed and now it shows up. :)

Clearly it's been too long since I last tried to get my cart up and running...

Quote:

---

Originally Posted by supersnow

As a test I rolled back to the version when local taxes was working and now it isn't working again. So I can't figure it out. With the version of the store when I had just installed the files that you sent me now is not showing the local taxes. I just can't figure it out!

It just doesn't show at all no matter if the person is exempt or not.

---

supersnow,
If nothing is still showing up even after the roll back, then I am at a loss. I guess my suggestion would be to re-upload all the tax mod files and start fresh. As I haven't heard of any similar issues from anyone else, I have to assume there is something in your set up that is causing things.

LadyHLG

hi,

does this mod also generate a sales tax report that separates taxed sales from non taxed sales?

thanks.

Quote:

---

Originally Posted by gsdcypher

hi,

does this mod also generate a sales tax report that separates taxed sales from non taxed sales?

thanks.

---

Sorry, no it does not. I did have another mod to summarize some of this but I have not updated it recently so I have no idea if it works with the newer version of zen. If you want to try it out its in the downloads section, you can search for sales tax report. There may also be other addon that will do what you want.

LadyHLG

thanks for the quick reply! i will give this a try and look for the others.

Lady HLG,
Thank you for your work on this mod.

I just installed it but the taxes aren't showing up in checkout, all that is there is a : (as in Tax : %).

I have verified that I have my zone and zone definition correctly set for US, CA.

The tax class is correctly set for Taxable Goods (which all of my products are).

There are no problems entering data into the mod; all of the files were correctly uploaded.

When I turn on debugging, nothing different happens. It seems as though the db table just isn't being read. I installed the SQL patch directly via phpmyadmin and have double-checked that all the data I'm entering via ZenCart is being inputted correctly.

It's just not getting back to ZC. I even tested adding it to a tax rate entered into ZC tax; that rate showed and was added correctly into the checkout total, but not the mod rate.

I've also verified that, in my test sales, I typed each city (which I'm doing my taxes by) exactly how I entered it in.

I'm running ZC 1.3.9h.

If you could offer some help, I would appreciate it. I looked through this thread and didn't seem to find this problem (but I might have overlooked it through bleary eyes :\

Thanks!!

wendyandmilo,
There are a few other setting that can effect how the mod behaves. Check you settings for how taxes are displayed (There is a new setting for combining or splitting taxes) I believe these are under Configuration -> My Store.
Also, have you checked your sort order for the mod?

Have a look and let us know if any of these setting resolve your issue.

Good Luck

LadyHLG

I'm trying to get this to work correctly, but having some trouble. I've got it set to apply taxes based upon zip codes. There are 12 different tax rates. Under Locations/Taxes>Local Sales Taxes I've got all 12 set-up. Tax Zone is California, Apply to is postcode, Look for is the zip codes, Tax Rate is set (each is different), Tax Description is Local Tax, Tax Shipping is false and Tax Class is Taxable Goods.

The problem is that it's charging all 12 taxes to the item, not just the one based upon the shipping zip code.

Thanks!

Lady HLG,
Nothing is working.
Like you asked, I verified that the taxes are set to show up. I couldn't find where there was the option of splitting or combined so I'm not sure about that.

I've also changed the mod order several time, and nothing works.

I'm really at a loss.

wendyandmilo,
Look under Configuration -> My Store and tell me what you have for the following:
Tax Decimal Places
Basis of Product Tax Shipping
Basis of Shipping Tax Shipping
Sales Tax Display Status
Show Split Tax Lines



jeking,
Need more information, what version of the cart are you on, what version of the mod do you have? Have you tried turning on debugging? What does it show you?

LadyHLG

Thanks LadyHLG,

Zen is v1.3.9h and the mod is 2.5

I have turned on debugging and it shows all the tax rates being applied. :-)

It's a test site but the url is zenbug.blissfulwebdesigns DOT com/index.php?main_page=index&cPath=71 Maybe seeing is better than me explaining.

Thanks!

Lady HLG,
Here is My Store -> Config. I do not have an option for split tax lines. Is that another mod that I need?

Perhaps I just need to revert to a non-sales tax mod version, and re-install?

LadyHLG,

Ok so finally had some time to work this issue regarding the local taxes and the customer tax exempt and why it was working and now no local taxes show for any customer.

So on my test site I reinstalled the local taxes module without any local tax modified files for the tax exempt files. And the local taxes appear again and worked for all customers. The tax exempt customers shows the local taxes but not the normal states taxes as I thought would happen. And the normal customers showed the correct local and correct state tax.

So now the problem is to get the local taxes not to show with the tax exempt set to ALL.

Then I uploaded the two files you gave me to work with the tax exempt from the extra functions folder and the order total folder. Then the local taxes disappear from all customers again.

So I think something is not working with the check_exempt_mod() in functions_local_taxes.php:

Code:

---

//check for exempt mod
 
 function check_exempt_mod(){
 // get customer exempt status
  global $db;
 
  if ($_SESSION['customer_id']) {
        $customers_id = $_SESSION['customer_id'];
        $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    }
    if ($customer_check->fields['customers_tax_exempt'] = "ALL") {
        return false;
        }else{
        return true;
    }
   
 
 }

---

I really would love for this to work. Thanks again for such a great mod!

Also noticed something else. If a customer is in the state but NOT in the local tax zip code, the local zipcode shows up but with a $0 in the order total.

But if the customer is out of the state then no stat tax shows and no local sales tax shows.

Not sure why that is showing for the in state customer even though they are not in the county /zipcode that I need collect the extra tax for? I know that is not charging them as it is a $0 amount but it shouldn't even be showing that line - should it?

Quote:

---

Originally Posted by LadyHLG

Hi Debra,
I only recently found out about the Tax Cloud myself. I haven't had the time to investigate it much, but it looks very promising. I too had looked at Avalara quite some time ago, but the cost was ridiculous for a small business. I can only hope that Tax Cloud remains free or low cost otherwise it will be just like Avalara.
Ultimately, it would be nice if my mod became obsolete and everyone could move over to the Tax Cloud method.
My suggestion is to really take a look through their site and maybe set up a test site and try out the mod and see how it works.

If you do, drop us a note and let us know how it goes.

Good Luck,

LadyHLG

---

Hi, Lady HLG,

I've been talking to TaxCloud. They will figure the sales tax for any of the 13,000 taxing jurisdictions. They will collect and remit to the states only in the 24 streamlined states for free. Those states are set up to foot the remittance fee.They say that there are 4 more states with bills in legislature at this time. Since we are in one of the 24 states that they remit to we might just go that direction. But I sure have learned a lot from this thread. Thank you.

I'll keep in touch.

DebraM.

Quote:

---

Originally Posted by supersnow

Also noticed something else. If a customer is in the state but NOT in the local tax zip code, the local zipcode shows up but with a $0 in the order total.

---

Hello SuperSnow and jeking and LadyHLG:

I am able to reproduce the "display issues" mentioned by SuperSnow and jeking on version 1.3.9h and Local Sales Mod 2.5.

Better yet, there is a code fix of this display issue as described linked here.

The issue is really really difficult to describe in text or email. The above link with pictures really makes it clear.

To reproduce the problem, you can configure the setting as shown linked here.

Hopeful, the code fix can be incorporated into the next version of Local Sales Tax Mod? I do find the Local Sales Tax mod to be quite useful.

Hey Lady thanks for the awesome Mod. I have everything set up for WI and the tax is working but in the shopping cart the tax is being displayed 3 times. I am attaching a screenshot so you can see what I am talking about. Any suggestions on how to have only 1 show. Not sure what is going on?

Quote:

---

Originally Posted by bradg120177

Hey Lady thanks for the awesome Mod. I have everything set up for WI and the tax is working but in the shopping cart the tax is being displayed 3 times. I am attaching a screenshot so you can see what I am talking about. Any suggestions on how to have only 1 show. Not sure what is going on?

---

What you're seeing is the result of the bug in the mod explained in the post above yours.

Quote:

---

Originally Posted by bradg120177

... the tax is working but in the shopping cart the tax is being displayed 3 times. I am attaching a screenshot so you can see what I am talking about. Any suggestions on how to have only 1 show. Not sure what is going on?

---

Here is the link to fix of the display issue with local taxes. Hope that helps.

Thanks Guys I applied the changes and that fixed it!!!

Quote:

---

Originally Posted by artcoder

Hello SuperSnow and jeking and LadyHLG:

I am able to reproduce the "display issues" mentioned by SuperSnow and jeking on version 1.3.9h and Local Sales Mod 2.5.

Better yet, there is a code fix of this display issue as described linked here.

The issue is really really difficult to describe in text or email. The above link with pictures really makes it clear.

To reproduce the problem, you can configure the setting as shown linked here.

Hopeful, the code fix can be incorporated into the next version of Local Sales Tax Mod? I do find the Local Sales Tax mod to be quite useful.

---

Thanks this fixed the issue of the $0 local tax showing up for outside the local tax area on the payment page.

Quote:

---

Originally Posted by supersnow

LadyHLG,

Ok so finally had some time to work this issue regarding the local taxes and the customer tax exempt and why it was working and now no local taxes show for any customer.

So on my test site I reinstalled the local taxes module without any local tax modified files for the tax exempt files. And the local taxes appear again and worked for all customers. The tax exempt customers shows the local taxes but not the normal states taxes as I thought would happen. And the normal customers showed the correct local and correct state tax.

So now the problem is to get the local taxes not to show with the tax exempt set to ALL.

Then I uploaded the two files you gave me to work with the tax exempt from the extra functions folder and the order total folder. Then the local taxes disappear from all customers again.

So I think something is not working with the check_exempt_mod() in functions_local_taxes.php:

Code:

---

//check for exempt mod
 
 function check_exempt_mod(){
 // get customer exempt status
  global $db;
 
  if ($_SESSION['customer_id']) {
        $customers_id = $_SESSION['customer_id'];
        $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    }
    if ($customer_check->fields['customers_tax_exempt'] = "ALL") {
        return false;
        }else{
        return true;
    }
   
 
 }

---

I really would love for this to work. Thanks again for such a great mod!

---

Has anyone got any ideas why this is not working with tax exempt. The state tax is showing up as $0 but the local tax is still get calculated and added to the total even when they are tax exempt is set to ALL.

supersnow, artcoder and everyone,
I apologize for my absence! I haven't been ignoring you all, I just haven't received a single email notification (until this morning) of the discussions going on here!:ohmy:

Artcoder - thank-you for the bug fix!! I will get those into the mod and post an update as soon as I am able.:clap:

supersnow - Let me look into your exemption problems and see if I can figure this out.

DebraM - Would certainly like to know how TaxCloud works out for you...it looks like it could be an easier alternative to setting up all the taxes, the only problem I can see is that you can not use coupons with it yet..but I think they are working on that.

Again, everyone I am sorry if it seemed I had disappeared!

LadyHLG

Quote:

---

Originally Posted by artcoder

Hello SuperSnow and jeking and LadyHLG:

I am able to reproduce the "display issues" mentioned by SuperSnow and jeking on version 1.3.9h and Local Sales Mod 2.5.

Better yet, there is a code fix of this display issue as described linked here.

The issue is really really difficult to describe in text or email. The above link with pictures really makes it clear.

To reproduce the problem, you can configure the setting as shown linked here.

Hopeful, the code fix can be incorporated into the next version of Local Sales Tax Mod? I do find the Local Sales Tax mod to be quite useful.

---

You wouldn't happen to have a how to fix for v2.4 I can't upgrade to v2.5 until I bring my site from 1.3.8a to the current version. I'm sure there are others in my boat (currently on 2.4) that would like to display the local sales tax a bit more "cleanly". Thanks in advance!

jasmel,
The display issues were only with version 2.5 and zen 1.3.9.
If you are still using zen 1.3.8 then you should still be using version 2.4 of the mod.

LadyHLG

supersnow,
Can you try this update to see it this takes care of your problems:
in functions_local_taxes.php
change line 25 from

Code:

---

        if ($customer_check->fields['customers_tax_exempt'] = "ALL") {

---

to

Code:

---

if (strtoupper($customer_check->fields['customers_tax_exempt']) == "ALL") {

---

LadyHLG

Quote:

---

Originally Posted by artcoder

Hello SuperSnow and jeking and LadyHLG:

I am able to reproduce the "display issues" mentioned by SuperSnow and jeking on version 1.3.9h and Local Sales Mod 2.5.

Better yet, there is a code fix of this display issue as described linked here.

The issue is really really difficult to describe in text or email. The above link with pictures really makes it clear.

To reproduce the problem, you can configure the setting as shown linked heresears.

Hopeful, the code fix can be incorporated into the next version of Local Sales Tax Mod? I do find the Local Sales Tax mod to be quite useful.

---

Thanks for it.
I appreciate it.

Here's the Florida county sales tax rates for 2011 by zipcode. Changes for this year:

Alachua county: dropped from 6.75% to 6.25%

Bay county: raised from 6% to 6.5%

Palm Beach county: dropped from 6.5% to 6%

I'm having a hard time getting this mod to calculate correctly. I've got Zen Cart 1.3.9h and local sales tax mod 2.5. I've got two zones defined for Arkansas, one is the state sales tax, and the other is the state's grocery tax rate. When the local sales tax mod is turned off, everything computes as it should. When I add in the local taxes, and set it to search the zip codes the calculations get off. I've attached a screenshot showing the debugging output on the checkout page. I've also tried the fix that's mentioned above about the display error, but it doesn't fix the problem either. It removes all but one of the local taxes (should be a "taxable good" tax and a grocery tax), and the calculation is still off. The order total doesn't match up to the subtotal + shipping + taxes. I'm using the flat rate shipping module and it's supposed to add tax for shipping too, but it's not doing it. I also tried it with a couple of other shipping modules, but no luck. I've also deleted and reinstalled the local sales tax table, but it didn't change anything.

[SCR]http://www.thespringsprouts.com/checkoutpage.jpg[/SCR]

Discombobulationist,
I think perhaps you need to explain your taxing structure, from the screen shot things are a bit confusing.

LadyHLG

Quote:

---

Originally Posted by LadyHLG

supersnow,
Can you try this update to see it this takes care of your problems:
in functions_local_taxes.php
change line 25 from

Code:

---

    if ($customer_check->fields['customers_tax_exempt'] = "ALL") {

---

to

Code:

---

if (strtoupper($customer_check->fields['customers_tax_exempt']) == "ALL") {

---

LadyHLG

---

Thanks for the update - sorry it took so long to see the update.

I just tried it and it still isn't working. The local tax is still calculated for exempt customers. The state sales tax shows as $0.00 but the local tax is then displayed under this with an amount.

Thanks again for your help

Hello everyone,

I think this is my first post! :smile: (Second now because I posted this as its own thread and on this because its relevant to this Mod - I hope thats OK)

I found your conversations very helpful in getting local sales tax set up on my installation. Because of this I'd like to return the favor by posting the complete dump of my tax_rate_local table.

Find it here: http://www.zen-cart.com/forum/showthread.php?t=178029
This contains all counties and cities (the ones within counties that have another rate or seperate collection) all with their own tax rate and associated zip codes.

I know that some people have said that zip codes are not exact, but this works for me. I dont think any method will ever be exact.

SCHNiKEN
www.schnikensolutions.com

I find I'm needing help after installing the mod. I have the newest version of Zen Cart and installed the sales tax mod today. I've entered all 58 local sales tax counties and entered all of the zipcodes for each county using a semicolon between each zip code.

I do not have debugging mode on and wanted to test to make sure the sales tax calculated correctly. Now when I'm in the checkout, I have rows of entries that have local sales tax of $0 and some with actual amounts. I have no idea why this is happening. I've reviewed my list of zip codes and haven't duplicated zip codes. I'm at DDandLamber.com if you want to test it out and duplicate the problem. You'll have to use a Washington State zip code 99001 or 98207 to test the tax portion.

I've also attached a screenshot jpg of the problem.

Thank you,
Amber

The update is that I read a couple of posts up on how to fix the glitch with a move of a } and adding a break to the code. Thankfully it worked perfectly!!!!

Thank you to everyone who helps support this mod and to the author of the mod! THANK YOU!

Amber

Quote:

---

Originally Posted by LadyHLG

Discombobulationist,
I think perhaps you need to explain your taxing structure, from the screen shot things are a bit confusing.

LadyHLG

---

My state, Arkansas, has two tax classes. One is for taxable goods and it is 6%. For groceries, Arkansas only charges 2%. The cities don't differentiate, so in the screenshot, you can see that Fort Smith has a 3.25% Sales Tax and Greenwood has a 3% Sales tax. All of my products are either in the Taxable Goods tax class or Grocery tax class. So, I set my zone definitions as AR Sales Tax (6%) and AR Grocery Tax (2%).
In the Local Sales Tax Mod, I set each city with a Taxable goods rate and a grocery tax rate, even though they are taxed at the same rate at the city level. In the screenshot, it correctly shows in the cart area that the toilet bowl cleaner should be taxed at 9% and the ground beef at 5%, since the delivery address is in Greenwood. The Fort Smith taxes are also showing, but I can fix that with the fix posted by artcoder. Although that fix also removes one of my local taxes (either the grocery tax or the taxable goods tax, whichever is listed first).
I set the shipping charges to be taxed at the taxable goods rate, and again it appears that the AR taxes are being computed correctly, but I can't get the local tax to add on the shipping tax too. And then when you start adding the subtotal, shipping, and taxes, it doesn't add up to the total.
Sorry if this is confusing, I'm sure I've got something configured wrong. I have tried it a few different ways, but still no luck. I set my AR zone tax rates to 0% and put my local sales taxes to 9% and 5% for Greenwood, and 9.25% and 5.25% for Fort Smith, and that didn't work either.

I see the fix you guys are proposing but the "ot_local_sales_taxes.php" isn't set up the way the fix (http://learnwebtutorials.com/how-to-...ocal-sales-tax) is showing to do. The website is http://force-test.com and I'm using 1.3.9.h

Code:

---

  'title' => $taxrec['id'] .':' ,
                'text' => $showtax,
                'value' => $total_tax);
                       
          } //end foreach tax

        } //end if local tax <> 0
       
} //end function

---

Not it the same order. I'm confused on where to put the break as well.

Just getting duplicated 0.00 in my order total and also, why do I get 2 of the same tax charges. The zips are not duplicate.

Hi, just to answer your question about TaxCloud - we do now support coupons as well as tax exemptions and PayPal Express Checkout. More info is available here: dev.taxcloud.net

Quote:

---

Originally Posted by LadyHLG

supersnow, artcoder and everyone,
I apologize for my absence! I haven't been ignoring you all, I just haven't received a single email notification (until this morning) of the discussions going on here!:ohmy:

Artcoder - thank-you for the bug fix!! I will get those into the mod and post an update as soon as I am able.:clap:

supersnow - Let me look into your exemption problems and see if I can figure this out.

DebraM - Would certainly like to know how TaxCloud works out for you...it looks like it could be an easier alternative to setting up all the taxes, the only problem I can see is that you can not use coupons with it yet..but I think they are working on that.

Again, everyone I am sorry if it seemed I had disappeared!

LadyHLG

---

Hi everyone,

I am having problems viewing the Local Sales Tax link in the drop down menu on the admin page. I uploaded the files in Catalog folder of the new install to the base directory of my store. I ran the sql and the table was created with the prefix I assigned, I verified this through phpmyadmin. Also under Modules -> Order Total the Local Sales Tax module is shown as installed and with a sort order of 301. The tax module has a sort order of 300.

I cannot seem to find the local sales tax link under Location / Taxes. I really appreciate any help I can get, should I re-install the module? Do I need to remove the files. I have gone to Modules -> Order Total and removed the module and reinstalled it on there a few times now. I am running version 1.3.9

Thank you again to anyone that may be able to help me.

-Greg

Greg,
If you are not see the menu option then its likely you are missing a file or a file was placed incorrectly.
The only way to fix that would be to go file by file through the mod and make sure everything is where it is supposed to be.

LadyHLG

Zenners,
I have been doing some testing and I believe the fix posted previously in this post is causing other problems within the mod, especially when using more than one tax class.
I have not yet figured out a fix for this but I will keep everyone posted.


LadyHLG

LadyHLG,

Thank you so much for your help. I actually solved it by reading up this awesome thread. Yeah I had forgotten to change the folder admin to my custom admin folder. Thanks again!

-Greg

Hi Everyone,

I have attached a screenshot where PayPal IPN shows "Surcharge" on the line it should say "TAX" after installing "Local Sales Tax Modules for Zen Cart 1.3.9"

I'm running 1.3.9h and I adjusted the order and everything else that would seem obvious. In fact I have the actual zen cart tax module turned off, as I did input all of the 1777 cities in California and all in their respective tax bracket so that the mod can stand on it's own.
(It would always show "Surcharge" even with the ZenCart Tax module turned on)

Does anyone have the same problem or any suggestions?....it would be greatly appreciated.

http://aquafinatic.com/Surcharges.jpg

OK, I'm trying to set up the taxes to charge 6.5% if shipping to Miami, and 6.0% if shipping to anywhere else in FL. I thought I had it, but it is adding the 6.5 to the 6.0. It should be only charging 6.5 and not the 6.0..

Can Anyone Help with this?

Thanks

Craig

Nevermind.. Just added a .5% zone if they are in Miami.. Duh

Quote:

---

Originally Posted by willy12

Hi Everyone,

I have attached a screenshot where PayPal IPN shows "Surcharge" on the line it should say "TAX" after installing "Local Sales Tax Modules for Zen Cart 1.3.9"

I'm running 1.3.9h and I adjusted the order and everything else that would seem obvious. In fact I have the actual zen cart tax module turned off, as I did input all of the 1777 cities in California and all in their respective tax bracket so that the mod can stand on it's own.
(It would always show "Surcharge" even with the ZenCart Tax module turned on)

Does anyone have the same problem or any suggestions?....it would be greatly appreciated.

http://aquafinatic.com/Surcharges.jpg

---

OK, the feeling of abandonment is setting in?.....noone?

I filled did an import from excel as an csv to the sql so that i could have separate lines for each city, hopefully easier for my client to update, and it seems to have populated the list in the same way as if I had entered in the values line by line.

when i install the module, however, I'm getting $0 as the sales tax.

I've attached an image, am i doing something wrong?http://houseofpapillon.com/localtax.png

Quote:

---

Originally Posted by willy12

Hi Everyone,

I have attached a screenshot where PayPal IPN shows "Surcharge" on the line it should say "TAX" after installing "Local Sales Tax Modules for Zen Cart 1.3.9"

I'm running 1.3.9h and I adjusted the order and everything else that would seem obvious. In fact I have the actual zen cart tax module turned off, as I did input all of the 1777 cities in California and all in their respective tax bracket so that the mod can stand on it's own.
(It would always show "Surcharge" even with the ZenCart Tax module turned on)

Does anyone have the same problem or any suggestions?....it would be greatly appreciated.

http://aquafinatic.com/Surcharges.jpg

---

I figured I'll post this issue once more.
Three is a charm, if anyone has any suggestions please advise.

Thanks

willy12
If I remember correctly the paypal surcharge shows up sometimes when something gets passed to paypal that it doesnt know what to do with it.
I havent heard of this happening before with the local tax mod, do you have any other mods installed?

LadyHLG

Hello LadyHLG,

Thanks for writing.

I have other mods installed but not related to the Taxes or checkout in any way.

When I disactivate the Tax Mod and reactivate the regular built-in Tax module PayPal does read "Tax".

When I have both tax modules on and showing in PayPal, the built-in one reads "Tax" the other module still reads "Surcharge" right underneath.
Hope it makes sense how I described it.
Please let me know your thoughts.

Thanks.

willy12,
Do you have the taxes set to show separately or combined?

LadyHLG

Quote:

---

Originally Posted by LadyHLG

willy12,
Do you have the taxes set to show separately or combined?

LadyHLG

---

Hi LadyHLG,

It is set to separate.
In fact the ZenCart built in Tax module is turned off and the "Local Sales Tax Mod" is the only one handling all the Taxes since I did input all California States.


Thank you.

Try setting it to combine and see what happens.

Quote:

---

Originally Posted by willy12

Hi LadyHLG,

It is set to separate.
In fact the ZenCart built in Tax module is turned off and the "Local Sales Tax Mod" is the only one handling all the Taxes since I did input all California States.


Thank you.

---

My shop is located in Wisconsin where sales tax is charged on shipping. I am using the local sales tax mod and have configured each sales tax id to indicate that sales tax is charged on shipping. Recently, a customer who lives in a zipcode that does NOT have an additional county or local tax purchased a product, but the site did not charge sales tax on the shipping charge. I cannot seem to find where to indicate that sales tax is charged on shipping for the base state sales tax.

Steve,
If you are applying just a regular zone tax and want to apply sales tax to shipping then you need to be sure you have configured the tax on shipping option in the Configuration -> My Store, then you need to go into the options for whatever shipping module(s) you are using and set it to add tax.

Hope that helps.

LadyHLG

Thank you very much. I was looking under the tax module, not the shipping module.

I've seen a few posts about the local tax mod repeating the tax output, but I haven't found a solution in this thread. Forgive me if I've missed something.

I'm in NY, and installed the Local Tax mod as well as the sql table that has the NY local taxes by zip code. I have a state tax zone for NY set up at 4% tax and then the local taxes are added to that 4%.

In my test order I'm shipping to zip code 12419 in Ulster County NY. What seems to be happening is that the tax module is calculating zero tax UNTIL it finds a matching Ulster Co zip code, then keeps adding the tax until it runs out of zip codes. I've attached the rather lengthy debug that shows the shopping cart subtotal and total.

I've tried setting the tax display to combined and separate, it makes no difference.

The New York state zone has a priority of zero (should it be something different?)

I've also tried changing the order of the order total modules to no avail.

gwynwyffar and all,
There was a fix posted a while back to take care of the repeating taxes issue you can read through it here ->
http://learnwebtutorials.com/how-to-...ocal-sales-tax. Did you make those changes already?

PLEASE BE AWARE, depending on your tax structure this fix can cause other problems, especially if you have multiple tax classes.

I have been working on an update to the mod to help resolve all of these issues. I will try to get it posted tonight.

LadyHLG

Yes I did attempt that fix, and then no local tax at all would show. I'll wait for your update, thanks so much for the response.

OK gwynwyffar,
Please try the update attached, just upload the new files to over write the current ones (only 2 of them).

Let me know what happens!
LadyHLG

I went into OT modules and removed the mod and then reactivated it after uploading the new files.

With debugging on, using 12419 as my test zip code and 12486 as store zip code, when I go to check out, after the shipping page, I get a white page with:

Taxing based on: Shipping
Taxing For Zone: 190
Local Store Tax For: 12486

and nothing more. It will not let me move forward with the checkout process.

With debug off, I just get a blank white page.

gwynwyffar,
Are you using the most current version of ZenCart?

LadyHLG

I'm using version 1.3.9h hosted on an Apache 2.2.19 server running PHP 5.3.6

I also tried the mod on a clean Zen Cart install, as my live install is slightly modded. The same thing happened on the clean install.

gwynwyffar,
I just sent you a PM.
LadyHLG

I would like to hear from anyone else who tries the update posted above. Please let me know if there are any problems.
I will give it a week or so and if I dont hear anything I will post it to the downloads.


LadyHLG

sorry to reask this if it has already been answered somewhere but it is hard to read through a billion pages of posts. is there a way to display the combined total of the taxes rather than each one seperate?
for example:
California Tax: $1.13
San Diego Tax: $.0.45

Becomes
Tax: $1.58

Thank you!

Quote:

---

Originally Posted by gunnzo

is there a way to display the combined total of the taxes rather than each one seperate?

---

Under Configuration, go to "My Store". Abount half way down find "Show Split tax Lines" Set this to False

Quote:

---

Originally Posted by gwynwyffar

I went into OT modules and removed the mod and then reactivated it after uploading the new files.

With debugging on, using 12419 as my test zip code and 12486 as store zip code, when I go to check out, after the shipping page, I get a white page with:

Taxing based on: Shipping
Taxing For Zone: 190
Local Store Tax For: 12486

and nothing more. It will not let me move forward with the checkout process.

With debug off, I just get a blank white page.

---

Am getting the same issue. Have 1.39h and using 'city' for delimiter on the local sales tax and 'Chicago' for the qualifier and this shows up, no matter if I select Chicago destination or Florida destination.

Cache error reads:

[12-Jul-2011 17:18:15] PHP Warning: Cannot modify header information - headers already sent by
(output started at
/home/XXXXXX/public_html/includes/modules/order_total/ot_local_sales_taxes.php:51)
in
/home/XXXXXX/public_html/includes/functions/functions_general.php on line 45

Here are some new files for you to try.
This should be all the files for the mod so upload them all and overwrite the previous files, uninstall then reinstall the mod.

Let me know what happens.

LadyHLG

Quote:

---

Originally Posted by LadyHLG

Here are some new files for you to try.
This should be all the files for the mod so upload them all and overwrite the previous files, uninstall then reinstall the mod.

LadyHLG

---

:clap: This worked. Thanks!

Using version downloaded 6/28/2011.
County and Other tax calculations affected when city tax present.

'State Sales Tax' calculates correctly
'City Sales Tax' calculates correctly
'County Sales Tax' calculates correctly if there is no city tax
'County Sales Tax'' equals city tax when there is a city tax (bad calculation)
'Other Tax' calculates correctly if there is no city tax
'Other Tax' equals city tax when there is a city tax (bad calculation)

Example 1 (outside city, but within county and RTA district):
Sub-Total: $5.99
Shipping: $3.65
2.9% State: $ 0.17
2.5% City: $ 0.00
1% County: $ 0.06
1% RTA: $ 0.06
Total: $ 9.93

Example 2 (inside city, county and RTA district):
Sub-Total: $5.99
Shipping: $3.65
2.9% State: $ 0.17
2.5% City: $ 0.15
1% County: $ 0.15 (should be $0.06)
1% RTA: $ 0.15 (should be $0.06)
Total: $10.26 (should be $10.08)

I verified tax rate table settings for city and county taxes set for 1%

How to fix please?
Ron

I decided to uninstall the Local Sales Tax Mod v.2.5 and use TaxCloud instead.

I did not find uninstall instructions in this mod, however I removed each of the files that came with the mod and then after reviewing the SQL file, used phpMyAdmin to "Drop" the 'tax_rates_local' table.

As far as I can find, this should have completely removed the mod, however my customers are seeing this warning message on checkout Step 2 Checkout Payment:
WARNING: Could not locate language file: includes/languages/english/modules/order_total/ot_local_sales_taxes.php

I used the Developer's Tool kit to search for any instance of ot_local_sales_tax.php and came up with no matches.

I currently have the following Order Total Modules installed (as listed in Admin > Moduies -> Order Total:
ot_coupon
ot_shipping
ot_subtotal
ot_tax
ot_total

Local taxes are no longer shown during checkout (as expected) and the state tax appears to be correct.

Any idea how to get rid of this warning message? Which file would generate this message?.... I can restore the original from before the add-on.

Thanks in advance.. Ron

Will this mod work on 1.3.8a? I am utilizing other mods that have not been updated to 1.3.9 yet.

Hi,

First let me say that this is a great module, and it was a relief to find it (setting up tax calculations sounded daunting at first). :smile:

I have installed the taxcloud v1.4 module on zencart v1.3.9h and it is calculating tax correctly and adding it during the checkout process. Server is running PHP 5.2.17 and I double checked the SoapClient is installed.

The problem I'm having is when you click "confirm order" on the "main_page=checkout_confirmation" page, it loads the "main_page=checkout_process" page and it only says "Setting order totals for taxcloud" at top left. That page doesn't redirect to the confirmation page, it just loads and stays. If I refresh on that page it loads the "main_page=shopping_cart" and the cart is empty.

Also, the confirmation email that gets sent for the order doesn't show any tax in the order totals, and the actual order total doesn't include the tax amount that was calculated on the checkout pages (checkout total doesn't match email confirmation total). I have tested many times with different payment/shipping methods and the result is always the same.

If more details are needed to help troubleshoot this problem please let me know. I can even set up a test account on my test site to see exactly what's happening if needed.

Quote:

---

Originally Posted by jacob.v4ll

Hi,

First let me say that this is a great module, and it was a relief to find it (setting up tax calculations sounded daunting at first). :smile:

I have installed the taxcloud v1.4 module on zencart v1.3.9h and it is calculating tax correctly and adding it during the checkout process. Server is running PHP 5.2.17 and I double checked the SoapClient is installed.

The problem I'm having is when you click "confirm order" on the "main_page=checkout_confirmation" page, it loads the "main_page=checkout_process" page and it only says "Setting order totals for taxcloud" at top left. That page doesn't redirect to the confirmation page, it just loads and stays. If I refresh on that page it loads the "main_page=shopping_cart" and the cart is empty.

Also, the confirmation email that gets sent for the order doesn't show any tax in the order totals, and the actual order total doesn't include the tax amount that was calculated on the checkout pages (checkout total doesn't match email confirmation total). I have tested many times with different payment/shipping methods and the result is always the same.

If more details are needed to help troubleshoot this problem please let me know. I can even set up a test account on my test site to see exactly what's happening if needed.

---

jacob.v4ll:
This is not a support thread for the TaxCloud add-on but rather the support thread for Local Sales Tax Mod.
I too attempted to utilize TaxCloud and found that it is not yet ready for prime time. There are several issues with the ZenCart version. The developer is very responsive to inquiries and has been working well with me to resolve issues. However, there were so many issues outstanding I finally removed the add-on and will wait until it is ready for use. Among the issues includes the replacement of one of the Paypal files which are part of the Zencart install. When you have problems with TaxCloud you cannot simply "disable" or de-install TaxCloud (although a button to enable/disable is provided) or you will break your shopping cart. The original paypal file must be restored after you disable or remove the TaxCloud add-on. This kind of interference with the Zencart files is acceptable in my opinion. The TaxCloud approach is very promising however I recommend waiting until the Zencart version is completed.

Thanks for the info ronlee. I would like to say that I disagree with your assessment of taxcloud not being production ready. With all the custom modules, and all the custom configurations out there, it's impossible to know all the variables and prevent some issues from arising.

The issue I was having was a simple code problem that I was able to fix myself with some direction from the taxcloud developer. He will be updating the module with the latest release version which will include that fix as well as some other updates soon.

I would encourage any reluctant admins out there to give the taxcloud module a try as it is a huge time saver and will ensure you are compliant with your tax regulations. If you do by chance come across any issues, be sure to post in the correct taxcloud forum and the developer is very responsive and helpful.

Thanks!
Jacob

Thanks Jacob.v4ll

Was unaware of Taxcloud support thread. Will check it out. Hopefully some of the fixes we worked out are included in the update.

Returning this forum back to Local Sales Tax Mod support

Ron

Running LTM 2.5 on 1.3.9h. I have successfully installed and used LTM on other sites with no issues. I am using a custom template with no other 3rd party modules.

On checkout, it seems that all possible taxes are being applied rather than just the correct one for zipcode.

Code:

---

Taxing based on: Shipping
Taxing For Zone: 26
Local Tax For: 67601
Total Tax =


Tax on shipping: 0.1575
Total Tax =


Tax on shipping: 0.17875
Total Tax =


Tax on shipping: 0.145
Total Tax =

---

That goes on for several dozen lines in the debug text. The same thing repeats in the actual invoice. The Sales: $1.13 thing following this repeats just as long, and the end cost being over $800 for a $15 item.

Code:

---

$1.13
Sales:

$1.13
Sales:

$832.74

---

I can supply more info if needed along with a link to the site.

Nevermind, got it working. Didn't seem like this fix applied to me on my first skim but it worked it out:
http://learnwebtutorials.com/how-to-...ocal-sales-tax

I have just followed the instructions and installed the Local Sales Tax Mod. However after installing I do not see the option I expect under Locations/Taxes => Local Taxes in the Admin interface. Please see the attached screen grab local_tax_screen.jpg. How would it be best to debug this issue?

Zencart is at 1.3.9f

Local Tax Mod is 2.5

URL is : http://www.orcasislandrowing.org/orc...ean_site/store

Thanks Martin

Never mind!
I figured it out.
The admin dir had been renamed so the code that should have been installed had not really been installed.

Martin

LadyG, are you feeling confident about the newest zip you posted? I see that you haven't uploaded it yet to the contribs section.

I'm presently working on a site that after upgrading from 1.3.9d to h, the local sales tax mod stopped working. Looks like they were using your 2.5.1 version.

My assigned task is to figure out why.

Quote:

---

Originally Posted by rolyatnitram

Never mind!
I figured it out.
The admin dir had been renamed so the code that should have been installed had not really been installed.

Martin

---

I'm having the same issue - what did you do to make it work?? - my admin directory is renamed like everyone elses - but I don't see anywhere to modify the code that applies to the admin directory

Thanks

I installed Zen Cart v. 1.3.9h, my host is ipage.com, I am using php v5. I am having a lot of trouble installing the local sales tax mod. Basically it has some folders to upload, so I did that using filezilla. Specifically, I uploaded the "includes" and the "admin" folder to the "zencart" folder. I installed the sql patch. I was able to copy and paste the text and I put a semicolon at the end of it and Zen Cart took it. In the Zen Cart admin page I go to "modules -> order total" and a module called "local sales taxes" shows up, and I installed it. The problem is, when I go to "locations/taxes" there's supposed to be a menu item called "local sales taxes" for me to edit, but there's no "local sales taxes." I've tried everything I can think of, reinstalling the sql patch, I tried installing different versions of the local sales tax mod, (versions 2.5, 2.4, 2.2 and 2.0a), and completely removing the zen cart folder and reinstalling zen cart. Nothing I try will give me that "local sales taxes" category. I've spent so much time on it and it's extremely frustrating. I configured everything else about Zen Cart the way I want it, but I can't for the life of me get this mod working. Please help.

P.S.: I also tried installing the "state sales tax lookup addon" that uses taxcloud and it has the same problem, when I go to "modules -> order total" there are taxcloud modules to install, but there are no new menu items under "locations/taxes." I don't know what the issue is.

Hello,

A client just sent me this question. Wondering if anyone else knows how to fix it?

"Also, another issue we noticed today was that the email that was sent to a customer that ordered a product did not have the sales tax included on the email. It was correct in the admin area and I’m sure when the person checked out it was correct but the emailed total was not. Do you know if we need to change anything else to get the correct total in the email?"

Will Local Sales Tax Mod v2.5 work with Zencart 1.5?

I have a test store and database set up, so I backed everything up and tried to install v2.5 on ZenCart v1.5. Local Sales Tax shows up under the Order Total module, but it does not show up under the Locations/Taxes tab. Should I assume that v2.5 does NOT work with ZenCart 1.5?

Here's the 2012 Florida discretionary tax rates by zipcode. Changes for 2012:

Alachua is now 6%, so the entire 6.25% bracket can be deleted! Go Gators!!

Liberty changed from 7% to 7.5%

Martin and Seminole county dropped to 6%

I'm about to pull my hair out! I just installed this mod and cannot get it to calculate properly. I have attached a screenshot of my checkout screen with the debug option enables. The screenshot explains it all... the local tax is not being applied to shipping (yes, the tax rate option "Apply this tax to shipping charges?" is set to True) AND my total is completely wrong. I have no idea where its getting that number from.

ANY HELP is appreciated. I really need this mod to work.

Thanks!http://www2.picturepush.com/photo/a/...mg/7419555.jpg

Quote:

---

Originally Posted by lolwaut

I'm about to pull my hair out! I just installed this mod and cannot get it to calculate properly. I have attached a screenshot of my checkout screen with the debug option enables. The screenshot explains it all... the local tax is not being applied to shipping (yes, the tax rate option "Apply this tax to shipping charges?" is set to True) AND my total is completely wrong. I have no idea where its getting that number from.

ANY HELP is appreciated. I really need this mod to work.

Thanks!

---

An update to my situation.... I finally got the order total to display correctly. it is actually adding in the shipping tax now and including it in the order total but it is still not reflected on the local tax rate line in checkout... that line only displays the tax of the subtotal.

How I fixed the order total:

i edited includes/modules/order_total/ot_local_sales_taxes.php

i edited this code:

Code:

---

                                if($apply_tax_to_shipping){
                                          $shipping_tax = zen_calculate_tax($order->info['shipping_cost'], $taxrec['tax']);
                                          $order->info['shipping_tax'] += $shipping_tax;

---

and removed the "+" sign from the last line so it reads as:

Code:

---

$order->info['shipping_tax'] = $shipping_tax;

---

i hope that + sign wasnt important... all i know is that removing it made my order total correct.

unfortunately, i still cant figure out how to get the shipping tax to be reflected in the local tax rate.

Does anyone know when and if a new mod version will come out supporting zen cart 1.5? I was just going to use taxcloud but apparently that isn't going to work on 1.5 until they update their dev. packages yet as well... bummer zen cart

FYI, there is an updated version of TaxCloud that works with v1.5.

Quote:

---

Originally Posted by gotduhka

Does anyone know when and if a new mod version will come out supporting zen cart 1.5? I was just going to use taxcloud but apparently that isn't going to work on 1.5 until they update their dev. packages yet as well... bummer zen cart

---

Quote:

---

Originally Posted by slomojojo

Here's the 2012 Florida discretionary tax rates by zipcode. Changes for 2012:

Alachua is now 6%, so the entire 6.25% bracket can be deleted! Go Gators!!

Liberty changed from 7% to 7.5%

Martin and Seminole county dropped to 6%

---

Great work, how do you report your tax based on the county the merchandise is delivered? I have broken down Florida by counties, but I am having trouble with the results. It seems to want to calculate tax on every county after the first correct one. Do you have any thoughts?

Sub-Total: $29.97
United States Postal Service (Priority Mail (2 - 3 days)): $5.20
FL-Alachua County: $0.00
FL-Baker County: $0.00
FL-Bay County: $0.00
FL-Bradford County:$0.00
FL-Brevard County:$0.00
FL-Broward County: $1.80
FL-Calhoun County: $1.80
FL-Charlotte County: $1.80
Repeats for each County Defined
….
Total: $170.00

Florida has 67 Counties, Which have various tax rates. Tax is calcualted based on the total amount of the order including shipping. Tax is to be determined and reported based on the county it is delivered to. Sales Tax Module Version 1.39, Zen Cart 1.39. I created entries for each county and associated with each county the coreesponding zip codes and tax rates. I have set the Shipping to true.

I am having trouble with the results. It seems to want to calculate tax on every county after the first correct one.The example below tax should be calcualted at 6%. In addition sales tax is not being calcualted on the Shipping.

Do You have any thought?

Sub-Total: $29.97
United States Postal Service (Priority Mail (2 - 3 days)): $5.20
FL-Alachua County: $0.00
FL-Baker County: $0.00
FL-Bay County: $0.00
FL-Bradford County:$0.00
FL-Brevard County:$0.00
FL-Broward County: $1.80
FL-Calhoun County: $1.80
FL-Charlotte County: $1.80
Repeats for each County Defined
….
Total: $170.00

After 8 hours of tweeking, I am a little closer. Tax is applied to the shipping, and appears to be in the total, However, the numbers displayed do not add up.

Taxing based on: Shipping
Taxing For Zone: 195
Local Tax For:
Confer LAPT30- $72.4:
FL-Broward County - 4.344 @ 6.00
76.744
FL-Broward CountyTotal Tax = 4.344

Tax on shipping: 1.2558

$72.40 Sub-Total:

$20.93 United Parcel Service (Ground):

$4.34 FL-Broward County: (Does Not Include Shipping)

$98.93 Tax on Shipping appears to be included)

Any Thoughts on where to go would be appreciated?

Thanks

Jack

I am new to Zen Cart, I came to it based on the need to find a local sales tax solution, which brought me here. I've installed zen cart 1.5 and attempted to install this local sales tax mod, but at the point where I'm uploading the sql file, I get a 'failed' error message at the top and nothing else.

Does this not work with 1.5? If not, will it sometime soon?

I appreciate anyone's time to respond.