Local Sales Tax Mod - Support Thread

[fotofx]

Very strange indeed. I even pulled the query out and ran it in Navicat and it brought up the countries just fine. Seems to not work in Zen Cart with the query factory.

[jasmel]

Hi jasmel,

Please check out my previous posts to get a firm grasp of what I have implemented with my site:
http://www.zen-cart.com/forum/showth...030#post727030
http://www.zen-cart.com/forum/showth...607#post901607
http://www.zen-cart.com/forum/showth...543#post908543

For Washington State, I just kept the zone id the same = 62.
The rate should be 6.5%.
The local sales tax rate is added on top of the state tax rate.

Hope this helps.
-Jason

Great help! **Just got an email from WA about the new rates for Oct-Dec

[Eric24v]

Has anyone installed this on version 1.3.9d and got it to work?

[larryweiss]

I have installed the Local Sales Tax Mod. The setup for New York State tax rates is monstrous.

In the several threads regarding this mod, there is a suggestion to use The "New York State Tax Table" from b-u-s-h-k-i-l-l-f-a-r-m-e-s dot com

The table seems like just the thing to cut a weeks work to a minutes work. The problem is, I don't understand it's use. It is probably a simple cut and paste using phpMyAdmin, but I am clueless as to how to do it. Can anyone advise me.

Can someone tell me EXACTLY what to do here?

The file begins with:

zen cart local sales tax - NY county tax by zip code
-- compiled by edited.com-- Please report errors to [email protected]
--
-- Table structure for table `tax_rates_local`
-- Remove Old Table First

DROP TABLE IF EXISTS `tax_rates_local`;

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` varchar(100) default NULL 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`),
UNIQUE KEY `local_datamatch` (`local_datamatch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2263 ;

--
-- Dumping data for table `tax_rates_local`
--

INSERT INTO `tax_rates_local` VALUES (1, 43, 'postcode', '00501', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (2, 43, 'postcode', '00544', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (3, 43, 'postcode', '06390', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (4, 43, 'postcode', '10001', 4.3750, 'New York County Sales Tax', 'true', 1);


And then goes on with hundreds of similar lines.

Please help

[retched]

I have installed the Local Sales Tax Mod. The setup for New York State tax rates is monstrous.

In the several threads regarding this mod, there is a suggestion to use The "New York State Tax Table" from b-u-s-h-k-i-l-l-f-a-r-m-e-s dot com

The table seems like just the thing to cut a weeks work to a minutes work. The problem is, I don't understand it's use. It is probably a simple cut and paste using phpMyAdmin, but I am clueless as to how to do it. Can anyone advise me.

Can someone tell me EXACTLY what to do here?

The file begins with:

zen cart local sales tax - NY county tax by zip code
-- compiled by edited.com-- Please report errors to [email protected]
--
-- Table structure for table `tax_rates_local`
-- Remove Old Table First

DROP TABLE IF EXISTS `tax_rates_local`;

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` varchar(100) default NULL 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`),
UNIQUE KEY `local_datamatch` (`local_datamatch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2263 ;

--
-- Dumping data for table `tax_rates_local`
--

INSERT INTO `tax_rates_local` VALUES (1, 43, 'postcode', '00501', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (2, 43, 'postcode', '00544', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (3, 43, 'postcode', '06390', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (4, 43, 'postcode', '10001', 4.3750, 'New York County Sales Tax', 'true', 1);


And then goes on with hundreds of similar lines.

Please help

Essentially it is, although, i wouldn't go about using it in THAT manner. However, I would recommend using the Install SQL Patch, after you fully backup your SQL table. I have Local Sales Tax Mod with the New York State tables already defined if you want to use it. It groups the tax rates by rate, then by local zip code. You might find it handle, and a lot less cumbersome then each zip getting its own row in that table.

[fotofx]

Has anyone had a problem with it doubling the tax?

Sub Total $2800.00
6% Tax $168.00

1.00% Local Tax should be $28.00 but comes up as $56.00


Any thoughts?

[LadyHLG]

fotofx,
Doubling can occur if you have two local taxes that are identical.
Have you turned on the debugging option to see if this is happening?

LadyHLG

[fotofx]

That is what it was .. Had a few zip codes that were in two zones.

[ctotogo]

I have Local Sales Tax Mod with the New York State tables already defined if you want to use it. It groups the tax rates by rate, then by local zip code. You might find it handle, and a lot less cumbersome then each zip getting its own row in that table.

I would *love* to get access to that. Is there some way you can make it available? Thanks in advance.

-- Carlos

[Tim M]

Any update on this issue?

Hey Zenners!
Apparently there are some issues with the local tax mod and zen cart version 1.3.9. I have not yet figured out what is going on (it really is only evident when gift certs are involved as far as I know, but I have not done extensive testing as yet.)
Until I figure out what is happening, I can not recommend the use of the Local Tax Mod with Zen Cart version 1.3.9.
When i have more to report I will let everyone know.

LadyHLG