Local Sales Tax Mod - Support Thread

[zcnb]

LadyHLG, first let me thank you for this great mod which seems to be exactly what I need.

I managed to install your package without any problem. My only problem now is how to enter my own state's information into your module.

I selected Location/Taxes > Local Sales Tax, then click the [new tax rate] button.

Now, I have a list of towns (not ZIP codes) in my state which have local sales tax. How do I enter that list?

I only noticed the following instructions for ZIP codes:

What data are we searching for?
For Ranges use "-to-" for seperator
example: 53000-to-56000.

What do I use to separate the towns in the list? commas? spaces? How do I enter towns that have spaces in them (e.g. "East Springfield")?

[LadyHLG]

City names can be entered one per record or in a semi-colon delimited list, (with spaces as is).

ie - Smallville; Gotham City; Metropolis

Obviously, cities don't have ranges so you can disregard that.

LadyHLG

[zcnb]

Thank you very much! This is clear now.

Unfortunately however, it seems that I was too quick to declare that I installed without any problem. Now that I try to do a test checkout, I receive the following in step 2 of 3 (Payment Information):

Your Total
1146 Table 'zc_store.TABLE_LOCAL_SALES_TAXES' doesn't exist
in:
[select local_tax_id, zone_id, local_fieldmatch, local_datamatch, local_tax_rate, local_tax_label, local_tax_shipping, local_tax_class_id from TABLE_LOCAL_SALES_TAXES where zone_id = '']

Have you seen this before? What could be causing this?

[zcnb]

Just in case the following could be helpful in diagnosing the above problem: I suspected the the table that was supposed to be created by running LocalSalesTaxv2.2.sql wasn't really created.

I decided to re-run it (via the edit box (copy & paste) because the 'upload file' doesn't really work) and I received the following which looked familiar from the first run (which I mistook for a non-failure):

Query Results:
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) );

Any idea what I could be doing wrong?

Update: wait a minute... I didn't see the top pink bar containing the error message. It says:

Failed: 1
Error ERROR: Cannot create table tax_rates_local because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

[LadyHLG]

Check your database to be sure the table is there and it is named correctly with whatever table prefix you have chosen (if any).
LadyHLG

[zcnb]

Update: baffled by the mismatch by the table names (TABLE_LOCAL_SALES_TAXES vs. tax_rates_local) I tried to see where that TABLE_LOCAL_SALES_TAXES could possibly come from. I found two places in which TABLE_LOCAL_SALES_TAXES should be substitued by 'tax_rates_local'

define('TABLE_LOCAL_SALES_TAXES', DB_PREFIX . 'tax_rates_local'); 

That led me to find what my problem was: I forgot to upload one file: [FONT="Courier New"]/includes/extra_datafiles/ot_local_sales_taxes_databse_tables.php[/FONT]


See what I mean by "applying patches manually is error prone"?

I wish there were a way to unpack the entire package into the directory structure in one step. Something like 'tar -xvf LocalSalesTaxModv2.2.tar'.

Thanks again for your great mod. Now I am going to check the correctness for the calculations.

[zcnb]

Unfortunately, this mod seems to be not working for me. I repeated all steps properly this time - from the beginning (on a test store of course) - but I keep getting calculations as if no local sales tax is defined.

I mean, everything works just as before: State tax is applied but the local sales tax is simply not there:

Your Total
      Sub-Total: $1.98
  Free Shipping: $0.00
State Sales Tax: $0.12
          Total: $2.10

Shouldn't there be another line for local sales tax?

What could have I done wrong in installing/configuring this mod?

[LadyHLG]

Have you tried changing the sort order of the mod?
LadyHLG

[rory]

On the Gift Cert Mod, your link to the calculation error in gift cert totals worked. All the totals are correct!

I really appreciate your help. This is a great mod and will put our store in compliance with the new destination based sales tax in WA.

I really appreciate your help on this!!

[zcnb]

Have you tried changing the sort order of the mod?

No, I kept the default 250. I will try this shortly and see whether this helps. What value do you recommend?

Also, should I define a new tax class for it, or should I just use the existing tax class for the state?

Also, if I enable debugging, where do should I expect to see the debug information?

Thanks,
Daniel