Local Sales Tax Mod (with admin!) for testing

[Squanto]

LadyHLG:
All I can say is... Wow! Thanks a million, this seems to work quite well!
-squanto

[psychicpet]

I have successfully installed this mod on a site running 1.3.7 and it works like a charm!

I am building a new site using 1.3.8 (unmodded so far) now and for some reason I can't install the SQL patch. I get a simple "Failed" message with no further detail.

Any ideas?

[psychicpet]

I am building a new site using 1.3.8 (unmodded so far) now and for some reason I can't install the SQL patch. I get a simple "Failed" message with no further detail.

I solved my own problem by building the table by hand using phpMyAdmin which added my database name and a little bit at the end see below:

 CREATE TABLE `xxxxxx_zc1`.`zen_tax_rates_local` (
`local_tax_id` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT 'tax id',
`zone_id` INT( 11 ) NULL COMMENT 'zen cart zone to apply tax',
`local_fieldmatch` VARCHAR( 100 ) NULL COMMENT 'Name of field from delivery table to match',
`local_datamatch` VARCHAR( 100 ) NULL COMMENT 'Data to match delivery field',
`local_tax_rate` DECIMAL( 7, 4 ) NOT NULL DEFAULT '0.0000' COMMENT 'Local tax rate',
`local_tax_label` VARCHAR( 100 ) NULL COMMENT 'Label for checkout',
`local_tax_shipping` VARCHAR( 5 ) NOT NULL DEFAULT 'false' COMMENT 'Apply this tax to shipping',
`local_tax_class_id` INT( 1 ) NULL COMMENT 'Apply to products in what tax class',
PRIMARY KEY ( `local_tax_id` )
) ENGINE = MYISAM

I also noticed that the SQL file tries to create a table called "tax_rates_local" but the mod was looking for "zen_tax_rates_local"

[LadyHLG]

The sql file will have the table name without any table prefix, when using the zencart admin to install the mod it will add the prefix, if however the table is created outside of the cart then you will have to add whatever (if any) prefix you have decided on for your particular setup.

Glad you were able to get things working.

LadyHLG

[billharris]

LadyHLG:

Thank you for developing this mod. It is great!

I had to modify it a little, because my store gives quanity discounts and member discounts, and the mod does not support these.

Since my store is in California, I set up a normal Zen Zone definiton and state tax rate for CA. Then I installed your mod version1.1 and made 2 modifications:

1. I added code to find the CA state Tax amount, and divided that by the CA state tax rate to get the order taxable amount. This can be off by a few cents due to rounding, but the error is negligible. I multiplied the taxable amount by the locatl tax rate to get the local tax amount.

2. I changed the calculation of the order total to simply add the local tax amount to the existing order total.

Works like a charm. Thanks again!

[KRW Knitwear]

Is anyone here using this module for the New WA State Destination Taxes?

If so, could you explain to me how to set up?

[sublime19]

LadyHLG, is there a limit on the number of zipcodes you can enter in the field? I am looking at the table in mysql and it seems to be limiting it.

I have researched every zip code in california, put them in an excell document and was working on setting up your mod and some counties have alot of zipcodes like (la county).

also can you do combinations in the range like 1-10;17;20-25; ?

[LadyHLG]

The mod was not originally designed for a long string in the datamatch field, I believe its at 100 characters. You can of course change that on your database if you wish. Personally I think its a bit dangerous to have too many zips in one data record, I know its convenient but I would hate to have to sort though all those zip code to find one if something changes in one of the zip codes but not in the others.

No the mod does not handle range combinations, you need to set up the ranges as separate entries.

Hope this helps.

LadyHLG

[sublime19]

The mod was not originally designed for a long string in the datamatch field, I believe its at 100 characters. You can of course change that on your database if you wish. Personally I think its a bit dangerous to have too many zips in one data record, I know its convenient but I would hate to have to sort though all those zip code to find one if something changes in one of the zip codes but not in the others.


how would i make this mod? It would be easier and make more sense in my head than using ranges because zip codes don't go in exact order.

[LadyHLG]

I'm sorry, but I'm not sure what you are asking.
Do you want to know how to use combination zip code ranges?