OpenCart Community

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?

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

That's the problem with this...

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

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

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:


Tax Class:


Tax Class Info for Ohio:


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

Rates too...

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.

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!

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.