Local Sales Tax Mod - Support Thread

[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.