Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / Currencies & Sales Taxes, VAT, GST, etc. / Local Sales Tax Mod - Support Thread

Local Sales Tax Mod - Support Thread

Results 1 to 20 of 659
28 Oct 2008, 17:19
#1
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Local Sales Tax Mod - Support Thread

Welcome!

Support Thread for the Local Sales Tax Module
Available for Download --> HERE


I thought it was time to begin a new support thread for the Local Sales Tax Mod mainly because the old thread was getting a bit lengthy and the title was somewhat misleading since the mod has moved way beyond the testing phase.

The previous support thread can be found Here


A Little Info on the Mod
The module should apply tax based on the field you choose options are Zip Code, City, and Suburb.
It should also compound the tax to whatever zone taxes you already have set up.
Which means you can apply multiple taxes to any zone based on different criteria.

Even though this mod does not overwrite any core files or effect any data tables, its ALWAYS a good idea to backup your DB and files.

LadyHLG
30 Oct 2008, 13:35
#2
kokopelli628 avatar

kokopelli628

New Zenner

Join Date:
Oct 2008
Posts:
8
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

I am so happy you have started a new thread for this.

I am having trouble uploading the mod to my site. When I upload the sql file, it just says, "Failed" at the top of my admin panel.

I went through the last thread and saw someone who had the same problem, so I tried to follow the direction there, but was unsucessful. :dontgetit

Please help! Thanks so much!!!
30 Oct 2008, 13:41
#3
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

So did you try to copy and paste the sql statment into the text box rather than upload the sql file?

LadyHLG
30 Oct 2008, 14:16
#4
kokopelli628 avatar

kokopelli628

New Zenner

Join Date:
Oct 2008
Posts:
8
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

No way, I have tried that before and it didn't work, but this time it did.

I added a ; at the end of the code and it went through! Zen cart notes "be sure to end with ;"

Awesome Thanks!!! :clap:
30 Oct 2008, 15:05
#5
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

Glad to hear things are working.

LadyHLG
31 Oct 2008, 18:01
#6
rory avatar

rory

New Zenner

Join Date:
Apr 2008
Posts:
16
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

I have installed the local sales tax mod

Local Sales Tax Mod for Zen Cart Version 2.2
By:Heather Gardner (LadyHLG)
Based on several prior local sales tax mods.
Modifications by: Qian Gu (guqian)
Support Thread at Zen Cart Fourms --> http://www.zen-cart.com/forum/forumdisplay.php?f=37

and quantity discounts

Quantity Discounts Module for Zen Cart 1.3.5 and above
Version 1.8
Author: Scott Wilson
http://www.thatsoftwareguy.com
Zen Forum PM swguy

and am having problems with my order total. If I change the sort in order total so the quantity discounts come before sales tax, then the quantity discount is not included in the "Total Amount". If I change the sort order so it is after sales tax, then it is reflected properly in the "Total Amount" of the order. Gift Certificates (redeemed) are similar if the sort order is before sales tax in that the "Total Amount" of the order excludes the gift certificate in the calculation. However, if the sort order for the gift certificate is after the sales tax, the "Total Amount" is totally screwed up almost double what it should be. Can someone help me out here?
thanks.....
03 Nov 2008, 15:54
#7
rory avatar

rory

New Zenner

Join Date:
Apr 2008
Posts:
16
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Update on previous thread on Gift Certificates:



Sub-Total: $5.00

Flat Rate (USPS Flat Rate Shipping): $5.00

98101 SEATTLE 9.00%: $0.90

Gift Certificates: -$8.17



Total: $4.56



In order for the Gift Certificate to calculate, I have to set the sort order after local sales tax. When I do that, the sub-total, shipping, and gift certificate are doubled.

Sub Total = 10.00
Shipping = 10.00
Gift Certificate = -16.34
Sales Tax = 0.90

Total = 4.56

Does anyone know why this is happening? Can you help me out?
03 Nov 2008, 16:10
#8
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

I am currently on a deadline with a client, I will try to take a look at your issues when I have completed my current project.
I will help but the bills have to be paid first.
:smile:

LadyHLG
03 Nov 2008, 23:35
#9
rory avatar

rory

New Zenner

Join Date:
Apr 2008
Posts:
16
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Thanks!!!!

I have until the 21st when the site goes live, so no problem there. I really appreciate your help.

THANKS!!!
05 Nov 2008, 15:28
#10
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

Rory,
Still looking into this but I am wondering if you have seen this post:
http://www.zen-cart.com/forum/showthread.php?t=83928&highlight=Re-calculate+Tax

It appears there is calculation error in the gift cert totals in version 1.3.8. Before we proceed I need to know what effect the bug fix has on the totals you are seeing.

Thanks
LadyHLG
05 Nov 2008, 23:29
#11
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

LadyHLG, first let me thank you for this great mod which seems to be exactly what I need.

I managed to install your package without any problem. My only problem now is how to enter my own state's information into your module.

I selected Location/Taxes > Local Sales Tax, then click the [new tax rate] button.

