Local Sales Tax Mod - Support Thread

[rory]

Thanks!!!!

I have until the 21st when the site goes live, so no problem there. I really appreciate your help.

THANKS!!!

[LadyHLG]

Rory,
Still looking into this but I am wondering if you have seen this post:
http://www.zen-cart.com/forum/showth...-calculate+Tax

It appears there is calculation error in the gift cert totals in version 1.3.8. Before we proceed I need to know what effect the bug fix has on the totals you are seeing.

Thanks
LadyHLG

[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.

[tdblanchard]

Hi there
I've successfully built and launched my very first ZenCart store!
The only persistent problem seems to be sales tax (or lack thereof).
I have yet to be able to get sales tax to show up in an order total.
I went through the step-by-step instructions in the Tutorials section (just so happens the physical address of the store is in Colorado!)
I thought that this Local Sales Tax mod would be the solution, but still can't seem to get it.
Can anyone maybe go through the basics of setting up sales tax on a ZenCart store?
The site's live and luckily the owner is super chill about this, but I'd really like to get this puppy buttered up and rockin'.

[LadyHLG]

tdblanchard,
How to set up taxes really depends on how you need to charge them.
Are you charging a state wide tax? Do you need a local tax by zip code or city name? Or maybe its some combination of both.
Can you provide more information?

LadyHLG