Local Sales Tax Mod - Support Thread

Quote:

---

Originally Posted by LadyHLG

OK gwynwyffar,
Please try the update attached, just upload the new files to over write the current ones (only 2 of them).

Let me know what happens!
LadyHLG

---

LadyHLG,
First, thanks so much for all the time you've put into this module! The update you sent has the function directory in the root rather than under the includes directory. I figured it out as most will but for any that get stumped, I thought I'd mention it. The fix helped me get my local and state (FLA) tax files back as well.

Now I'm working on figuring out why, when I exempt ALL, I still see the local tax there. I'm wrapping up today and will reread some of the forum comments and attack that one tomorrow.

Just wanted to mention the directory structure correction before anyone else misplaced those fixes.

Regards,

Jim

Quote:

---

Originally Posted by supersnow

I just tried it and it still isn't working. The local tax is still calculated for exempt customers. The state sales tax shows as $0.00 but the local tax is then displayed under this with an amount.

---

I am having a similar problem as supersnow. I'm using ZC v1.3.9h, Local Tax v2.5 with the 2.51 changed files, and Tax Exempt v1.3.

With no exemptions: With the exemption box empty, I can now see the local & state taxes correctly for local (FLA) and none for out of state as expected.:smile:

ALL exempted: If I put "ALL" to exempt all taxes, it removes the state tax but I still see the local tax. :(

Exempt FL tax: When I put "FL TAX 6.0", it exempts the state tax and leaves in the local tax correctly.:smile:

I'm stumped as to where to look to fix the ALL exemption so it removes the local tax listing. Any suggestions would be appreciated.

Thanks,

Jim

Its been some time now and I was just wondering if anyone has successfully gotten this to work with 1.5. Tax cloud seems to have a major disconnect of information between the official site and the developer, I've given up on it.

Quote:

---

Originally Posted by gotduhka

Its been some time now and I was just wondering if anyone has successfully gotten this to work with 1.5. Tax cloud seems to have a major disconnect of information between the official site and the developer, I've given up on it.

---

I'd like to know the same thing. I am using Z1.5 and I am very much in need of such a mod ...

Quote:

---

Originally Posted by genochem

After 8 hours of tweeking, I am a little closer. Tax is applied to the shipping, and appears to be in the total, However, the numbers displayed do not add up.

Taxing based on: Shipping
Taxing For Zone: 195
Local Tax For:
Confer LAPT30- $72.4:
FL-Broward County - 4.344 @ 6.00
76.744
FL-Broward CountyTotal Tax = 4.344

Tax on shipping: 1.2558

$72.40 Sub-Total:

$20.93 United Parcel Service (Ground):

$4.34 FL-Broward County: (Does Not Include Shipping)

$98.93 Tax on Shipping appears to be included)

Any Thoughts on where to go would be appreciated?

Thanks

Jack

---

I'm having what I believe is the same problem.

Example:
Product subtotal: $34.00
Shipping (UPS Ground): $13.15
NY State sales tax (4%): $1.89
Ulster county sales tax (4%): $1.89
Total: $51.45

The tax calculations appear correct. $34+$13.15= $47.15 x 4% = $1.89

BUT! when you add $47.15 + 1.89 + 1.89 = $50.93 NOT $51.45

There's a $0.52 discrepancy in the calculated final total. Interestingly enough the shipping amt. $13.15 x 4% = .526

It looks like the local sales tax mod is adding in the tax on the shipping twice, but I can't quite see where that is happening. I'm using the files from 2.5.1 from June that you had sent me.

Mine was running 54 times. There's a stray end bracket in the PHP file causing the problem; it's the one that says endif apply local tax. That needs to be moved to below the shipping, order info, and update final total sections.

Could you be a little more specific? I think I see the extra bracket, but I'm not sure where you mean for it to go.

Code:

---

                //update order info totals
                $apply_tax_to_shipping = check_tax_on_shipping($taxrec['tax_shipping']);   
               
                if($apply_tax_to_shipping){
               
                      $shipping_tax = zen_calculate_tax($order->info['shipping_cost'], $taxrec['tax']);
                      $order->info['shipping_tax'] += $shipping_tax;   
                      $tax_total_for_class  +=    $shipping_tax;
                } // end if apply to shipping
               
               
                // Update the final total to include tax
                $order->info['total'] = $order->info['subtotal'] + $order->info['tax'] + $order->info['shipping_cost'] + $order->info['shipping_tax'];
               
                $showtax = $currencies->format($tax_total_for_class, true, $order->info['currency'], $order->info['currency_value']);
               
                $this->output[] = array(
                                'title' => $taxdesc .':' ,
                                'text' => $showtax,
                                'value' => $tax_total_for_class);
            }Should the bracket go here instead?
                     
            } //end if tax total > 0
           
          }  //end if apply local tax <- offending bracket?
      } //end foreach tax

    } //end if local tax <> 0
   
} //end function

---

I tried moving the bracket, that is not my problem as it made no difference.

There's some error in the function or the loop that is causing the local tax on shipping to be added into the total twice.

You have a different version of the file than I do. I don't have if tax total >0 so I have no idea which side it should go on. Not that it really matters if it doesn't fix your problem.

