Local Sales Tax Mod - Support Thread

zcnb:

No, I kept the default 250. I will try this shortly and see whether this helps. What value do you recommend?

I changed the sort order to 301 (one above Tax) but that didn't help.

I also changed the permissions on the mod's .php files from 644 to 755, but that didn't help either.

I must be doing something fundamentally incorrect but what is it?

Its difficult to say what could be causing the problem.
First, double check your tax class to be sure the products you are using to test with match the tax class set up for your local tax, I've seen this cause problems many times.
Also, have you installed any other mods that could possibly conflict with this one?
LadyHLG

LadyHLG:

First, double check your tax class to be sure the products you are using to test with match the tax class set up for your local tax,
I have only one tax class (my state's sales tax). Should I define a new tax class for this local sales tax?

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

LadyHLG:

Also, have you installed any other mods that could possibly conflict with this one?
Other than installing the GV bugfix, I installed only one mod (aka "add on") - CAPTCHA by Andrew Berezin. That add on worked and continues to work flawlessly.

I just have to make yours work (for me - I know it works for others). :smile:

Thanks,
Daniel

No, you should not need to create a new tax class, you just need to be sure the tax class is assigned to your test product and to the local tax.

The debugging info will show up in the checkout area above the cart total summary, but it will only show if the local sales tax is actually being applied.

I'm not sure what else to suggest at this point. If you would like I could take a look at the admin settings. If that's what you would like to do you can PM me with log-in info.

LadyHLG

LadyHLG, thank you very much for your help. I just PM-ed you the required info.

BTW, I also checked whether this has anything to do with the infamous DOS vs. UNIX end-of-line. My host is Linux based. All Zen Cart .php file have DOS end-of-line (CRLF), so this couldn't be the source of the problem.

Hello. I have be working with this mod and it is great, thanks so much for putting this out there. I am working on a table for NC, with Counties, City, Zip. So I will post that when I am done.

But I am having one issue. Here is an example of what my checkout window looks like:

-----------Your Total---------------------

Your TotalLocal Tax Rec ID: 1
Tax Name: 28678 Alexander County Tax 2.75% - 0.55

Sub-Total: $19.95

Per Item (Best Way): $4.95

NC State Tax 4.25%: $0.85

Total: $26.30

So at first glance I notice that the amount was right, but I didn't see the local tax amount, and then it was at the top, not listed under NC State Tax 4.25% like I thought it would be.

Do you know if there is anyway to fix this?

Thanks again for all your help!!

Kokopelli628:

So at first glance I notice that the amount was right, but I didn't see the local tax amount, and then it was at the top, not listed under NC State Tax 4.25% like I thought it would be.

Do you know if there is anyway to fix this?
Kokopelli628, I wish I were at your situation. :smile:

I am still at lost with my own problem, but if I understand your problem correctly, you just need to turn off "debug mode" where you install/uninstall or enable/disable this module.

Also, you may want to change the sort order from the default 250 to 301 or higher.

Lastly, I hope that you applied the GV bugfix, otherwise you will have calculation errors when customers use gift vouchers (aka gift certificates).

HTH,
Daniel

Daniel,

Thanks for the tip. That did take if off the top, but it is not showing up at all now, but the calculation is still correct, go figure!

I will have to go in and debug the GV, too.

Thanks for that as well!!

Kokopelli628,
Make the sort order for the local sales tax mod lower than that for the tax. So if your tax sort order is 300 make the local sales tax 299.

Does the output show now in the totals?

LadyHLG

LadyHLG:

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

I've just installed this mod--thanks! Being from NY has made collecting sales tax a nightmare... my issue:

When I goto Local Sales Taxes I get this messsage (like another poster):

1146 Table 'chargeshop.tax_rates_local' doesn't exist
in:
[select count(*) as total FROM (tax_rates_local st LEFT JOIN tax_class tc ON st.local_tax_class_id = tc.tax_class_id) LEFT JOIN zones z ON st.zone_id = z.zone_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have no other modules installed, just Zen Cart 1.3.8a.

Was the quote above for fixing this problem? If so, I still don't know what I should do. Would you please explain it a bit more? Thanks!

It looks like the mod can't find the table. Did you have any probelms with the sql install? You need to verify that the table actaully exists in the database.
LadyHLG

Thanks for the quick response!

I wasn't sure if it installed correctly, but it showed up in the drop down menu so I thought it must have. Is there somewhere I can go to dwonlad that table, then a spot I should put it in on the ftp? Or another type of fix? I looked for a way to unistall to try again but couldn't figure it out.

As part of the mod there is a folder called
FullVersion\sqlfiles\NewInstall
With a file called LocalSalesTaxv2.2.sql
You need to use the cart admin Install SQL Patches to run the sql file and create the table.

LadyHLG,

That did the trick!

Thanks so much!!

I don't know how to do that--after much searching and some vain attemtps, I haven't figured it out.

I see that file on my computer and have attempted to upload it but I don't see anything happen and I don't know anything about the "query to be executed" feature. Is ther a tutorial or some info somewhere you could link me to? I couldn't find any details of how to do it on my own.

When you say upload the file do you mean upload it via the Install SQL Patches upload or upload via ftp?

(Obviously a newbie...)

On the install sql patches page there's a query execution box and an upload file box--I used the upload file box section. That didn't fix the error, and I don't know how to use the query execution box.

When you upload the file does it give you an error message or any time of message at all?

OK--just tried again and there's a little failed message at the top of the page, but there's no text besides "Failed:"

Ok, so instead of uploading the file, open it (you can open it with any type of text editor). Copy everything in the file and paste it into the query execution box on the Install sql patches page.
If it fails again try adding a semicolon ";" at the end of the last line.