Local Sales Tax Mod (with admin!) for testing

[jaylyns]

Thank you so much for your help. And thanks for creating the much needed mod.

[LadyHLG]

You are welcome!

Have a good evening.

LadyHLG

[JoelMMCC]

I have a strange situation. We have Local Sales Tax Mod 2.0a (I wish the version number in the header comments of ot_local_sales_tax.php file included the “a”!) originally installed in Zen Cart 1.3.7, which has since been upgraded to 1.3.8a.

It used to work fine under Zen Cart 1.3.7, but now does not show the tax. It calculates the tax just fine, but does not show it in the “Your Total” section of the Checkout Step 2 — Payment Information page (?main_page=checkout_payment). It shows the Sub-Total, Shipping, and State Sales Tax, then the Total.

Configuration in Admin / Modules / Order Total is as follows:

This module is installed
true

Sort Order
350

Debugging is active
false

Local Sales Taxes are set up as follows:

ID | Tax Zone | Apply To | Look For | Tax Rate | Tax Description | Tax Shipping | Tax Class
3 | Louisiana | postcode | 71101 | 4.6000 | Shreveport and Caddo Parish (incl. School Board) sales tax | true | Taxable Goods
4 | Louisiana | postcode | 71103-to-71109 | 4.6000 | Shreveport and Caddo Parish (incl. School Board) sales tax | true | Taxable Goods
5 | Louisiana | postcode | 71111-to-71112 | 5.0000 | Bossier City and Parish sales tax | true | Taxable Goods
6 | Louisiana | postcode | 71115 | 4.6000 | Shreveport and Caddo Parish (incl. School Board) sales tax | true | Taxable Goods
7 | Louisiana | postcode | 71118-to-71119 | 4.6000 | Shreveport and Caddo Parish (incl. School Board) sales tax | true | Taxable Goods
8 | Louisiana | postcode | 71129 | 4.6000 | Shreveport and Caddo Parish (incl. School Board) sales tax | true | Taxable Goods

Originally I only had two entries (IDs 1 & 2, thus the gap at the beginning), one for Shreveport and one for Bossier City (I edited and overrode the Address Book collection templates to only allow those two cities via Radio Buttons, and their respective Zip Codes using a SELECT list, with JavaScript to force-match Zip Code to City, to minimize the chances of customer input error [misspelling the City name, for instance] messing things up), using “City” as the Apply To. But when it stopped appearing, I tried switching to “postcode” thinking that it wasn’t detecting at all, but turning on Debug and also doing the calculations myself showed that it is, but just not showing.

HALLLLP!!

[LadyHLG]

JoelMMCC,
Just so I understand this correctly is the local tax being added to the total in the cart and just not outputting the line that say what the tax was?

LadyHLG

[JoelMMCC]

Here is what we currently see with Debug enabled, for a user in a zip code within the range for Local Sales Tax Zone ID #4:

—Your Total———
Local Tax Rec ID: 4
Tax Name: Shreveport and Caddo Parish (incl. School Board) sales tax 4.60% — 3.27

Sub-Total: $71.03

Free Delivery (Next Tue. or Thur. within Shreveport / Bossier City): $0.00

Louisiana State sales tax: $2.84

Total: $77.14

Note that the Louisiana State sales tax is displaying, but not the Shreveport + Caddo Parish* sales tax. Note also that the calculated Total does include the Shreveport + Caddo Parish sales tax ($71.03 + 0.00 + 2.84 + 3.27 = $77.14).

*(Louisiana has Parishes instead of Counties, being of French rather than English origin.)

[LadyHLG]

JoelMMCC,
Change the sort order for the local sales tax mod to a number lower than the tax in the order total admin.
So if your tax is set to a sort order of 300, set the local tax to 299.
Let me know if that makes a difference.

LadyHLG

[JoelMMCC]

JoelMMCC,
Change the sort order for the local sales tax mod to a number lower than the tax in the order total admin.
So if your tax is set to a sort order of 300, set the local tax to 299.
Let me know if that makes a difference.

LadyHLG

That did it! Thanks much!

I’m extremely impressed with how well you support your work, and how quickly you responded! Within minutes each time! Not bad for a free Mod!

Oh, and the Mod itself is awesome, too! I got both it and the Sales Tax Report, which hasn’t been a problem at all!

[LadyHLG]

Glad things are working again!
Thank-you for the feedback on the mod, I am happy so many people have found it useful and its always nice to know its appreciated!

FYI - I am sorry about the confusion with the version number in the file header comments. I was rushing to post a correction to a big calculation error and forgot to change it. I guess it always pays to take your time and do things right!



LadyHLG

[ixboat]

LadyHLG,

Please accept my most sincere thanks for this local sales tax module, it seems to be working great on my 1.3.8 ZenCart site, but I have no orders through the system yet, it's a brand new site that I'd like to go live with this week.

I'm just learning ZenCart these past few months and it's great to have such an active contributing developer community, and so much help.

I wanted to let you know that I had one little challenge with the install of this version: Local Sales Tax Mod for Zen Cart Version 2.0n

Here's what happened:
(1) Copy all files inside the catalog folder to your cart
WORKED
(2) Run the LocalSalesTaxv2.0.sql file
WORKED
(3) In Cart Admin navigate to Modules -> Order Total, and click on "Local Sales Taxes"
(4) Click the "install" button.
WORKED
(5) In Cart Admin navigate to Locations/Taxes --> Local Sales Taxes and edit accordingly
Here, got an error about it not seeing the required MySQL db filename

SO, i changed the first line in LocalSalesTax2.2.sql
from
CREATE TABLE `tax_rates_local` (
to
CREATE TABLE `zen_tax_rates_local` (

and that ran OK,

and the Local Sales Tax is calculating and displaying ok, seem like.

Questions:
1. did I miss something in the (very clear) install instructions?
2. is there something else to worry about that I don't know about yet?

and, now I shall try out the reporting module!

Thanks
ixboat

[ixboat]

Sorry, that version # above is off....

The readme.txt says:
Local Sales Tax Mod for Zen Cart Version 2.0

and the file date is 12-18-2007

should I go to 2.0a
and if so, where is that file please?

thnx
ixboat