Now, I have a list of towns (not ZIP codes) in my state which have local sales tax. How do I enter that list?

I only noticed the following instructions for ZIP codes:
What data are we searching for?
For Ranges use "-to-" for seperator
example: 53000-to-56000.


What do I use to separate the towns in the list? commas? spaces? How do I enter towns that have spaces in them (e.g. "East Springfield")?
05 Nov 2008, 23:44
#12
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

City names can be entered one per record or in a semi-colon delimited list, (with spaces as is).

ie - Smallville; Gotham City; Metropolis

Obviously, cities don't have ranges so you can disregard that.

LadyHLG
05 Nov 2008, 23:50
#13
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Thank you very much! This is clear now.

Unfortunately however, it seems that I was too quick to declare that I installed without any problem. Now that I try to do a test checkout, I receive the following in step 2 of 3 (Payment Information):

Your Total
1146 Table 'zc_store.TABLE_LOCAL_SALES_TAXES' doesn't exist
in:
[select local_tax_id, zone_id, local_fieldmatch, local_datamatch, local_tax_rate, local_tax_label, local_tax_shipping, local_tax_class_id from TABLE_LOCAL_SALES_TAXES where zone_id = '']


Have you seen this before? What could be causing this?
06 Nov 2008, 00:05
#14
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Just in case the following could be helpful in diagnosing the above problem: I suspected the the table that was supposed to be created by running LocalSalesTaxv2.2.sql wasn't really created.

I decided to re-run it (via the edit box (copy & paste) because the 'upload file' doesn't really work) and I received the following which looked familiar from the first run (which I mistook for a non-failure):
Query Results:
CREATE TABLE tax_rates_local ( local_tax_id int(11) NOT NULL auto_increment COMMENT 'tax id', zone_id int(11) default NULL COMMENT 'zen cart zone to apply tax', local_fieldmatch varchar(100) default NULL COMMENT 'name of field from delivery table to match', local_datamatch text COMMENT 'Data to match delievery field', local_tax_rate decimal(7,4) default '0.0000' COMMENT 'local tax rate', local_tax_label varchar(100) default NULL COMMENT 'Label for checkout', local_tax_shipping varchar(5) default 'false' COMMENT 'Apply this tax to shipping', local_tax_class_id int(1) default NULL COMMENT 'Apply to products in what tax class', PRIMARY KEY (local_tax_id) );


Any idea what I could be doing wrong?

Update: wait a minute... I didn't see the top pink bar containing the error message. It says:

Failed: 1
Error ERROR: Cannot create table tax_rates_local because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
06 Nov 2008, 00:43
#15
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

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
06 Nov 2008, 00:53
#16
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Update: baffled by the mismatch by the table names (TABLE_LOCAL_SALES_TAXES vs. tax_rates_local) I tried to see where that TABLE_LOCAL_SALES_TAXES could possibly come from. I found two places in which TABLE_LOCAL_SALES_TAXES should be substitued by 'tax_rates_local'

[PHP]define('TABLE_LOCAL_SALES_TAXES', DB_PREFIX . 'tax_rates_local');[/PHP]

That led me to find what my problem was: I forgot to upload one file: /includes/extra_datafiles/ot_local_sales_taxes_databse_tables.php


See what I mean by "applying patches manually is error prone"? :mellow:

I wish there were a way to unpack the entire package into the directory structure in one step. Something like 'tar -xvf LocalSalesTaxModv2.2.tar'.

Thanks again for your great mod. Now I am going to check the correctness for the calculations. :smile:
06 Nov 2008, 15:22
#17
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

Unfortunately, this mod seems to be not working for me. I repeated all steps properly this time - from the beginning (on a test store of course) - but I keep getting calculations as if no local sales tax is defined.

I mean, everything works just as before: State tax is applied but the local sales tax is simply not there:

Your Total
      Sub-Total: $1.98
  Free Shipping: $0.00
State Sales Tax: $0.12
          Total: $2.10


Shouldn't there be another line for local sales tax?

What could have I done wrong in installing/configuring this mod?
06 Nov 2008, 15:26
#18
ladyhlg avatar

ladyhlg

Zen Follower

Join Date:
May 2005
Posts:
361
Plugin Contributions:
1

Re: Local Sales Tax Mod - Support Thread

Have you tried changing the sort order of the mod?
LadyHLG
06 Nov 2008, 15:35
#19
rory avatar

rory

New Zenner

Join Date:
Apr 2008
Posts:
16
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

On the Gift Cert Mod, your link to the calculation error in gift cert totals worked. All the totals are correct!

I really appreciate your help. This is a great mod and will put our store in compliance with the new destination based sales tax in WA.

I really appreciate your help on this!!

:clap:
06 Nov 2008, 15:38
#20
zcnb avatar

zcnb

Zen Follower

Join Date:
Jun 2008
Posts:
338
Plugin Contributions:
0

Re: Local Sales Tax Mod - Support Thread

LadyHLG:

Have you tried changing the sort order of the mod?

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

Also, should I define a new tax class for it, or should I just use the existing tax class for the state?

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

Thanks,
Daniel