Re: Local Sales Tax Mod - Support Thread
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:
Quote:
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")?
Re: Local Sales Tax Mod - Support Thread
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
Re: Local Sales Tax Mod - Support Thread
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):
Quote:
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?
Re: Local Sales Tax Mod - Support Thread
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):
Quote:
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:
Quote:
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.
Re: Local Sales Tax Mod - Support Thread
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
Re: Local Sales Tax Mod - Support Thread
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'
PHP Code:
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"? :mellow:
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. :smile:
Re: Local Sales Tax Mod - Support Thread
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:
Code:
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?
Re: Local Sales Tax Mod - Support Thread
Have you tried changing the sort order of the mod?
LadyHLG
Re: Local Sales Tax Mod - Support Thread
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!!
:clap:
Re: Local Sales Tax Mod - Support Thread
Quote:
Originally Posted by
LadyHLG
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