Page 2 of 6 FirstFirst 1234 ... LastLast
Results 11 to 20 of 56
  1. #11
    Join Date
    Jun 2004
    Posts
    14
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    Awesome Module!

    Quick question though...

    When using this module i get the following in the Order Total Section of the checkout process:

    select zip from local_zips where zip='92128'

    How can I get rid of this? Thanks!

    -Jeremy

  2. #12
    Join Date
    Nov 2006
    Posts
    9
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    I am getting a similar error:

    select zip from local_zips where zip='92822'
    1146 Table 'db188733754.local_zips' doesn't exist
    in:
    [select zip from local_zips where zip='92822']


    It works fine for out of state zip codes but not local.

  3. #13
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: California Sales Tax Module

    Your "table does not exist" errors indicate that you neglected to install the database table required for the mod to work.
    The readme.txt explains to do that.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #14
    Join Date
    Nov 2006
    Posts
    9
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    I tried installing the database but I am having a bit of trouble.

    My host uses MySQL. Here is what I have done so far:
    I go to the database and click on phpMyAdmin and see a list of all the tables.
    At the bottom, I see: Create new table on database. I use the name provided in the readme.txt notes. The setup asks me for how many fields, I entered 1.

    I change all the attributes to match the sql.txt example. The only thing I wasn't sure about is the type. I left the default which is MyISAM.

    It looks like I have everything setup. It looks like I can add them one at a time but is there a way to import a file? I see a link for: Insert data from a text file into the table.
    Do I just edit the sample lacountylocalzip.sql txt file so it starts with this (removing the CREATE TABLE stuff at the top of the example):
    INSERT INTO `local_zips` (`zip`) VALUES(90001);
    INSERT INTO `local_zips` (`zip`) VALUES(90002);
    INSERT INTO `local_zips` (`zip`) VALUES(90003);
    INSERT INTO `local_zips` (`zip`) VALUES(90004);
    INSERT INTO `local_zips` (`zip`) VALUES(90005);
    INSERT INTO `local_zips` (`zip`) VALUES(90006);
    INSERT INTO `local_zips` (`zip`) VALUES(90007);

    Then send it up?

  5. #15
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: California Sales Tax Module

    No.

    Select your Zen Cart database from the left pulldown menu.
    Then click on the "Import" tab across the top right (if no "Import", choose "SQL").
    Then you can either paste the contents of the lacountylocalzip.sql file in the textbox, or you can browse for the file and upload/submit it.
    That should create the table and insert the required records.

    If you specified a "table prefix" during installation of your Zen Cart system, you'll need to make some changes to the lacountylocalzip.sql file contents before you do this. You can determine this by checking if your "DB_PREFIX" setting in the /includes/configure.php file is set to blank (ie: '').
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #16
    Join Date
    Nov 2006
    Posts
    9
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    Think I got it now! Thanks!

    One last question. When I use the checkout, step 2 (Payment information) shows this in the YOUR TOTAL box.

    select zip from local_zips where zip='92822'

    Is there a way to change this?

  7. #17
    Join Date
    Nov 2006
    Location
    San Diego,California
    Posts
    48
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    Could sure use some help installing this? Thanks

  8. #18
    Join Date
    Nov 2006
    Location
    San Diego,California
    Posts
    48
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    Quote Originally Posted by creeperkat View Post
    Think I got it now! Thanks!

    One last question. When I use the checkout, step 2 (Payment information) shows this in the YOUR TOTAL box.

    select zip from local_zips where zip='92822'

    Is there a way to change this?
    I second that how to change it?? very nice hack thank you

  9. #19
    Join Date
    Jan 2006
    Posts
    40
    Plugin Contributions
    0

    help question Re: California Sales Tax Module

    This sounds like a nice module and I am looking to adapt it to Orange County California.

    I have a question about implementation: Why the reliance on zip codes, rather than say, city names. The BOE provides both CVS and Excel versions of the tax rates linked to City and County names, but no zip code information.

    Can this module be adapted to work with city names instead of zip codes? Not sure where to get the necessary zip code information.

    Thanks for the contribution.

    Regards,

    Mark Harrison

  10. #20
    Join Date
    Jan 2007
    Posts
    2
    Plugin Contributions
    0

    Default Re: California Sales Tax Module

    It would be nice to see this work with cities as well, instead of zip codes. The state publishes a free database that has tax rates based on cities, that is constantly updated. Here is the link for the state database. Thank you.

    http://www.boe.ca.gov/sutax/pam71.htm

 

 
Page 2 of 6 FirstFirst 1234 ... LastLast

Similar Threads

  1. Super California Sales Tax Add-on
    By wendyandmilo in forum All Other Contributions/Addons
    Replies: 40
    Last Post: 10 Sep 2016, 03:09 AM
  2. v151 San Francisco tax AND California tax
    By noyloza in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 29 Apr 2013, 03:31 PM
  3. No Description on California Sales Tax Line in Checkout
    By bacbladerunner in forum General Questions
    Replies: 2
    Last Post: 17 Jun 2011, 04:09 AM
  4. Tax problem with sales tax and trinity payjunction module
    By rdxrdx in forum Addon Payment Modules
    Replies: 0
    Last Post: 1 Jul 2010, 10:25 PM
  5. California Sales Tax Zone Mods/Info
    By mjc in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 28 Feb 2008, 05:41 PM

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