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.
Printable View
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.
Great help! **Just got an email from WA about the new rates for Oct-DecQuote:
Originally Posted by patternman
Has anyone installed this on version 1.3.9d and got it to work?
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.Quote:
Originally Posted by larryweiss
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?
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
That is what it was .. Had a few zip codes that were in two zones.
I would *love* to get access to that. Is there some way you can make it available? Thanks in advance.Quote:
Originally Posted by retched
-- Carlos
Any update on this issue?
Quote:
Originally Posted by LadyHLG