I think I managed to fix my problem. It might not have been the right way, but the calculation is working properly now. I commented out line 109 on the ot_local_sales_taxes.php file (I'm using version 2.5.1 which I guess never actually got posted to the repository for download but it's available earlier in this thread. Posting the function below in case it helps someone else - or in case someone sees a flaw in my very rudimentary attempt.

//update order info totals
$apply_tax_to_shipping = check_tax_on_shipping($taxrec['tax_shipping']);

if($apply_tax_to_shipping){

$shipping_tax = zen_calculate_tax($order->info['shipping_cost'], $taxrec['tax']);
//commented out line below to fix addition of shipping tax twice into order total
//$order->info['shipping_tax'] += $shipping_tax;
$tax_total_for_class += $shipping_tax;
} // end if apply to shipping

Hello, in-case anyone is still using this, I am looking at updating this plugin to Zencart v1.5.0. So, if anyone has information on specific bugs that should be or have been resolved in the forum, please send then, I am hopping this update will not be too time consuming, but I need it for a store and thought others may like it as well. I am starting the update based upon the latest code I found posted in this forum and the updates that were on the plugins download site (v2.5, and v2.5.1). as a start to the update I have already created a Florida specific SQL file with counties and related zip codes as of 2012, and related uninstaller, I will post those here for anyone that would like them.

This zip file has the SQL files I mentioned above. Attachment 10720

Quote:

---

Originally Posted by potteryhouse

Hello, in-case anyone is still using this, I am looking at updating this plugin to Zencart v1.5.0. So, if anyone has information on specific bugs that should be or have been resolved in the forum, please send then, I am hopping this update will not be too time consuming, but I need it for a store and thought others may like it as well. I am starting the update based upon the latest code I found posted in this forum and the updates that were on the plugins download site (v2.5, and v2.5.1). as a start to the update I have already created a Florida specific SQL file with counties and related zip codes as of 2012, and related uninstaller, I will post those here for anyone that would like them.

---

Thank you in advance for the effort. I have tried previously to contact the author with no sucess and several programmers that would not even give in an attempt because someone else wrote it.

Hello,
Thanks for the good news.
I would like to keep using this mod if possible. I'll be switching to v1.5.0 next month.
A feature that would be useful for me: it would be nice to get an output of the associated tax code number for the matched zip code. For example, my state (Washington) has a four digit "Location code" for each region. The nine digit zip code is necessary to determine which location code is correct. There are usually about 50000 zip code ranges, but there are only less than 500 location codes. I normally need to look up the location code manually. It would be nice to have an extra field to output the corresponding location code. It need not affect the matching, just output the extra information.
Thanks again.
Jason A.

This is an update to the tax mod, for version 1.3.9 only, this is the first step in the update to make it compatible with version 1.5.0. I have installed in on the site http://www.1potteryhouse.com/ and it seems to be working correctly. If anyone else would like to test it, let me know if there are issues. In the zip there is a readme.txt file that details the changes I made.

The two main changes are bug fixes and the inclusion of a Florida only SQL file.
Bug fix in "catalog/includes/modules/order_total/ot_local_sales_taxes.php" to resolve calculation error.
Bug fix in "catalog/includes/functions/extra_functions/functions_local_taxes.php", to resolve case select error and added zip + 4 support.

Due to upload size limit this is a tar/gzip file that needs to be extracted using a compatible tool such as Cygwin with this command 'gzip -dc localSalesTaxMod2.5.2.tar.zip | tar xv' or with 7zip available from http://www.7-zip.org/.

As with any mods, use at your own risk! Make sure you create backups prior to installation.

Quote:

---

Originally Posted by patternman

Hello,
Thanks for the good news.
I would like to keep using this mod if possible. I'll be switching to v1.5.0 next month.
A feature that would be useful for me: it would be nice to get an output of the associated tax code number for the matched zip code. For example, my state (Washington) has a four digit "Location code" for each region. The nine digit zip code is necessary to determine which location code is correct. There are usually about 50000 zip code ranges, but there are only less than 500 location codes. I normally need to look up the location code manually. It would be nice to have an extra field to output the corresponding location code. It need not affect the matching, just output the extra information.
Thanks again.
Jason A.

---

I need to understand more about what the location code is you refer to, is it the postal code "ZIP PLUS 4" or something specific to the state. If it is the zip plus 4, then it can be added to the zip code with a -, if not a new field will be needed I would think. A sample and or a link to the description may help.

I submitted an update today for the module that includes instructions to make this work with Zen Cart 1.5.
I do not know when they will become available for download, but they should show up here http://www.zen-cart.com/downloads.php?do=file&id=422

These are the basic instructions to add the mod to the admin menu in version 1.5.
-- go to Admin Page Registration

-- Page Key = "localSalesTaxes"
-- Page Name = "BOX_TAXES_LOCAL_SALES_TAXES"
-- Page Filename = "FILENAME_LOCAL_SALES_TAXES"
-- Page Parameters = "" (Nothing to enter here)
-- Menu = "Locations / Taxes"
-- Display on Menu? = CHECKED
-- Sort Order = "6" (Most likely next available Sort Order number)

I tried to install the Zen Cart Local Sales Tax Mod but I am stuck on instruction #1 "Copy all files inside the catalog folder to your cart." I am not sure if that means that I need to upload them using my FTP file manager in Godaddy or not. If that is where the all the files go, I am not sure what folder they actually go in. I am using the Apparel Boutique template. I think that admin folder is the first folder called "adminurrhtcqq" in my zencart. If anyone can help me out with some step by step instructions that would be great. I desperately need to have this Mod inorder to run my business correctly in my state. Thank you so much and I look foward to hearing someone

Thanks,
Matthew

Make sure you read through all the help files before making changes, and backup the shop and database so that you have a restore point to go back to if you have issues.
(readme.html and readme_version 2.5.2.txt)

It is usually best to try this process on a local copy (a version of zen cart installed on your local PC) prior to doing this online, that way you get a good feel for what should be done prior to making changes to the "real" site.

The files go into the folder on your host that your shop runs from within, they are copied using an FTP tool.

For example, if your shop is in a folder named "MYSHOP", then the the folder from the download called "catalog" would be equivalent to the folder called "MYSHOP", they would contain the same sub-folders structure and the files are simply overlay-ed into your "MYSHOP", note that none of these files should over write your current files, they are in addition. Remember that part of the zen cart installation renames your admin folder, so your should rename the admin folder in the catalog folder to match your sites admin folder (makes the copying easier).

I hope this helps.

Does anyone have any help for setting up NY local taxes, such as County and City taxes. I read about the Local Sales Tax Mod. I have it downloaded but what is the most effecient way to set it up. Had it set up originally without the mod, and it was just adding every single county and city tax to the order. How do you link the local taxes to the order and how does it recognize what tax it should charge the customer. Any help would be much appreciated!

Hi,

Obviously nothing is going to be absolutely simple, but this mod should do what you want based on your comment.
It should go without saying, Try this on a TEST setup first, NOT the live site.

First you need to decide if you will be taxing buy Zip code (which is what I use), City, or Suburb.

Depending on which you choose you will then need to gather the applicable information that you will add to the database in the setup steps. There is some flexibility in entry format when using zip codes.

Next, you should read the two help / readme files in the mod package, then read the short but good tutorial at:

http://www.toastboy.com/main/zen-cart-local-tax-module-setup/

Next make a checklist of the steps you will need to do based on the read me files and tutorials.

You will have NY State tax listed once in the database, and zip codes (in this example) for each City, town etc.. You can group all the zip codes that have the same local tax rate together (separated by a semicolon ; or for ranges by -to-) when entering them, this should reduce the number of input records you create.

The mod depends on the customer entering their location (i.e., zip code), and it applies taxes based on what the customer entered and what is found in the database for the location.

I've uploaded my NY State Sales tax file for you (tax_rates_local.sql). It is sorted by county and zip code. You might want to check to make sure the rates are the most current, but you should be able to just import it and it should work. You'll want to set your NY State sales tax to 4%, then the local taxes are added to it. There are 2 tax lines shown at check out, the state and county tax.

I've been using the Local Sales Tax mod successfully on ZC 1.3.9h for several years and am in the process up upgrading our site to 1.5.1, so I haven't confirmed it works the same, but it should.

I've been having problems with shipping being taxed when it shouldn't be. My original thread was here. How can I get this module to not tax shipping?

I am under the understanding that Florida does require tax on shipping. But if you do not then go to your admin page and under 'Shipping Modules' select your shipping module for the store, then change the 'Tax Basis' to what you need. This is a sample of the text when you are updating this module page:

Tax Basis
On what basis is Shipping Tax calculated. Options are
Shipping - Based on customers Shipping Address
Billing Based on customers Billing address
Store - Based on Store address if Billing/Shipping Zone equals Store zone

You might also want to try to setup the

Shipping Zone
If a zone is selected, only enable this shipping method for that zone.

Okay, with the new sales tax laws being passed to grab money from online retailers, Georgia is now requiring us to collect based on the county/tax division we are shipping to. There are 179 counties and the city of Atlanta - 180 possible tax destinations. If anyone already has the information of zip codes to counties, I would really appreciate the list - the sql of course would be best but right now the only thing I've been able to retrieve is a non-alphabetized list out of html.

I've moved this cart from OsCommerce and they had it set up there but though it imports the tax classes - it does not import the zone definitions to match since Zen Cart can't do zip codes or suburbs so the local mod is my only option. (By the way the Avatax mod is best for those who have to worry about different states - I helped develop it but it is a commercial product).

And thanks to potteryhouse for updating this mod to 1.5x!

I am new to ZenCart and have a new install of v150. We collect sales tax in Washington state (179 different "areas / rates") and Idaho. I am looking at adding the Local Sales Tax Module. I have a couple of questions about it.

1. Read me 2.5.5 says to rename the admin folder to match the admin folder on the website. Does that mean it overwrites the existing admin folder?

2. Is there a file format that can be used to setup the zones for the local sales tax and then import it into ZenCart?

3. If someone already has Washington state set up we'd love a copy.

I believe I have read all of the FAQs / Tutorials for the module - if I have overlooked something please point me to it.

Thanks in advance.

I've installed this in my 1.3.9h cart and it works. I do have one issue though, I only use paypal express checkout for payment, I had an issue I solved by deleting my state zone and using only the local taxes. The issue I'm trying to resolve now is that it no longer shows products and amounts itemized when on paypals checkout page. The total is right though. Does anybody have a fix for this?

Here's the 2013 Florida discretionary tax rates by zipcode. Change for 2013:

Walton county changed from 7% to 7.5%. Rate table PDF is available here

These are the affected zipcodes:
32422;
32433;
32434;
32435;
32439;
32454;
32459;
32461;
32538;
32550;

Quote:

---

Originally Posted by skylab001

I've installed this in my 1.3.9h cart and it works. I do have one issue though, I only use paypal express checkout for payment, I had an issue I solved by deleting my state zone and using only the local taxes. The issue I'm trying to resolve now is that it no longer shows products and amounts itemized when on paypals checkout page. The total is right though. Does anybody have a fix for this?

---

I've sorted out my issues with PayPal, it seems to be on the PayPal integration side. Another issue I've discovered now though, and it seems I'm not the first, is that discount coupons don't work unless moved after the tax in the display. Has anybody figured out how to fix this?

I'm very new to Zen Cart. I am testing it out to see if it will work for me, so have it installed at localhost.

I unzipped the file and pasted the folders from the FullVersion/catalog folder into the root of my ZenCart folder. I then opened the sqlfile folder. I did not see a file that was named LocalSalesTaxv2.5.sql. The best i could guess was Zencart_v1.5.0_admin_localSalesTaxes.sql. Should I have used tax_rates_local.sql instead?

Anyway, I was not able to install the sql at TOOLS -> Install SQL Patches, but was able to run the sql at phpMyAdmin. This is what I pasted into the SQL area:

Code:

---

SET @localSalesTaxesSort = (SELECT sort_order FROM zen_admin_pages WHERE menu_key = 'taxes' ORDER BY sort_order DESC LIMIT 1);
SET @localSalesTaxesSort = @localSalesTaxesSort+1;

INSERT INTO zen_admin_pages(`page_key`, `language_key`, `main_page`, `menu_key`, `display_on_menu`, `sort_order`)
VALUES ('localSalesTaxes', 'BOX_TAXES_LOCAL_SALES_TAXES', 'FILENAME_LOCAL_SALES_TAXES', 'taxes', 'Y', @localSalesTaxesSort);

---

For the next step, I'm supposed to go to MODULES -> ORDER TOTAL and find "Local Sales Taxes", but it isn't there.

Also, if I try to go to

What have I done wrong?

Thanks,
Alisa

Is this plugin compatible with v1.5.1 (latest release)? Is anyone using it with v1.5.1?

I am trying do a New Install of this mod. In readme.html it says to run the LocalSalesTaxv2.5.sql file. Where is this file located? I looked in the sqlfiles folder and only see the following files but not LocalSalesTaxv2.5.sql:
- addressBookZoneValidation.sql
- Florida_tax_rates_local.sql
- tax_rates_local.sql
- uninstall_Florida_zones_and_tax_rates_local.sql
- Zencart_v1.5.0_admin_localSalesTaxes.sql

Quote:

---

Originally Posted by runawayd

Is this plugin compatible with v1.5.1 (latest release)? Is anyone using it with v1.5.1?

---

I'm currently testing this under Zen Cart 1.5 - so far I have not run into any major issues with the core install (not using any of the optional SQL patches).

My copy is slightly different... I've been putting together a new packaging of this module with the "sales tax report" module. The new packaging includes an installer (no more manual SQL patches) and uninstaller.

If the current maintainer is interested, I could send them a copy when complete.

I started out as suggested installing this module at localhost. I had some problems, but finally worked through them. I then decided I was comfortable enough with Zen-Cart and modules uninstall my WordPress page and start from scratch with ZenCart. My site is on HostGator, so was able to just go to the cPanel and install Zen-Cart. Easy enough. Then I tried installing a template. Even though the template creator also uses HostGator and I followed the instructions to the letter, I still had problems with the install. Using Filezilla, when I was supposed to drag the folder to public_html, things would not work right. I don't know where the files went, but they didn't go into the folders they were supposed to. I had to manually drag each file over to the server. Finally got the templates installed, so decided to get the local sales tax module installed. Since this is one that I had installed at localhost, felt pretty confident that, even though I had problems with it then, that I could get it going on my site. I drug it over to the .. at public_html, and again, I don't know where all those files went, but it wasn't where they were supposed to go. I manually drug each file over the the correct folder. Ran the sql statements, and then went to Modules -> Order Totals. The module is not there. I'm not sure what to do at this point to get the module installed, but it is one of those things that I have to have in order to make any online sales to anyone within my state. So to sum it all up, here's what I've done:

Here's what i've done:
1. Downloaded and unzipped localSalesTaxMod2.5.2
2. Moved the files to the server using the files in the FullVersion folder
3. Ran the sql from Zencart_v1.5.0_admin_localSalesTaxes.sql in phpMyAdmin. Compared to what is in the comments of the sql, it inserted the row correctly.
4. Ran the sql from tax_rates_local.sql in phpMyAdmin. Views structure and it created correctly.
5. Ran the sql from Alabama_tax_rates_local.sql which I created using the Florida example when I installed this at localhost.

When I go to Locations / Taxes, everything appears to be correct and when I look at it in phpMyAdmin, all looks correct there too. I really don't understand why the module is not showing up to install.

Please advise what to do next to try to get this going.

Thanks,
Alisa
Dancing Bay Embroidery

Quote:

---

Originally Posted by dancingbay

I started out as suggested installing this module at localhost.

---

Maybe a stupid question, but when you installed you copied the files from "includes" to "public_html/includes" and the files from "admin" to "public_html/the name of your admin folder"? And the web server has permission to open those files?

Any error logs (for the web server or Zen Cart)?

I have some background in web development, but maybe some knowledge is more dangerous than none. So, the questions you're asking are not foreign to me.

I am using FileZilla. I knew I couldn't copy admin into the root, but had to open each up and copy files in from that level. I didn't see any error messages. I am assuming that the permissions are set correctly becuase I installed a template from Picaflor Azul with only minor problems. I did run a backup, I think right before I tried to install this module, so maybe I need to back out and start over, including a fresh download. I've found over the years that sometimes you can think you're doing something correctly several times with poor results and then finally it will work and you don't know what you did different. My mom used to say you just have to hold your mouth right [old southern saying]. Anyway, I will go back in and check permissions to make sure those are ok and see if I can go back and look at the log to see if there were any error messages.

Thanks,
Alisa

I re-downloaded and unzipped the module. Then I went back in to FileZilla and carefully move the files over to the server. Apparently I had not moved all the file in the includes folder, so once I did that, I was able to install. I'm up and running now, but when I start to implement, I may have more questions. Hopefully, they will all be answered somewhere in the 54 pages of the thread. :blink:

Thank you for reporting back! And glad you were able to find the missing file(s).

Hi runawayd, if you have not already solved this, maybe this will help.
The LocalSalesTaxv2.5.sql file name in the readme.html is obviously been replaced, please see the readme_version 2.5.2.txt file (assuming you are using the current package localSalesTaxMod2.5.2.zip). When I made the update I tried to leave the original instructions alone and create the additional readme file.

Quote:

---

Originally Posted by runawayd

If the current maintainer is interested, I could send them a copy when complete.

---

Hi, I put together the last version from the resources on this site and made a few tweaks though I am not the 'official' maintainer, I would like to make another update sometime this year to try and solve a couple of issues that have been reported (problem with using coupons / discounts) the files you mentioned seem like they would be a good addition. That said if you decide to make the updates an post them that would be okay with me. :)

