Local Sales Tax Mod - Support Thread

If you set up Ohio counties as zones and then use the local mod to create the sales taxes by zip code then yes this will work.

There is a section in the mod README file called Helpful Tips that explains how to set up state counties as zones.

From there you would have to create each zip code based sales tax for each county.

I hope that answers your question.

LadyHLG

I'll give it a try.

Thank you.

LadyHLG,

Would this mod work for the distination based sales tax that is by streets and blocks? Basically Washington State now calculates what is called destination based sales tax. It is not calculated by city or zip, but it can actually change by block! It is very frustrating, but what can you do you know?

Anyways, this looks like it may be the solution, just thought I would see what your thoughts are about it.

So I decided this mod was probably the best solution for WA destination based sales tax. When I went to install the SQL script though it simply says "failed" no error message given or anything. I am trying to install v2.2 on 1.3.8 any idea what's going on?
Posted via Mobile Device

Quote:

---

Originally Posted by LadyHLG

JinkyO,
To help you correct the issue with paypal we will need some help from someone more familiar with PayPal Express to find where to update the code to strip the unwanted extra characters from the state, not a difficult thing to do, but I really dont have the time to search the code to find it right now.

As for your other issue, did you turn on debugging for the mod? If so what did you get for output?

LadyHLG

---

Thanks for getting back to me and thank you for your reply to someone else in post #90 of this thread because that really helped me understand how this mod works. Since posting I think I solved my problems.

A few things I'd messed up on my end where:
forgetting the "-to-" separator between my zipcodes, I was just doing zipcode-zipcode.

Also in the "zen" moments of throwing baby and bathwater around, I'd set the sort order for local tax higher than the zone tax.

So after fixing the first, the local taxes did add in but weren't being displayed as "local tax $xx" And after fixing the second I got everything sorted.


On the other issue of stripping out characters from the PayPal Express module, I don't need that anymore. This set up (applying local tax atop my State tax) works perfectly.

Quote:

---

Originally Posted by 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.

---

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!.

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:

Quote:

---

Originally Posted by 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....

A Correction The tax is based on the Shipping Address.

inkuyo,
Try this:
Open the following file.
\includes\modules\order_total\ot_local_sales_taxes.php

at about line 170 find

Code:

---

if($myfield == $value){

---

and replace it with

Code:

---

if(strtolower($myfield) == strtolower($value)){

---

See if that fixes the issue.

LadyHLG