Local Sales Tax Mod - Support Thread

Thank you so much for all the help--that did it! Off to customize!

(Ahhh memories of Pascal and the semicolon....)

Glad things are working now.
LadyHLG

Hello all,
I'm sorry to say we have discover a bug in the local sales tax mod. (Thanks to Daniel for bringing this to light!)
The bug occurs when a customer purchases a downloadable product or products only.

I am attaching a new file here that hopefully corrects this error, it also has more detailed debugging to help locate problems in the future.

Use the attached file to replace includes\modules\order_total\ot_local_sales_taxes.php

If anyone encounters any other issues please let me know asap, I will wait a few days before posting the new file to the downloads.

LadyHLG

LadyHLG:

I am attaching a new file here that hopefully corrects this error, it also has more detailed debugging to help locate problems in the future.
LadyHLG, thank you very much for trouleshooting and fixing this problem. The speed at which you did that is impressive!

I would like to add to the existing documentation that, when listing towns/cities in the 'Search Data' edit box ("Search Field = city"), separating names by a semicolon, there must not be any leading or trailing spaces.

That is, the following list will work:

Smallville;Gotham City;Metropolis

While the following will not work for the last two in the list:

Smallville; Gotham City; Metropolis

Thank you again, LadyHLG. You have done a marvelous job.

Daniel

Thank-you Daniel for correcting this.
Also, please note that the README.txt file in the mod is incorrect as its states:

Version 2.2 Updates************************************
Allow for both single zip codes and zip code ranges mixed into a single record.

This update should allow for zip code entries like:
53528;53711-to-53720;53524;54302-54310 Which mixes both the ranges and the single entries in one comma delimited list.

Updated admin to allow for larger data entries-- Thanks to sublime19 for this!!
Changed local_datamatch field to text to allow for more data

It should say "semi-colon delimited list".
I will make sure this is corrected in the next version, and see if we can do some error checking to remove spaces just incase.

LadyHLG

The spacing issue with the delimited lists actually revealed a problem with the file posted above.
I am attaching a new file for everyone to try.
That also checks for spaces in the delimited list.
LadyHLG

Hi,

I'm new to Zen but not new to web programming and db stuff in general.

I've installed the mod and uploaded the data for FL. Everything seems to be ok from the database side. I only have one tax class.

The problem I'm seeing is that the local sales tax isn't showing up on the Payment Information page. I saw in an earlier post you mentioned changing the mod sort order. But I'm unsure of what/where that is.

Any help is greatly appreciated.

Lee

Check in the admin under
Modules -> Order Total
First, make sure the mod is turned on then try changing the sort order number I have mine set to 299, but it can vary depending on what other Order Total mods you have.

(Also be sure to download the file from post #46 above which has a bug fix!)

LadyHLG

ok thanks.. it wasn't on but I'm still not seeing the tax. I turned on debug and it seems the mod is hitting the db.

Did you adjust the sort order?
LadyHLG

Yes, I made it 299 and Tax is 300.

What do you get when you turn on debugging?

I've attached the text. Was rather verbose ;)

Sorry about the lengthy debug, its the only way to see how the cart is checking the taxes the, final posted version wont be so long, but for testing I left it in.

A couple of questions what zip code are you using to test with and how many actual local sales taxes do you have set up.
The number can be found on the local taxes admin page at the bottom left corner should look something like this..

Displaying 1 to 5 (of 5 local taxes).

LadyHLG

For the benefit of NEW installs (i.e. not updates/upgrades) of this mod, I am including a .tgz file that, if you place in the store's root (aka 'catalog' or top-level directory) and perform a tar -zxvf, it will copy all necessary files in one step.

This can prevent problems of forgetting to copy one (or more) of the .php files nested in the various subdirectories (as happened to me).

Please note: this file is attached as a ZIP file, but it is not a zip file. You need to change its extension to .tgz or .tar.gz before attempting to ran 'tar -zxvf' on it.

LadyHLG, you are welcome to include this in your package (along with clear instructions as how to use it).

Here are the instructions how to use this file:

1. Copy local_sales_tax_mod_2.2.2.zip to your store's <catalog> directory (usually "store" or "shop").
2. Rename it to local_sales_tax_mod_2.2.2.tgz
3. Run (from the shell) the following command:
4. tar -zxvf local_sales_tax_mod_2.2.2.tgz
5. Delete the file local_sales_tax_mod_2.2.2.tgz

LadyHLG, if you want to generate this file for future versions, the way to do this from the command line is:```
cd LocalSalesTaxModv2.2/FullVersion/catalog
tar --owner 0 --group 0 -zcvf local_sales_tax_mod_2.2.2.tgz *

I hope this will be helpful to others as much as it is helpful to me.

Daniel

Where does the "suburb" field show up? In the customer profile? I'd like to use that option instead of the city or the zip code.

The "suburb" field is actually the second address line I believe its labeled "Address Line 2:".

LadyHLG

No worries.. I wish I wrote tracing logs that had that much detail ;)

A couple of questions what zip code are you using to test with and how many actual local sales taxes do you have set up.

i'm using 33139.

There are 63. I grabbed the FL Sales SQL file from:

http://streamlined-sales-tax.blogspot.com/2008/01/zen-cart-and-streamlined-sales-tax.html

Thanks

LadyHLG:

The "suburb" field is actually the second address line I believe its labeled "Address Line 2:".

LadyHLG

That is what I needed. It's working well so far. Thanks!

Well the mod matched the tax

We have a single-33139
Single value 33139 matches
Tax Class Sub Total = 0

But didn't return a taxable subtotal.

So the first thing to check is that the product you are testing with is actually assigned to your tax class.

LadyHLG