The version 2.5.3 install script calls for a file that's not present in the zip package:

Admin/includes/languages/english/stats_sales_tax_totals.php

Quote:

---

Originally Posted by slomojojo

The version 2.5.3 install script calls for a file that's not present in the zip package:

Admin/includes/languages/english/stats_sales_tax_totals.php

---

I'm having this issue as well.

To fix the error you can edit the file "\1_new_files\your_admin_folder\includes\init_includes\init_local_sales_taxes_in stall.php".
On (or about) line 43 Delete the line:

DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/stats_sales_tax_totals.php',

Re-upload this file and it should work.
Remember please, always test on a development machine prior to adding or updating mods on your production server.

This extra entry was inadvertently left in the installation script. it is related to the SalesTaxReportv2.1 mod, not currently part of the local_sales_tax mod.
The SalesTaxReportv2.1 is a standalone mod at this time.

Quote:

---

Originally Posted by slomojojo

The version 2.5.3 install script calls for a file that's not present in the zip package:

Admin/includes/languages/english/stats_sales_tax_totals.php

---

The referenced file was part of a BETA version and the check was accidentally left in the final release. :blush:

A new version "2.5.3a" has been uploaded and will hopefully be available in the next couple days.

In the meantime you can either comment out or remove line 43 of "/your_admin_folder/includes/init_includes/init_local_sales_taxes_install.php". When removed the block starting at line 35 should look like the following:

Code:

---

        // Check to make sure all new files have been uploaded.
        // These are not intended to be perfect checks, just a quick 'hey you'.
        $files = array(
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'extra_datafiles/local_sales_taxes.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.local_sales_taxes.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'init_includes/init_local_sales_taxes_install.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'init_includes/init_local_sales_taxes_uninstall.php',
                DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/local_sales_taxes.php',
                DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/extra_definitions/local_sales_taxes.php',
                DIR_FS_ADMIN . FILENAME_LOCAL_SALES_TAXES . '.php',
                DIR_FS_CATALOG . DIR_WS_INCLUDES . 'extra_datafiles/ot_local_sales_taxes.php',
                DIR_FS_CATALOG . DIR_WS_FUNCTIONS . 'extra_functions/functions_local_sales_taxes.php',
                DIR_FS_CATALOG . DIR_WS_LANGUAGES . 'english/modules/order_total/ot_local_sales_taxes.php',
                DIR_FS_CATALOG . DIR_WS_MODULES . 'order_total/ot_local_sales_taxes.php'
        );

---

Yeah, I figured that's all it was. I've been testing it for a couple of days without any problems.

Thanks for the quick responses. And thanks for updating and maintaining this very useful plugin for 1.5x.

Quote:

---

Originally Posted by lhungil

The referenced file was part of a BETA version and the check was accidentally left in the final release. :blush:

A new version "2.5.3a" has been uploaded and will hopefully be available in the next couple days.

In the meantime you can either comment out or remove line 43 of "/your_admin_folder/includes/init_includes/init_local_sales_taxes_install.php". When removed the block starting at line 35 should look like the following:

Code:

---

        // Check to make sure all new files have been uploaded.
        // These are not intended to be perfect checks, just a quick 'hey you'.
        $files = array(
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'extra_datafiles/local_sales_taxes.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.local_sales_taxes.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES . 'init_includes/init_local_sales_taxes_install.php',
                DIR_FS_ADMIN . DIR_WS_INCLUDES .

'init_includes/init_local_sales_taxes_uninstall.php',

                DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/local_sales_taxes.php',

                DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english/extra_definitions/local_sales_taxes.php',

                DIR_FS_ADMIN . FILENAME_LOCAL_SALES_TAXES . '.php',

                DIR_FS_CATALOG . DIR_WS_INCLUDES . 'extra_datafiles/ot_local_sales_taxes.php',
                DIR_FS_CATALOG . DIR_WS_FUNCTIONS .

'extra_functions/functions_local_sales_taxes.php',

                DIR_FS_CATALOG . DIR_WS_LANGUAGES . 'english/modules/order_total/ot_local_sales_taxes.php',
                DIR_FS_CATALOG . DIR_WS_MODULES . 'order_total/ot_local_sales_taxes.php'
        );

---

---

hello sir
thanks alot

I have applied the mod on the e-Commerce however at the moment of the checkout I only see the state tax. Didn't run into any issues with installation.
I would really appreciate any kind of help.

ZenCart v1.5.1
Local Sales Tax v.2.5.3a
PHP 5.3.23
MySql 5.5

Quote:

---

Originally Posted by dbpiano

I have applied the mod on the e-Commerce however at the moment of the checkout I only see the state tax. Didn't run into any issues with installation.
I would really appreciate any kind of help.

---

Could be a large number of different things. Can you give a more concrete example of your customer address data (for primary / shipping / billing), your configured rule(s) expected to match the customer address data, and your store settings for tax basis?

That's the customer's information
Attachment 12457

Tax rules
FL 6%
Volusia County 3802 0.5% (which is not being displayed).

I used the FL sql script to load tax state's information.

Attachment 12458

I hope this is everything.

Thanks for your help!

What are the store settings for tax basis? (admin -> configuration -> my store)
Is the Local Sales Tax order total module installed and enabled? (admin -> modules -> order total)

Quote:

---

Originally Posted by lhungil

What are the store settings for tax basis? (admin -> configuration -> my store)
Is the Local Sales Tax order total module installed and enabled? (admin -> modules -> order total)

---

The Local Sale Tax module was disabled, once enabled, it worked perfectly.

I wouldn't been able to figure that out by myself.

Thanks for your help. :clap:

Quote:

---

Originally Posted by dbpiano

The Local Sale Tax module was disabled, once enabled, it worked perfectly.

---

Thank You for letting us know Cannot believe I forgot that step in the readme :P

I am trying to use this add on for zencart 1.51, specifically for san francisco sales tax which is higher than the California sales tax. I have it installed properly and am using these zip codes but its still not working:

94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;9415 8

and I have it set to zipcode. Can somebody tell me if they are having trouble with their add on?

I am trying to use this add on for zencart 1.51, specifically for san francisco sales tax which is higher than the California sales tax. I have it installed properly and am using these zip codes but its still not working:

94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;9415 8

and I have it set to zipcode. Can somebody tell me if they are having trouble with their add on?

Quote:

---

Originally Posted by noyloza

I am trying to use this add on for zencart 1.51, specifically for san francisco sales tax which is higher than the California sales tax. I have it installed properly and am using these zip codes but its still not working:

94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;9415 8

and I have it set to zipcode. Can somebody tell me if they are having trouble with their add on?

---

If you do not already have the zone setup, this SQL should add the San Fran 1% additional tax to the table, make sure you verify the zip codes and additional sales tax before you use this:

Code:

---

