Page 2 of 64 FirstFirst 12341252 ... LastLast
Results 11 to 20 of 635
  1. #11
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    help question Re: Local Sales Tax Mod - Support Thread

    LadyHLG, first let me thank you for this great mod which seems to be exactly what I need.

    I managed to install your package without any problem. My only problem now is how to enter my own state's information into your module.

    I selected Location/Taxes > Local Sales Tax, then click the [new tax rate] button.

    Now, I have a list of towns (not ZIP codes) in my state which have local sales tax. How do I enter that list?

    I only noticed the following instructions for ZIP codes:
    What data are we searching for?
    For Ranges use "-to-" for seperator
    example: 53000-to-56000.
    What do I use to separate the towns in the list? commas? spaces? How do I enter towns that have spaces in them (e.g. "East Springfield")?

  2. #12
    Join Date
    May 2005
    Posts
    361
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    City names can be entered one per record or in a semi-colon delimited list, (with spaces as is).

    ie - Smallville; Gotham City; Metropolis

    Obviously, cities don't have ranges so you can disregard that.

    LadyHLG

  3. #13
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    help question Re: Local Sales Tax Mod - Support Thread

    Thank you very much! This is clear now.

    Unfortunately however, it seems that I was too quick to declare that I installed without any problem. Now that I try to do a test checkout, I receive the following in step 2 of 3 (Payment Information):

    Your Total
    1146 Table 'zc_store.TABLE_LOCAL_SALES_TAXES' doesn't exist
    in:
    [select local_tax_id, zone_id, local_fieldmatch, local_datamatch, local_tax_rate, local_tax_label, local_tax_shipping, local_tax_class_id from TABLE_LOCAL_SALES_TAXES where zone_id = '']
    Have you seen this before? What could be causing this?

  4. #14
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    Default Re: Local Sales Tax Mod - Support Thread

    Just in case the following could be helpful in diagnosing the above problem: I suspected the the table that was supposed to be created by running LocalSalesTaxv2.2.sql wasn't really created.

    I decided to re-run it (via the edit box (copy & paste) because the 'upload file' doesn't really work) and I received the following which looked familiar from the first run (which I mistook for a non-failure):
    Query Results:
    CREATE TABLE tax_rates_local ( local_tax_id int(11) NOT NULL auto_increment COMMENT 'tax id', zone_id int(11) default NULL COMMENT 'zen cart zone to apply tax', local_fieldmatch varchar(100) default NULL COMMENT 'name of field from delivery table to match', local_datamatch text COMMENT 'Data to match delievery field', local_tax_rate decimal(7,4) default '0.0000' COMMENT 'local tax rate', local_tax_label varchar(100) default NULL COMMENT 'Label for checkout', local_tax_shipping varchar(5) default 'false' COMMENT 'Apply this tax to shipping', local_tax_class_id int(1) default NULL COMMENT 'Apply to products in what tax class', PRIMARY KEY (local_tax_id) );
    Any idea what I could be doing wrong?

    Update: wait a minute... I didn't see the top pink bar containing the error message. It says:

    Failed: 1
    Error ERROR: Cannot create table tax_rates_local because it already exists
    Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
    Last edited by zcnb; 6 Nov 2008 at 01:08 AM. Reason: udpate

  5. #15
    Join Date
    May 2005
    Posts
    361
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    Check your database to be sure the table is there and it is named correctly with whatever table prefix you have chosen (if any).
    LadyHLG

  6. #16
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    Idea or Suggestion Re: Local Sales Tax Mod - Support Thread

    Update: baffled by the mismatch by the table names (TABLE_LOCAL_SALES_TAXES vs. tax_rates_local) I tried to see where that TABLE_LOCAL_SALES_TAXES could possibly come from. I found two places in which TABLE_LOCAL_SALES_TAXES should be substitued by 'tax_rates_local'

    PHP Code:
    define('TABLE_LOCAL_SALES_TAXES'DB_PREFIX 'tax_rates_local'); 
    That led me to find what my problem was: I forgot to upload one file: [FONT="Courier New"]/includes/extra_datafiles/ot_local_sales_taxes_databse_tables.php[/FONT]


    See what I mean by "applying patches manually is error prone"?

    I wish there were a way to unpack the entire package into the directory structure in one step. Something like 'tar -xvf LocalSalesTaxModv2.2.tar'.

    Thanks again for your great mod. Now I am going to check the correctness for the calculations.

  7. #17
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    help question Re: Local Sales Tax Mod - Support Thread

    Unfortunately, this mod seems to be not working for me. I repeated all steps properly this time - from the beginning (on a test store of course) - but I keep getting calculations as if no local sales tax is defined.

    I mean, everything works just as before: State tax is applied but the local sales tax is simply not there:

    Code:
    Your Total
          Sub-Total: $1.98
      Free Shipping: $0.00
    State Sales Tax: $0.12
              Total: $2.10
    Shouldn't there be another line for local sales tax?

    What could have I done wrong in installing/configuring this mod?

  8. #18
    Join Date
    May 2005
    Posts
    361
    Plugin Contributions
    2

    Default Re: Local Sales Tax Mod - Support Thread

    Have you tried changing the sort order of the mod?
    LadyHLG

  9. #19
    Join Date
    Apr 2008
    Location
    Bainbridge Island, WA
    Posts
    16
    Plugin Contributions
    0

    Default Re: Local Sales Tax Mod - Support Thread

    On the Gift Cert Mod, your link to the calculation error in gift cert totals worked. All the totals are correct!

    I really appreciate your help. This is a great mod and will put our store in compliance with the new destination based sales tax in WA.

    I really appreciate your help on this!!


  10. #20
    Join Date
    Jun 2008
    Posts
    328
    Plugin Contributions
    0

    Default Re: Local Sales Tax Mod - Support Thread

    Quote Originally Posted by LadyHLG View Post
    Have you tried changing the sort order of the mod?
    No, I kept the default 250. I will try this shortly and see whether this helps. What value do you recommend?

    Also, should I define a new tax class for it, or should I just use the existing tax class for the state?

    Also, if I enable debugging, where do should I expect to see the debug information?

    Thanks,
    Daniel
    Last edited by zcnb; 6 Nov 2008 at 04:41 PM. Reason: more questions

 

 
Page 2 of 64 FirstFirst 12341252 ... 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