Local Sales Tax Mod - Support Thread

[LadyHLG]

Tesla,
I haven't had time to test this, but you can give it a try.
Open the following file:
includes\modules\order_total\ot_local_sales_taxes.php

at about line 170 look for the following:
$debug2 .= $myfield."<br>";

right above that line place the following code:

if($taxmatch == "postcode"){
$myfield = substr($myfield, 0, 5); 
} 

See if it does the trick.

LadyHLG

[distinctivedog]

I recently installed Zen Cart and dealing with Washington State city sales taxes is the last step. It seems the Local Sales Tax mod will do the trick. My Zen Cart folder within my website is titled "store" so I uploaded the "FullVersion" folder within this folder.

I then went to "Install SQL Patches" and pasted the following in the box:
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`)
);

The system returns the following message:
CREATE TABLE zen_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) );

Am I putting the folder in the right place? I can't seem to get this installed. Thanks for your help in advance.

[LadyHLG]

Inside the FullVersion folder are 2 folders catalog and sqlfiles.
You need to copy all the files and folders inside the catalog folder, but not the folder itself, into your shop folder.

LadyHLG

[distinctivedog]

That sounds simple...but I encountered an issue. You were right about the catalog and sqlfiles folders. If I understand correctly, I am to take the contents of the catalog folder and move them to the top level (in may case a folder titled, "store"). The problem is that the two files in the catalog folder are titled, admin and includes. The "store" directory already contains folders with these names.

[LadyHLG]

Its ok if you already have folders with the same name (in fact thats exactly what you need). There is nothing in the mod folders that will overwrite anything it will just copy the new content into the folders where they need to go.

Good Luck!

LadyHLG

[Tesla]

This WORKS! I need to test it more but wanted to thank you again for saving our collective behinds! If you ever need any electrical engineering, please let me pay you back. For others, make sure you edit this in version 2.4 of ...\ot_local_sales_taxes.php ....Tesla
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Tesla,
I haven't had time to test this, but you can give it a try.
Open the following file:
includes\modules\order_total\ot_local_sales_taxes.php

at about line 170 look for the following:
$debug2 .= $myfield."<br>";

right above that line place the following code:

if($taxmatch == "postcode"){
$myfield = substr($myfield, 0, 5); 
} 

See if it does the trick.

LadyHLG

[distinctivedog]

Thanks LadyHLG.
When I try moving the files from the "catalog" folder (admin and includes) to the shop folder I get the message: "The directory "admin" already exists. Would you like to replace it? Overwriting a directory will replace all files contained in it with the new directory contents."

The folders already located in the shop folder have a lot of files and folders in them (admin has 80 and includes has 28). The ones I am moving have (admin 2 and includes 3).

I'm kind of an ameteur here, so please reconfirm that I should replace the current directories.

[LadyHLG]

distinctivedog,
I would say you have two options.
1. Backup all the files and folders somewhere and then go ahead and upload the mod, if for some reason it removes all the existing files (normally FTP does not do this) then you can restore from the backup.
or
2. Upload the files and folders (new ones) individually.

Good Luck

LadyHLG

[distinctivedog]

Thanks. Glad I backed up. It did indeed overwrite. I replaced the original files and added the files from the mod. Seems to be installed. Thanks for the help.

[slomojojo]

The attached zip contains a plain text file with a current list of 2010 Florida county surtax rates broken down by zipcode. It's already formatted for use with the Local Sales Tax Mod.

-The list is current until the end of 2010.

-Changes from 2009? Only one: Marion county changed from 6.5% to 6.0%, so the Marion county zipcodes have been removed from the list.

Please Note:

-Florida counties and zipcodes aren't contiguous; i.e., hundreds of zipcodes span 2 or even 3 counties. In these instances, the list assigns the zipcode to the county containing the greater population (for that zipcode). If a buyer says they've been charged an incorrect surtax, don't assume they're wrong; do a little investigating with google maps.