INSERT INTO tax_rates_local (`zone_id`, `local_fieldmatch`, `local_datamatch`, `local_tax_rate`, `local_tax_label`, `local_tax_shipping`, `local_tax_class_id`)
VALUES
        (12, 'postcode', '94102;94103;94104;94105;94107;94108;94109;94110;94111;94112;94114;94115;94116;94 117;94118;94121;94122;94123;94124;94127;94129;94130;94131;94132;94133;94134;94158', 1.0000, 'San Francisco (1.0%)', 'true', 1);

---

Make sure that you have turned this mod on (see previous post) and set the other items listed in the readme file.
If this does not work we will need more info as to what is happening to make suggestions.

I overlooked a blank space in one of the zip codes "94 117" in the post above, that needs to be removed. There should not be spaces in any of the zip codes.

thank you ver much for your help, however I don't know how to implement an SQL, can you tell me how to do this?

I have activated the module in modules / order totals, and the rate is set in Locations > local sales taxes as well...

It just always picks up CA tax over the SF tax... Please let me know how I can install that SQL...

Quote:

---

Originally Posted by noyloza

... It just always picks up CA tax over the SF tax...

---

Do you mean it is showing "California Tax" and "San Francisco" Sales Tax lines? This module will add a "tax line" for every valid tax rate which matches the tax rules defined in both Zen Cart and Local Sales Taxes ("admin" -> "locations / taxes" -> "local sales tax"). So if you have a rate defined for both "California Sales Tax" and "San Francisco Sales Tax", I would expect to see both as long as the "tax rules" are correctly defined.

Quote:

---

Originally Posted by noyloza

... I don't know how to implement an SQL ...

---

To add, remove, or modify rules for how tax rates are applied to an order you do not need to use SQL... You can just navigate to "admin" -> "locations / taxes" -> "local sales tax" and enter the rules for your location (by zipcode or city name). Matching by "suburb" is not currently supported. Most of the "how do I do configure taxes" is outlined in the "HowTo-Example.pdf" (included in the downloadable distribution).

it only picks up CA, and never SF for a user who is based in SF and has one of the zipcodes set in the rules for the local sales tax mod. I added all of the zipcodes, set to zipcode, and use SF as the description. I'm assuming that if the mod picks up the user who is using a zip code for shipping that is one of the ones I have set to find, it will apply SF(8.75%) as the tax instead of CA (8.25%). Right now however, it is only picking up CA for a user who is using shipping in SF...

Quote:

---

Originally Posted by noyloza

it only picks up CA, and never SF for a user who is based in SF and has one of the zipcodes set in the rules for the local sales tax mod. I added all of the zipcodes, set to zipcode, and use SF as the description. I'm assuming that if the mod picks up the user who is using a zip code for shipping that is one of the ones I have set to find, it will apply SF(8.75%) as the tax instead of CA (8.25%). Right now however, it is only picking up CA for a user who is using shipping in SF...

---

If everything was installed and configured correctly it will show "CA (8.25%)" AND "SF (0.5%)". Both rates are applied individually (If the calculated tax rounds to less than a penny it will not be shown). The overall TAX rate applied to the order will be tax_round(price*8.25%) + tax_round(price*0.5%) for a total applied tax rate of 8.75%.

Things to check / post screen shot (Just to clarify and double check)

• What are the store settings for tax basis (admin -> configuration -> my store)?
• Is the Local Sales Tax order total module installed and enabled (admin -> modules -> order total)?
• Concrete example of your customer address data (for shipping / billing)?
• The configured rule(s) expected to match the customer address data (provide using "CODE" block and copy / paste from Zen Cart)?
• What is the "Tax Class" of the product? Does it match the "Tax Class" selected in the configured rule?
• Are there any "debug" files in "/logs" or "/cache" (if so please provide here using "CODE" blocks)?

Other considerations

• Did you install Zen Cart using a method other than zc_install (such as softaculous / cpanel)?
• Did you upgrade from an older version of Zen Cart (such as 1.3.x / 1.5.0)?
• Did you upgrade from an older version of Local Sales Tax (if so did you try to uninstall / re-install the order total module)?
• What other modifications have been made to your Zen Cart installation (templates, plugins, etc)?
• Link to your website (sometimes it is useful to see the website)?

Failing all else, you can enable "Debugging is active". This will display some additional debugging information on relevant pages of your website relating to the "Local Sales Tax" module. Keep in mind anyone visiting your website will also see the debugging messages.

What are the store settings for tax basis (admin -> configuration -> my store)? SHIPPING

Is the Local Sales Tax order total module installed and enabled (admin -> modules -> order total)? YES

Concrete example of your customer address data (for shipping / billing)? Not sure what this means?

The configured rule(s) expected to match the customer address data (provide using "CODE" block and copy / paste from Zen Cart)?attached.

What is the "Tax Class" of the product? Does it match the "Tax Class" selected in the configured rule? how can i check this?

Are there any "debug" files in "/logs" or "/cache" (if so please provide here using "CODE" blocks)? not sure...

attaching screen shots to see if there is something out of order...

should my local sales tax be .5% then instead of the complete 8.75%? Either way its not being added so I don't think its working...

In a clean installation of Zen Cart, USA "zones" match against "state" only. So by default Zen Cart does not include a "San Francisco" zone... Not sure why this was added, but the zone probably matches NOTHING. I would recommend removing the "San Francisco" zone to avoid future confusion unless there is a valid business reason this zone was added to Zen Cart (and it actually does something).

You should be using the "California" zone as the zone where the "San Francisco" local tax rule should be applied. Once you "fix" this setting on your rule, if all else is correct, the two rates should be applied (CA and SF).

Quote:

---

Originally Posted by noyloza

...
What is the "Tax Class" of the product? Does it match the "Tax Class" selected in the configured rule? how can i check this?
...

---

In the admin open up "Catalog" > "Categories / Products". Find the product you testing with. Select and edit the product. On the edit page what is selected for the "Tax Class:"? Does it match the "Tax Class" selected in the local sales tax rule?

Quote:

---

Originally Posted by noyloza

...
Are there any "debug" files in "/logs" or "/cache" (if so please provide here using "CODE" blocks)? not sure...
...

---

See Step 2a on this page. It should help guide you when looking for these files.

Quote:

---

Originally Posted by noyloza

...
should my local sales tax be .5% then instead of the complete 8.75%?
...

---

Yes.

I changed my sales tax to .5% and my tax classes match...

The people from accounting pointed out that on the Orders detail page and the Invoice on the Admin section are showing the wrong amount for taxes.

Example:

Someone from the Volusia county should be charged 6.5% 6% for state tax and 0.5% for county tax

The calculation is correct but the value displayed on the tax section is 7%.

Attachment 12573

I checked how the detail table is being created and traced the tax value in this case is field=products_tax(7.0000) being pulled from table on the DB `orders_products`.

Is there any way that you can help me to fix this? since is causing issues with end user giving them the impression that the tax is wrong.

I don't know if this is an issue with "local sales tax mod" or the "edit order mod", but since you are the creator of both I figured you would understand this issue.

Thanks in advance

Quote:

---

Originally Posted by dbpiano

The people from accounting pointed out that on the Orders detail page and the Invoice on the Admin section are showing the wrong amount for taxes.

---

You are correct (and thank you for mentioning this in the support thread)!

Background / Why
The "tax" field is pulled from the Zen Cart "tax" rate for the product. This does not include any "local sales tax" calculations. The "Local Sales Tax" mod does not modify what is shown in this field (admin side). It also does not include changes to any templates (customer side). Showing a combined rate may be considered in the future (the value in the database saved with the product should not be altered). If you (or anyone else) tackles this project, please submit the changes / patches to this support thread!

