Page 12 of 64 FirstFirst ... 210111213142262 ... LastLast
Results 111 to 120 of 635
  1. #111
    Join Date
    May 2005
    Posts
    361
    Plugin Contributions
    2

    Default Re: 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

  2. #112
    Join Date
    Feb 2009
    Posts
    6
    Plugin Contributions
    0

    Default Re: Local Sales Tax Mod - Support Thread

    I'll give it a try.

    Thank you.

  3. #113
    Join Date
    Apr 2008
    Location
    Covington, Washington, United States
    Posts
    205
    Plugin Contributions
    1

    Default Re: Local Sales Tax Mod - Support Thread

    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.

  4. #114
    Join Date
    Apr 2008
    Location
    Covington, Washington, United States
    Posts
    205
    Plugin Contributions
    1

    Default Re: Local Sales Tax Mod - Support Thread

    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

  5. #115
    Join Date
    Aug 2008
    Posts
    15
    Plugin Contributions
    0

    Default Re: Local Sales Tax Mod - Support Thread

    Quote Originally Posted by LadyHLG View Post
    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.

  6. #116
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    Quote Originally Posted by LadyHLG View Post
    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!.

  7. #117
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    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:

  8. #118
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    Quote Originally Posted by inkuyo View Post
    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....

  9. #119
    Join Date
    Sep 2007
    Posts
    73
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    A Correction The tax is based on the Shipping Address.

  10. #120
    Join Date
    May 2005
    Posts
    361
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    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

 

 
Page 12 of 64 FirstFirst ... 210111213142262 ... LastLast

Similar Threads

  1. v151 Tax getting added twice after installing Local Sales Tax mod
    By RFree190 in forum General Questions
    Replies: 0
    Last Post: 19 Mar 2013, 05:10 AM
  2. v150 Problem with Local Sales Tax mod
    By pwithers in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 18 Jun 2012, 10:16 PM
  3. local sales tax mod not working
    By sharpie82 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 12 Dec 2011, 11:43 AM
  4. New York State Sales Tax by Zip Full Database for Local Sales Tax Mod 2011
    By SCHNiKEN in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 11 Apr 2011, 04:51 AM
  5. Local Sales Tax Mod and Reward Points Mod
    By retched in forum Addon Payment Modules
    Replies: 1
    Last Post: 9 Feb 2011, 02:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR