Local Sales Tax Mod - Support Thread

[LadyHLG]

Ok, so instead of uploading the file, open it (you can open it with any type of text editor). Copy everything in the file and paste it into the query execution box on the Install sql patches page.
If it fails again try adding a semicolon ";" at the end of the last line.

[KathyM]

Thank you so much for all the help--that did it! Off to customize!


(Ahhh memories of Pascal and the semicolon....)

[LadyHLG]

Glad things are working now.
LadyHLG

[LadyHLG]

Hello all,
I'm sorry to say we have discover a bug in the local sales tax mod. (Thanks to Daniel for bringing this to light!)
The bug occurs when a customer purchases a downloadable product or products only.

I am attaching a new file here that hopefully corrects this error, it also has more detailed debugging to help locate problems in the future.

Use the attached file to replace includes\modules\order_total\ot_local_sales_taxes.php

If anyone encounters any other issues please let me know asap, I will wait a few days before posting the new file to the downloads.

LadyHLG

[zcnb]

I am attaching a new file here that hopefully corrects this error, it also has more detailed debugging to help locate problems in the future.

LadyHLG, thank you very much for trouleshooting and fixing this problem. The speed at which you did that is impressive!

I would like to add to the existing documentation that, when listing towns/cities in the 'Search Data' edit box ("Search Field = city"), separating names by a semicolon, there must not be any leading or trailing spaces.

That is, the following list will work:

Smallville;Gotham City;Metropolis

While the following will not work for the last two in the list:

Smallville; Gotham City; Metropolis

Thank you again, LadyHLG. You have done a marvelous job.

Daniel

[LadyHLG]

Thank-you Daniel for correcting this.
Also, please note that the README.txt file in the mod is incorrect as its states:

***Version 2.2 Updates***************************************
Allow for both single zip codes and zip code ranges mixed into a single record.

This update should allow for zip code entries like:
53528;53711-to-53720;53524;54302-54310 Which mixes both the ranges and the single entries in one comma delimited list.

Updated admin to allow for larger data entries-- Thanks to sublime19 for this!!
Changed local_datamatch field to text to allow for more data
**************************************************************

It should say "semi-colon delimited list".
I will make sure this is corrected in the next version, and see if we can do some error checking to remove spaces just incase.

LadyHLG

[LadyHLG]

The spacing issue with the delimited lists actually revealed a problem with the file posted above.
I am attaching a new file for everyone to try.
That also checks for spaces in the delimited list.
LadyHLG

[inkuyo]

Ok, so instead of uploading the file, open it (you can open it with any type of text editor). Copy everything in the file and paste it into the query execution box on the Install sql patches page.
If it fails again try adding a semicolon ";" at the end of the last line.

Looks like some others were getting the same 'failed' response when installing this mod. So I went thru the thread and found this and it worked. Add the semi-colon at the end of the pasted SQL query voila!.

[inkuyo]

OK I thought it was all working, at least the SQL work and I have the local sales tax module in the total and under the tax rates.

I added one city (Lynnwood) with a tax rate of 9.5% (I also just tried the zip code) but nothing shows up on the check out page and it is NOT added to the total.

Any thoughts? I tried from scratch 2.2, added 2.3 and still nothing add to the cart.

Here is the debug results:
Your Total Local Tax Rec ID: 1
Tax Name: -

Tax based on customer shipping zone 62
1 matching tax zones found

$8.00
Sub-Total:

$6.45
United States Postal Service (1 x 0.26lbs) (Priority Mail (2 - 3 days)):

$1.28
WA State Sales Tax:

$15.73
Total:

[inkuyo]

OK I thought it was all working, at least the SQL work and I have the local sales tax module in the total and under the tax rates.

I added one city (Lynnwood) with a tax rate of 9.5% (I also just tried the zip code) but nothing shows up on the check out page and it is NOT added to the total.

Any thoughts? I tried from scratch 2.2, added 2.3 and still nothing add to the cart.

Here is the debug results:
Your Total Local Tax Rec ID: 1
Tax Name: -

Tax based on customer shipping zone 62
1 matching tax zones found

$8.00
Sub-Total:

$6.45
United States Postal Service (1 x 0.26lbs) (Priority Mail (2 - 3 days)):

$1.28
WA State Sales Tax:

$15.73
Total:

I figured it out. It has to do with the case sensitivity of the city name, AND the billing location (not the shipping location).

So Example: bothell is NOT the same as Bothell.

Now I just have to think about how to implement this....