Modifying the value of this field using "Edit Orders" will only modify the Zen Cart tax rate, not any "local sales tax" calculations. "Edit Orders" does not support manually changing the "local sales tax" rate for products. Any "local sales tax" will be applied in addition to the rate listed in this field. Adding the ability to modify the "local sales tax" order line will not be considered for "Edit Orders" in the future (unless an overwhelming need with no workaround is found - as this would require substantial modification to both modules).

Temporary Workaround / Hide the field
If you are concerned with the rate being shown to people using the Zen Cart admin interface, remove the column from showing in "/admin/orders.php" and "/admin/invoice.php" (I typically just alter the invoice and teach clients to always use this button to display / print their invoices).

For the customer side, this field is only shown on the account history page if products with different tax rates are in the same order. If you might encounter this situation you can edit "/includes/templates/YOUR_THEME_NAME/templates/tpl_account_history_info_default.php" to remove the tax column from being shown.

Quote:

---

Originally Posted by lhungil

You are correct (and thank you for mentioning this in the support thread)!

Background / Why
The "tax" field is pulled from the Zen Cart "tax" rate for the product. This does not include any "local sales tax" calculations. The "Local Sales Tax" mod does not modify what is shown in this field (admin side). It also does not include changes to any templates (customer side). Showing a combined rate may be considered in the future (the value in the database saved with the product should not be altered). If you (or anyone else) tackles this project, please submit the changes / patches to this support thread!

Modifying the value of this field using "Edit Orders" will only modify the Zen Cart tax rate, not any "local sales tax" calculations. "Edit Orders" does not support manually changing the "local sales tax" rate for products. Any "local sales tax" will be applied in addition to the rate listed in this field. Adding the ability to modify the "local sales tax" order line will not be considered for "Edit Orders" in the future (unless an overwhelming need with no workaround is found - as this would require substantial modification to both modules).

Temporary Workaround / Hide the field
If you are concerned with the rate being shown to people using the Zen Cart admin interface, remove the column from showing in "/admin/orders.php" and "/admin/invoice.php" (I typically just alter the invoice and teach clients to always use this button to display / print their invoices).

For the customer side, this field is only shown on the account history page if products with different tax rates are in the same order. If you might encounter this situation you can edit "/includes/templates/YOUR_THEME_NAME/templates/tpl_account_history_info_default.php" to remove the tax column from being shown.

---

Thanks for your help.

Has any progress been made with regard to Order Total and the affect of coupons and GVs on that total? The Local Sales Tax mod works perfectly except when someone uses a Coupon code or GV. In that case it calculates tax as if the discount never happened.

Hi, I am considering using this mod for calculating Florida local taxes. I am currently using Tax Cloud and it does not play well with coupons causing me headaches with importing orders into my accounting system. What I need to know before installing this mod is how will the tax charged the customer (state 6% plus local %) get posted into the SQL database - into 1 field (normal tax field), 2 fields (state & local), or 3 fields (state, local, & total)? This is important because I use Cart Span that works fantastic and Cart Span only imports the one field, the normal Tax field that is build into Zen Cart. So if this mod posts the total tax charged into the normal Zen tax field, then I would be all set!

Quote:

---

Originally Posted by FloridaGoFishing

... What I need to know before installing this mod is how will the tax charged the customer (state 6% plus local %) get posted into the SQL database - into 1 field (normal tax field), 2 fields (state & local), or 3 fields (state, local, & total)? ...

---

Typically the state is configured using the stock Zen Cart tax system. Local taxes are then configured using this module and will be added to the order total separately.

Taxes are stored as one entry per tax rate charged
This module adds the taxes to the standard Zen Cart locations during order total processing (array containing tax descriptions + amount). When the taxes are saved to the Zen Cart database, each "local" tax amount is treated as a separate order total line (and saved as such in the database). This is done on purpose to allow full reporting of what taxes were paid (and what municipality, program, or location for which the tax was collected).

Integration with 3rd Party software
After an order has been completed / shipped a, if integration is done using a 3rd Party vendor (to "export" the order data from Zen Cart's database and "import" the order data into account softwaresuch as QuickBooks)... It would probably be best to contact the 3rd Party vendor of the integration software (especially if the 3rd Party software is commercial).

Some questions to ask the 3rd Party Vendor:

• Does your Zen Cart module support the "Local Sales Tax" Zen Cart module?
• How does your Zen Cart module support multiple order total lines (such as store credit, shipping, discounts, taxes, subtotal, etc)?
• Does your Zen Cart module support adding together specific order total lines prior to import into accounting software such as QuickBooks?
• When exporting from Zen Cart and importing data to accounting software such as QuickBooks, does your Zen Cart module support mapping specific Zen Cart order total lines to specific lines in QuickBooks?

Note: I am not a tax lawyer and cannot give advice as to how taxes should be collected, reported, or remitted. As such, it is your responsibility to seek the advice of a tax professional operating the the area(s) you do business to provide accurate answers to any and all questions related to taxes.

Thank you Ihungil for the detailed answer to my question, it is much appreciated!

Quote:

---

Originally Posted by FloridaGoFishing

Thank you Ihungil for the detailed answer to my question, it is much appreciated!

---

No problem. Sorry for the long way of saying "they are separate", but hopefully the additional thoughts are of some use...

I have set up local sales tax for Washington State however the local city tax does not appear or calculate on orders. I set this up over two years ago and it's never worked. Everything appears to be set up properly except there is no Order Total Module for Local Tax. Here are some details:

version: v1.3.9e
Local Sales Tax set up by city name for example: Arlington;Bainbridge Island;Bellevue;Black Diamond;Bremerton is applied to the zone "Washington", tax rate 2.1 and search field set to "City". The tax class is ""Taxable Goods".
Products are all set to tax class, "Taxable Goods".
Link to site: http://d i s t i n c t i v e d o g .com/store/index.php?main_page=index&cPath=1

Thanks for any help you can provide.

Quote:

---

Originally Posted by andrewj70

I have set up local sales tax for Washington State however the local city tax does not appear or calculate on orders. I set this up over two years ago and it's never worked. Everything appears to be set up properly except there is no Order Total Module for Local Tax. ...

---

No Order Total Module = Not Fully Installed = Will Not Work. Order Total Module Not Enabled = Will Not Work.

You will want to start by removing the more than two year old version of this module if partially installed. The next step would be to download the current version of this module and read the included instructions and examples. After reviewing all of the included documentation, install the current version of this module. When done, re-configure local sales taxes for Washington State.

How do I make actual tax % show up upon check out? It calculates everything correctly, but I'd like it to show tax rate to the customer as well.
Zen Cart v1.5.3, tax module 2.5.3a

Quote:

---

Originally Posted by bratan

How do I make actual tax % show up upon check out? It calculates everything correctly, but I'd like it to show tax rate to the customer as well.
Zen Cart v1.5.3, tax module 2.5.3a

---

If everything is installed and configured, than this information will be displayed during checkout on step 2 of 3 in the order totals block.
Do you see anything in this area for the tax rates?

Hello Zenners :)
I was hoping someone can help me here or lead me to a page where the solution might be located.

I have installed this module and it works perfectly, except the local tax is not defined as to what the price is on the 'order total'

I have defined that the local tax be 8%.
I buy $100 worth of stuff and the local sales tax is calculated to be $8.

Great so far, however, (as depicted in the photo) there is nothing that let's the user know what the $8 is they are being charged.
How can I define it to be 'Local Sales Tax' instead of the blank that appears there? I'm really a novice here trying to learn to be a zenner :D

Attachment 14399

