Tax only one state?

I'm setting up our shopping cart and the clients want to only charge taxes within NEVADA, and to have it so that anyone who orders from out of state pays no sales tax.

Is there a way to do that? I have Nevada tax rates set up on the cart right now, but because it's set up as a tax zone, it automatically charges EVERYONE the Nevada sales tax rate - regardless of whether they order from Nevada, Virginia or anywhere else.

Is there a way to set Zencart so that it will auto-detect any order made from Nevada, and charge them the appropriate tax rate? And if they're from another state, have it NOT charge them?

Any help is appreciated.

On the Zone Definition for Nevada, what do you have in the DETAILS?

Quote:

---

Originally Posted by Ajeh

On the Zone Definition for Nevada, what do you have in the DETAILS?

---

In details:

Country: US
Zone: Nevada
Action: (blank)

When I tried filling in different 'zones' for Nevada to give different tax rates per county, it wound up charging each buyer compounded taxes for ALL the different counties at once...

I'm sure it's something simple I've overlooked. Any advice?

How many Zone Definitions do you have that have a Tax Rate set on them?

Quote:

---

Originally Posted by Ajeh

How many Zone Definitions do you have that have a Tax Rate set on them?

---

So far just one - Nevada. Is that the problem? Do I have to set up a zone for each state with a rate of 'zero', or it will default to Nevada?

No ... I asked so that I could make sure that you do not have other Zone Definitions setup that are being used to tax others ...

If you just have the 1 Zone Definition setup for a Tax Rate and that Zone Definition has its DETAILS setup correctly for:
Country: United States
Zone: Nevada

then there should not be an issue of charging tax to the wrong Zones ...

Could you look on your Zen Cart Admin at the Configuration ... My Store ... and see what your Tax is based on for the:

Quote:

---

Basis of Product Tax
On what basis is Product Tax calculated. Options are
Shipping - Based on customers Shipping Address
Billing Based on customers Billing address
Store - Based on Store address if Billing/Shipping Zone equals Store zone

Shipping
Billing
Store

---

Basis of product tax is set to 'shipping' (customer's shipping address).

If you go to the Locations / Taxes ... Tax Rates ... what do you see?

Assuming you see Nevada ... if you click EDIT ... what do you see?

If you go to the Locations / Taxes ... Tax Rates ... what do you see?

It shows only 1 rate.
Priority 1 / Tax Class = Taxable goods / Zone = Nevada / Tax Rate = 6% / Description = Nevada Sales tax

Assuming you see Nevada ... if you click EDIT ... what do you see?

Clicking Edit shows all that info (shown above) as editable drop down menus and fillable fields.

Tried several different states, still shows Nev. sales tax added in the shopping cart price no matter which state I say I'm from...

Things that make you go hmmm ... :lookaroun

Do you have an URL that we could perhaps peek at?

http://titanammo.com/store/

It's baffling me, too. It should be working....

Makes no sense ...

Go to phpMyAdmin and look at your database table:
tax_rates

what do you see in there when you browse it?

Look at the table:
zones_to_geo_zones

what do you see in there when you browse it?

Look at the table:
geo_zones

what do you see in there when you browse it?


For giggles and grins ... if you look at your two files, on the server, for:
/includes/configure.php

/your_secret_admin/includes/configure.php

are they both using the same database information?

how do you get to phpmyadmin?

You should be able to get to it via your Control Panel for your domain ... if not, contact your hosting provider and ask them how to access this ...

Searching thru godaddy...

OK, it's showing a lot of stuff - what should I be looking for?

Attached are screens of teh 3 tables...

Attachment 11436Attachment 11437Attachment 11438

Could you browse those tables as well and see what is in them ... at least the first page of the Browse ...

Sure thing -
Attachment 11439Attachment 11440Attachment 11441

You have bad data ...

Backup your data base and run the SQL:

Code:

---

TRUNCATE zones_to_geo_zones;
TRUNCATE tax_rates;
TRUNCATE geo_zones;

---

Now ... start fresh and make 1 Zone Definition for Nevada Tax and in the DETAILS do the:
Country: United States
Zones: Nevada

and in the Tax Rate set that up to your taxes for Nevada ...

I'm not a coder or database wrangler by trade - just a humble designer.

What is the best way to back up a databse (from Zencart admin, or the php manager)?

And how do I 'run SQL' so I don't get bad data again?

If you have the Zen Cart Backup installed, you can use that ... or use phpMyAdmin: http://www.zen-cart.com/content.php?...atabase-backup

To run those SQL statements ... you can run them either in phpMyAdmin in the SQL or in the Zen Cart Admin under Tools ... Install SQL Patches ...

Quote:

---

Originally Posted by Ajeh

If you have the Zen Cart Backup installed, you can use that ... or use phpMyAdmin: http://www.zen-cart.com/content.php?...atabase-backup

To run those SQL statements ... you can run them either in phpMyAdmin in the SQL or in the Zen Cart Admin under Tools ... Install SQL Patches ...

---

Yep, that seems to have done it. Thanks for your patience! (I need to make a donation, you guys are MUCH more help)

You are most welcome ... thanks for the update that your taxes are now working now that the tables are cleaned up ... :smile:

Looking forward to the coffee and donuts! :cool: