Local Sales Tax Mod - Support Thread

[kramergutt]

I am having the same issue as some of your other users where if I use a discount coupon with taxes, the coupon is not subtracted. If no taxes, the coupon is works fine. After changing the order to apply the coupon after the tax, it works in a confusing way.

Get total showing
and tax is based on that total correctly
then is shows the coupon subtracted at face value,
but with my settings it does correctly subtract the coupon and any tax on that amount. That is correct because you cannot tax on what they did not spend.

So overall the calculations are correct, but it will confuse the customer. Also, I am creating a summary tax report, and that becomes an issue because the tax showing is for the city and state, but the values are on the sub totals before any discounts. So the amounts showing on the report are incorrect since we did not collect say 4% on $45, but rather 4% on $20 because of a $25 coupon.

Has there been any progress on a possible fix? If I could apply the coupon before the tax, the tax would be calculated correctly and stored in the DB correctly and my customers would see the actual tax they were charged correctly.

Please Please Help, our site is live and I want them to be able to use discount coupons.

Zen 1.3.8a
Tax module 2.4

Thanks, and I do love the mod. Good work.

[Tesla]

Hello,

I have the local sales tax modification (ver 2.4) working very well with ZC ver 1.3.8 in New York with 2260-ish zip codes in NY.

I have a problem where if a customer is in NY (my state) I need to charge tax but if the customer has their home address zip with zip+4, 9 digit zip with the form 12345-6789 format of zip code, they do not get charged tax.

Is there any way to modify the read of the customer's zip code and truncate all but the first 5 digits before it does the compare and search the database table. I could not find any other information/postings in the forum on this subject. Does everyone have this problem? Any suggestions appreciated. Thank you.

[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