Any help would be highly appreciated. :cool: thanks

Looks like you're missing a language define. Check your install for a missing file.

Quote:

---

Originally Posted by jeking

Looks like you're missing a language define. Check your install for a missing file.

---

Thanks for the reply. But I reinstalled everything again, however I am having no luck.
How do I check for missing install files, btw?

Quote:

---

Originally Posted by nesum18

Thanks for the reply. But I reinstalled everything again, however I am having no luck.
How do I check for missing install files, btw?

---

it seems like it is defined, but not working?

languages/english/modules/order_total/ot_local_sales_taxes.php

define('MODULE_ORDER_TOTAL_COUNTY_LOCAL_TAX_TITLE', 'Local Sales Tax');
define('MODULE_ORDER_TOTAL_COUNTY_LOCAL_TAX_DESCRIPTION', 'County/State Local Sales Taxes');
define('MODULE_ORDER_TOTAL_COUNTY_LOCAL_SALES_TAX', 'Sales Tax:');

Quote:

---

Originally Posted by nesum18

Hello Zenners :)
I was hoping someone can help me here or lead me to a page where the solution might be located.

I have installed this module and it works perfectly, except the local tax is not defined as to what the price is on the 'order total'

I have defined that the local tax be 8%.
I buy $100 worth of stuff and the local sales tax is calculated to be $8.

Great so far, however, (as depicted in the photo) there is nothing that let's the user know what the $8 is they are being charged.
How can I define it to be 'Local Sales Tax' instead of the blank that appears there? I'm really a novice here trying to learn to be a zenner :D

Attachment 14399

Any help would be highly appreciated. :cool: thanks

---

It Looks like you did not completely setup the "Location / Taxes" selections, the information you point to is from these entries, see attached images.

The overall "Tax Rates" Description field is used on the form where you point.
Attachment 14400

If you need to setup "Local Sales Taxes" this next image may help, again the Tax Description field will show on the form in the area you point.
Attachment 14401

Quote:

---

Originally Posted by potteryhouse

It Looks like you did not completely setup the "Location / Taxes" selections, the information you point to is from these entries, see attached images.

The overall "Tax Rates" Description field is used on the form where you point.
Attachment 14400

If you need to setup "Local Sales Taxes" this next image may help, again the Tax Description field will show on the form in the area you point.
Attachment 14401

---

THANK YOU SO MUCH! :) Simple solution: I didn't add the Tax Description...lol:D

Is there anyway to cause this module to recalculate when a coupon is used? This would solve a lot of problems for me if this were to recalculate the taxes when a coupon is entered. Thanks.

Quote:

---

Originally Posted by batracy

Is there anyway to cause this module to recalculate when a coupon is used? This would solve a lot of problems for me if this were to recalculate the taxes when a coupon is entered. Thanks.

---

I could be wrong, it's been a while since I've used this, but try changing the Sort Order under Admin>Modules>Order Total

Quote:

---

Originally Posted by jeking

I could be wrong, it's been a while since I've used this, but try changing the Sort Order under Admin>Modules>Order Total

---

Do you have a suggestion as to what sort order might work? The state tax recalculates just fine, but the local tax does not. I currently have the local tax (order 310) following the state tax (order 300).

What order is ot_coupon?

Quote:

---

Originally Posted by jeking

What order is ot_coupon?

---

It is 280

Ok, I think I'm probably wrong then. I was thinking the coupon was being totaled after the tax, but that's not the case. Hopefully the author will jump in and clarify.

I can certainly make the change necessary to force the recalculation of tax if given some guidance. This is a really big problem for my site and I really need to get a solution soon.

Thanks in advance for any help!

Since there doesn't seem to be any support happening here, I've taken matters into my own hands (a dangerous thing) and hacked three files to support a rather odd but usable method to deal with handling local taxes using the existing "built-in" tax module. If anyone is interested in what I did, send me a message and I'll try to explain it.

Quote:

---

Originally Posted by batracy

Since there doesn't seem to be any support happening here, I've taken matters into my own hands (a dangerous thing) and hacked three files to support a rather odd but usable method to deal with handling local taxes using the existing "built-in" tax module. If anyone is interested in what I did, send me a message and I'll try to explain it.

---

Hi,
It has been a long time since I have had to look at this mod since it seems to be working for my needs.
To try and help, I have created a GitHub repository for this code and related issues to be worked when needed.

Anyone is welcome to work on it, and to contribute "Issues".

If you would like to share your recent changes "hacks" that would be great, you could post them to the Issues page of the repository.
Maybe we can use your change to create better module for all and post the update to the Plugins area.

Thanks.

Since the changes I made are not on or a part of this plug-in, but rather on the built-in tax module I thought I would just share what I did here.

Background: My store is located in the state of Colorado, United States. Further, it is located in the city of Loveland, within Larimer county. I am required to collect sales tax at the state level for anyone living within the state of Colorado, at the county level for those within Larimer county, and at the city level for those within Loveland.

Step 1: Define zones (yes, zones - not zone defines) for each of the zip-codes within Larimer county. These are defined as Country = United States, Zone Name = Colorado, 80537, Zone Code = CO. For my needs, this meant defining 24 new zones (one for each of the zip-codes)

Step 2: Define zone definitions - one for the State, one for the County, and one for the City

Step 3: For each of the new zone definitions, go to details and add each zone as appropriate. Note, state should be normal state zone, county includes all zip-code zones for the county except those for the city, and city gets those for the city.

Step 4: Create the appropriate Tax rates for each of State, County, and City.

Step 5: Add the following defines to your english.php file - found in your override folder

Code:

---

// defines to setup local taxes
  define('US_HOME_STATE_ID', '13'); // this is the zone_id from the database for Colorado
  define('US_HOME_STATE_NAME', 'Colorado');

---

Step 6: Modify the code in the following three files:
includes/modules/checkout_new_address.php
includes/modules/create_account.php
includes/modules/pages/address_book_process/header_php.php

The modification is the same in all three files:

Find the following code...

Code:

---

  if (ACCOUNT_STATE == 'true') {
    $state = (isset($_POST['state'])) ? zen_db_prepare_input($_POST['state']) : FALSE;
    if (isset($_POST['zone_id'])) {
      $zone_id = zen_db_prepare_input($_POST['zone_id']);
    } else {
      $zone_id = false;
    }
  }

---

and change it to...

Code:

---

    if (ACCOUNT_STATE == 'true') {
      $state = zen_db_prepare_input($_POST['state']);
      if (isset($_POST['zone_id'])) {
        $zone_id = zen_db_prepare_input($_POST['zone_id']);
// add hack to set up "state, zip" check for Colorado     
      if ($zone_id == US_HOME_STATE_ID) {
        $state = US_HOME_STATE_NAME . ", " . substr($postcode, 0, 5);  // format is now "Colorado, 80537"
        $temp_zone_id = $zone_id;  // saving this for test later if new format is not found
        $zone_id = false;  // have to do this or the db select will fail = disaster
      } else {
        $temp_zone_id = false;  // make sure this is false if we are not dealing with our home state
      }
// end hack     
      } else {
        $zone_id = false;
      }
    }

---

Also find the following code ...

Code:

---

      if ($found_exact_iso_match) {
        $zone_id = $zone->fields['zone_id'];
        $zone_name = $zone->fields['zone_name'];
      } else {
        $error = true;
        $error_state_input = true;
        $messageStack->add('addressbook', ENTRY_STATE_ERROR_SELECT);
      }

---

and change it to ...

Code:

---

      if ($found_exact_iso_match) {
        $zone_id = $zone->fields['zone_id'];
        $zone_name = $zone->fields['zone_name'];
//added hack to reset zone_id if "state, zip" combination was not found       
      } elseif ($temp_zone_id) {       
        $zone_id = $temp_zone_id;
        $zone_name = US_HOME_STATE_NAME;               
// end hack       
      } else {
        $error = true;
        $error_state_input = true;
        $messageStack->add('checkout_address', ENTRY_STATE_ERROR_SELECT);
      }

---

Note the changes I made are wrapped in "hack" comments

That's it. When a customer sets up their address and selects their state, and enters their zip code, the code changes ensure that the correct zone is selected for the state, zip combination. If you configure your tax and zones correctly, the built-in tax module will charge the correct amount of tax, and will recalculate the correct amount of tax when a coupon or gift voucher is used.

Note: two of the files can be modified in overrides, the the one in the pages folder cannot.

MODIFY FILES AT YOUR OWN RISK - this hack is not supported.

Thank you for sharing this.

Thanks for providing this information batracy. I have a question, because I'm in New York. We're required to collect tax for anyone in New York, however the tax rate varies based on County (there is no city tax). Currently, using the Local Sales Tax mod, the mod calculates 4% sales tax for anyone in NY and adds whatever County tax on top of that, but as many have noted it does not work properly with Coupons or Gift Vouchers. It calculates the tax on the full amount and ignores any discount from a coupon or gift certificate.

Using your method, how would I set up my tax zones? Would I have to create a Zone for each NY County zip code (There are currently 2234 zip codes used in the Local Sales Tax mod for NY)? I imagine I could write an SQL to do such a thing, but wanted to make sure I'm understanding your method correctly.

Quote:

---

Originally Posted by batracy

Since the changes I made are not on or a part of this plug-in, but rather on the built-in tax module I thought I would just share what I did here.

Background: My store is located in the state of Colorado, United States. Further, it is located in the city of Loveland, within Larimer county. I am required to collect sales tax at the state level for anyone living within the state of Colorado, at the county level for those within Larimer county, and at the city level for those within Loveland.

Step 1: Define zones (yes, zones - not zone defines) for each of the zip-codes within Larimer county. These are defined as Country = United States, Zone Name = Colorado, 80537, Zone Code = CO. For my needs, this meant defining 24 new zones (one for each of the zip-codes)

Step 2: Define zone definitions - one for the State, one for the County, and one for the City

Step 3: For each of the new zone definitions, go to details and add each zone as appropriate. Note, state should be normal state zone, county includes all zip-code zones for the county except those for the city, and city gets those for the city.

Step 4: Create the appropriate Tax rates for each of State, County, and City.

Step 5: Add the following defines to your english.php file - found in your override folder

Code:

---

// defines to setup local taxes
  define('US_HOME_STATE_ID', '13'); // this is the zone_id from the database for Colorado
  define('US_HOME_STATE_NAME', 'Colorado');

---

Step 6: Modify the code in the following three files:
includes/modules/checkout_new_address.php
includes/modules/create_account.php
includes/modules/pages/address_book_process/header_php.php

The modification is the same in all three files:

Find the following code...

Code:

---

  if (ACCOUNT_STATE == 'true') {
    $state = (isset($_POST['state'])) ? zen_db_prepare_input($_POST['state']) : FALSE;
    if (isset($_POST['zone_id'])) {
      $zone_id = zen_db_prepare_input($_POST['zone_id']);
    } else {
      $zone_id = false;
    }
  }

---

and change it to...

Code:

---

    if (ACCOUNT_STATE == 'true') {
      $state = zen_db_prepare_input($_POST['state']);
      if (isset($_POST['zone_id'])) {
        $zone_id = zen_db_prepare_input($_POST['zone_id']);
// add hack to set up "state, zip" check for Colorado     
      if ($zone_id == US_HOME_STATE_ID) {
        $state = US_HOME_STATE_NAME . ", " . substr($postcode, 0, 5);  // format is now "Colorado, 80537"
        $temp_zone_id = $zone_id;  // saving this for test later if new format is not found
        $zone_id = false;  // have to do this or the db select will fail = disaster
      } else {
        $temp_zone_id = false;  // make sure this is false if we are not dealing with our home state
      }
// end hack     
      } else {
        $zone_id = false;
      }
    }

---

Also find the following code ...

Code:

---

      if ($found_exact_iso_match) {
        $zone_id = $zone->fields['zone_id'];
        $zone_name = $zone->fields['zone_name'];
      } else {
        $error = true;
        $error_state_input = true;
        $messageStack->add('addressbook', ENTRY_STATE_ERROR_SELECT);
      }

---

and change it to ...

Code:

---

      if ($found_exact_iso_match) {
        $zone_id = $zone->fields['zone_id'];
        $zone_name = $zone->fields['zone_name'];
//added hack to reset zone_id if "state, zip" combination was not found       
      } elseif ($temp_zone_id) {   
        $zone_id = $temp_zone_id;
        $zone_name = US_HOME_STATE_NAME;       
// end hack       
      } else {
        $error = true;
        $error_state_input = true;
        $messageStack->add('checkout_address', ENTRY_STATE_ERROR_SELECT);
      }

---

Note the changes I made are wrapped in "hack" comments

That's it. When a customer sets up their address and selects their state, and enters their zip code, the code changes ensure that the correct zone is selected for the state, zip combination. If you configure your tax and zones correctly, the built-in tax module will charge the correct amount of tax, and will recalculate the correct amount of tax when a coupon or gift voucher is used.

Note: two of the files can be modified in overrides, the the one in the pages folder cannot.

MODIFY FILES AT YOUR OWN RISK - this hack is not supported.

---

Quote:

---

Originally Posted by gwynwyffar

Thanks for providing this information batracy. I have a question, because I'm in New York. We're required to collect tax for anyone in New York, however the tax rate varies based on County (there is no city tax). Currently, using the Local Sales Tax mod, the mod calculates 4% sales tax for anyone in NY and adds whatever County tax on top of that, but as many have noted it does not work properly with Coupons or Gift Vouchers. It calculates the tax on the full amount and ignores any discount from a coupon or gift certificate.

Using your method, how would I set up my tax zones? Would I have to create a Zone for each NY County zip code (There are currently 2234 zip codes used in the Local Sales Tax mod for NY)? I imagine I could write an SQL to do such a thing, but wanted to make sure I'm understanding your method correctly.

---

Yes, you are understanding this correctly and would need to setup all 2234 zip codes in order to define each of the county taxing entities. This method is not perfect because of the amount of work to set it up (and maintain should the zip codes change), and the fact that all the zip codes show up in the state dropdown box, but it does work. I have it setup now for both of my stores.

Also forgot to mention, change the define statements in the english.php file to your state (you will have to look up the zone_id for your state from the database). Also, be aware that if you are not using the dropdown box for the state selection this method of getting the correct state, zip combination does not work, and would require some code changes.

I think I'll wait until someone updates this mod as it is. Having 2000+ NY zip codes show in the dropdown for someone checking out is completely impractical for our store as we do a very small percentage of our business in our own state. Thank you for providing the information for this option, though!

The new store pickup mod (updated as of 1.5.4) does not work with local sales taxes any longer.

I know it has been mentioned before in this thread, but have you tried the TaxCloud module? https://GitHub.com/TaxCloud/ZenCart

Based on the TaxCloud forum thread, it appears that the current plugin version of TaxCloud here on Zen-Cart.com is not fully compatible with version 1.5.4. I'd be happy to use it if it were.