Local Sales Tax Mod (with admin!) for testing

[sublime19]

No, i want to be able to enter in all the zipcodes, so no limit of 100 char. I will look at the code later today and see if i can figure it out, but would appreciate any input. if this works, I will upload the excell document i am using that breaks down each county by zipcodes for california and shows the tax rates.

Also someone said this mod doesn't support group discount pricing is this true? wouldn't it just take the total at checkout with the discounts included and tax that?

[LadyHLG]

You will have to change the table properties in the database. If you plan to enter the zip codes via the admin then you will have to change the properties of the field used to enter the data, it was not intended to enter long strings.

As for group discounts, yes the mod will work with them, but a lot depends on the sort orders for the Order Total modules as well as the setting for the group discount in the admin under Modules -> Order Total.

LadyHLG

[sublime19]

local_datamatch changed to text, there was no limit on the data field input, but when i put the figures in, on the display in admin local sales taxes page, the field goes way to the left now, how would i correct this?

Looks like that is the only change i will have to make though.

[sublime19]

figured out a way that works, edited admin/local_sales_taxes
don't know what line, using wordpad


<td class="dataTableContent" align="center"><?php echo $localtax->fields['local_datamatch']; ?></td>

to

<td class="dataTableContent" align="center"><?php echo wordwrap($localtax->fields['local_datamatch'], 90, "\n", true); ?></td>


works like a charm.

I will be doing testing today to verify that this adjustment works okay and give you updates. thanks for the help so far!

[LadyHLG]

Glad to see you got it worked out!

LadyHLG

[doodlebee]

Okay, so I don't know if this is some weird bug or if it's how I have things set up. I'm testing out this mod right now (*Very* nice :) ) but I'm having a couple of issues. one I've managed to work around, but I don't know if maybe this "bug" is showing up *because* of said workaround or not.

So, I enter taxes like so:

29621-to-29627;29654-to-29656;29699;29670;29677;29684;29689;29697

These zip codes get a 7% tax rate. (I've also tried it listing out the zip codes individually, rather than using ranges - same thing happens either way....)

now the possible "bug". My default address is set at the 6% (default) tax rate. If I change my address zip code (during the check out process) to a zip code of say. 29670 (to reflect the 7% tax rate), it'll change properly in the cart. But if I try to change it to any other address, the tax rate *never* changes - it'll stay stuck at 7%. So it seems I can only change my address once. (I mean, I can change the address as much as I want - but the tax rate only changes *once* and never again. If I try to change the address a second time, the tax rate - once it's been changed - stays no matter what I change the address to.)

The only way I can seem to get around this is by logging out and logging back in and then changing it to the proper address.

For the record, I'm using the latest (as of this writing) versions of both ZenCart (1.3.8) and Local Sales Tax (2.1).

[LadyHLG]

My default address is set at the 6% (default) tax rate.

I'm not sure what you mean here by default.

Also, what kind of work around did you make?

LadyHLG

[doodlebee]

>>I'm not sure what you mean here by default.<<

Well, the default tax rate for the state in question is 6% - but on this thread, I mean that I'm starting at 6%. The address I'm using - and zip code - is a 6% rate, and it's my default test address. So, by default (if I don't change the address) I should be charged 6% because of my zip code.

If I change the address (i.e. changing the zip code) to get a different tax rate, the tax rate will change to the right one. (For purposes of example, the new changed zip code is a 7% tax rate). Changes as it should. But if I try to change the address *again* (either by a new zip code with a different tax rate, or swapping back to my default address for the 6% rate), it forever remains 7%. The only way I've found is to log out and log back in, and change the address - seems you can only change it once.

The workaround was to *not* use the "-to-" for ranges. I put in every zip code. This also meant, in some cases, I had more than 100 characters, to I went to the table and changed the varchar to 200 rather than 100.

[LadyHLG]

Which address are you changing the Billing address or the shipping address - ie Is it the address in step 1 or step 2?

[doodlebee]

Well, I've tried it all kinds of ways - trying to use it like a customer would. I've done it both in Step 1 *and* Step 2. Using my mother as an example - where she'll get partway through the process and remembers he wants it shipped to someone else, so she'll change the address. I can't honestly say off the top of my head if it's specifically one or the other that does it...but I'll go try it now and see if doing it in one or the other makes a difference.

Hang on, and I'll report back :)