Post by svavrek » Tue Jan 21, 2014 8:41 am

So, I have a Geo Zone for Ohio set. Then I have the Tax Rate setup. Then the products ALL have "Ohio Tax" (the name of the rule) set. A guy in New York just ordered, and it actually charged HIM tax where it is not supposed to... messed with it and I cannot get it to stop that. Any ideas?

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by butte » Tue Jan 21, 2014 1:24 pm

How did you go about limiting Ohio to Ohio? How did you go about limiting elsewhere to not-Ohio?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by svavrek » Tue Jan 21, 2014 7:28 pm

That's the problem with this...

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by Johnathan » Tue Jan 21, 2014 10:25 pm

I think what butte is trying to get at is: are you sure your geo zone is limited to just Ohio? It sounds like it's set to "United States" and "All Zones".

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by butte » Wed Jan 22, 2014 2:28 am

. . . where you also seem to have set USA Ohio itself. Did you Save it, and SEE the green success result?

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by svavrek » Thu Jan 23, 2014 12:42 am

This is confusing the hell out of me... I have it set up the way I think it is supposed to be based on documentation and youtube...

Geo Zone:
Image

Tax Class:
Image

Tax Class Info for Ohio:
Image

What's wrong... this is stumping me.

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by svavrek » Thu Jan 23, 2014 12:45 am

Rates too...
Image

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by Johnathan » Thu Jan 23, 2014 1:24 am

Post a screenshot of your actual geo zone settings. Everything else looks correct, so it seems likely it's not actually attached to United States > Ohio.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by svavrek » Thu Jan 23, 2014 2:19 am

Image

I think I figured it out... My test users were both in Ohio... /facepalm

Still not sure why it figured the tax for the real customer in NY though... I'll have to wait and see what happens but it does look all right. here's to hoping! Thanks!

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by butte » Thu Jan 23, 2014 9:24 am

Version?

This may lead to a Bingo: "My test users were both in Ohio" but "it figured the tax for the real customer in NY" seems to mean that the database itself is the problem. At this juncture version matters.

The install/upgrade script in 1.5.6.0 was modified some time ago but seems not to have been (re)run in the majority of installations, and the one in 1.5.6.1 might well be good as-is but a bare few numbered mysql errors have sprouted. Go into phpMyAdmin and first Export a backup. Then look at the table(s) affected, and see whether there is anything at all goofy in the grid layout, just visually check all of it for proper alignment of columns and rows, without any offsets of some rows into segments jutting to the right beyond normal right marginal bounds. Offsets of that kind can occur in recent as well as in older OC, and in instances I've seen there are bouts of offsets with intervening bouts of normal records -- records jutting out on the right, records okay, more of former, more of latter, etc., perhaps two to five records per bout. If none, then go to bottom left in main pane, Select All of the tables, and ask Check tables, then see whether all are listed OK. If yes, stop. If not, Select All of the tables, and ask Repair tables, then see whether all are listed OK. If yes, stop. If not, see what you have set aside in phpMyAdmin / Export or host .zip Backups in order to use it instead. If none, then you can open the fresh backup and fix it by hand. If you do that be absolutely certain that all piddly teensy nuances of syntax remain intact, such as backticks, one ; per and ending each record line, etc.. Doing that will keep you out of mischief for a little while.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 7 guests