Forums / Currencies & Sales Taxes, VAT, GST, etc. / TAX NOT WORKING for some reason.

TAX NOT WORKING for some reason.

Views: 3,265

Results 1 to 19 of 19
23 Mar 2011, 5:40 PM
#1
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

TAX NOT WORKING for some reason.

I don't know why but the tax is not being calculated on my taxable items.
I check that each item description to see that the Tax Class says: Taxable Good.
I check the Location / Taxes in Admin to see that the Zone Definitions, Taxable Goods and the Tax Rates are all configured properly.
What am I missing?

Site: https://www.maynardstackle.com

23 Mar 2011, 9:07 PM
#2
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Double check all my settings using this tutorial: https://www.zen-cart.com/tutorials/index.php?article=155
Everything looks like it should. I am using zencart 139h
Any one have any idea what I missed.

24 Mar 2011, 1:54 AM
#3
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Went through the steps in my zencart ebook and find that I have all my stuff configured correctly and still zencart 139h will not add my tax to taxable good.

Can anyone help. Please.

24 Mar 2011, 2:12 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

Check your Zone Definition ... and click on DETAILS ...

What do you have set for:
Country:
Zone:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 1:04 PM
#5
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Country is set as: United States
Zone is set as: Minnesota

24 Mar 2011, 1:51 PM
#6
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Tried to paste a image but did not work sorry about that

24 Mar 2011, 2:42 PM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

You appear to have TWO Minnesota for your State ... :eek:

First, go to Locations / Taxes ... ... Zones Definitions ... and go to DETAILS ... and Delete Minnesota ...

Next, go to phpMyAdmin, and in the SQL enter:

SELECT * FROM zones WHERE zone_name LIKE 'Minnesota';

The defaults are:
34 223 MN Minnesota

Delete the one that does not read that ...

Next, go back to Locations / Taxes ... ... Zones Definitions ... and go to DETAILS ... and add back in:
Country: United States
Zone: Minnesota

Next, edit your Customer address and reset it, as you probably, maybe, had the duplicate Minnesota set ...

Now see if the Tax Rate works ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 2:52 PM
#8
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

(Next, go to phpMyAdmin, and in the SQL enter:)
Is the above located at my servers control panel? If so I did run the Quote and got this:
Error

SQL query: Documentation

SELECT *
FROM zones
WHERE zone_name LIKE 'Minnesota'
LIMIT 0 , 30;

MySQL said: Documentation
#1146 - Table 'maynards_139.zones' doesn't exist

I do not know what this means.

I did do the first step by deleting Minnesota in the Zones Definitions

24 Mar 2011, 3:00 PM
#9
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

(Next, edit your Customer address and reset it, as you probably, maybe, had the duplicate Minnesota set ...)

Also this last step about the customer address, I am not sure where this is reset.

24 Mar 2011, 3:04 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

First, let's fix the duplicates ...

You probably are using prefixes on your database tables such as:
zen_

If that is the case, you need to add your prefix to the code:

SELECT * FROM zen_zones WHERE zone_name LIKE 'Minnesota';

See if that let's you fix it ...

NOTE: replace the zen_ with the prefix you see on all of your database tables ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 4:14 PM
#11
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Thanks Ajeh for all your help. I have it running fine for now but I found that I may have a much bigger issue.

I did not find where there was TWO Minnesota for my State in my data base.

I did find where the default was set to: The defaults are:
34 223 MN Minnesota

So all I did do is: go to Locations / Taxes ... ... Zones Definitions ... and go to DETAILS ... and Delete Minnesota ... and then reinsert it back in and now it works.

The bigger issue is that when I installed this new version of zencart 139h under the root directory I left the original folder named (zencart_139h)which was used as my test site before I put a copy of it under the root.
Now when I delete that extra (original zencart_139h) folder my site goes down and I get a screen that say's I did not properly install zencart. It appears that my site may be using both folders and I have not got a clue how to fix it.

24 Mar 2011, 4:18 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

I go to your web site and in the State dropdown I see TWO Minnesota listed ...

I strongly recommend you figure out why this is happening ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 4:26 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

In your Zen Cart Admin ... go to the Locations / Taxes ... Zones ... and you will probably see about 190 records ...

Find Minnesota ...

If you look, you probably have 2 of them ... one that you will see in the URL if you click on it:
cID=34

and the other:
cID=182

The 182 is your duplicate ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 4:26 PM
#14
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Can you explain where you are finding two Minnesotas on my site.
I can not find it. I am still fairly new at this. sorry

24 Mar 2011, 4:28 PM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

See previous post #13 ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 5:08 PM
#16
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

I see them now, I just never looked here before.
Can I just delete both of them in the admin and go through the reinstall procedure that is in the zencart ebook or this tutorial: https://www.zen-cart.com/tutorials/index.php?article=155

24 Mar 2011, 5:13 PM
#17
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

Delete the one that is 182 ...

You will see in the URL the:
cID=182

when you click on the one that needs to be deleted ...

Then recheck the settings on the DETAIL for your Zone Definition that you created ...

Next, go to your My Account and check your Address listing to ensure that you are using the Good Minnesota ...

Then, test your taxes and make sure all is working ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Mar 2011, 5:20 PM
#18
maynards avatar

maynards

Zen Follower

Join Date:
Feb 2010
Location:
Minnesota
Posts:
392
Plugin Contributions:
0

Re: TAX NOT WORKING for some reason.

Well, Hell that was easy. Did not realize that by clicking on one of them that it tells me in the URL to which one needs to be deleted. It seems to be working. Learned something again today. Wish I new this 24 hours ago.
Thank you so much Ajeh, I could have not done this without your help.:clap:

24 Mar 2011, 5:42 PM
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: TAX NOT WORKING for some reason.

Thanks for the update that this is working now for you correctly ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!