Tax not adding correctly

[Guest]

I tried to add the paypal mod because of customers not hitting the continue button when using paypal and I was not receiving the order.

I got so many errors. I uploaded my backups and took the mod off.

Now when someone checks out I get this total which isn't adding the tax correctly.

 

Sub-Total: $62.00

USPS Table Rate (Ships in 7-10 business days): $6.00

(No Gift Wrap): $0.00

Ohio TAX 5.75%: $3.91

Total: $68.34

 

 

Everything in Tax Zones and Order Total are correct.

Any ideas why it's not adding correctly now?

[Guest]

Ok I went back and checked my previous Ohio orders and all were doing this I just never caught it until today so it had nothing to do with the paypal mod. It is adding the taxes to the shipping charges but not the sub-total.

Problem below:

 

Sub-Total: $5.00

USPS Table Rate (Ships in 7-10 business days): $2.00

(No Gift Wrap): $0.00

Ohio TAX 5.75%: $0.41

Total: $7.12

 

It shows the correct tax but does not add it into the total. It only adds the tax on the shipping charges.

 

All my products are set @taxable goods so I don't know what the problem is

[toolcrazy]

This may not be the fix, but it is worth looking into, the mods won't hurt to try. It did fix the problem I was having.

 

http://www.oscommerce.com/forums/viewtopic.php...9&highlight=tax

[doby48]

In includes/application_top.php be sure that the following is set to 'false' as shown below.

 

define('DISPLAY_PRICE_WITH_TAX', false); // Display prices with tax (true) or without tax (false)

 

Or, depending on your version

define('TAX_VALUE', 0);

[Guest]

did that and it won't work doing that. I have to set it to true for it to add the tax

[doby48]

Setting it to true will automatically add in an additional tax. This is used in European countries where all products are sold with tax already included in the price. If your tax is not calculating after setting to false then you need to go into the administration tool and verify that everything has been setup as your problem is there.

[doby48]

First thing is to set the value back to false and then work on the tax issue. Leaving it true will continue to add in the additional tax that you don't want. Once that is done, go into Administration

 

Locations / Taxes --> Tax Zones

 

Here you will see a table that will list your tax zone (presumable Ohio). If you click on EDIT you will be allowed to modify these properties. BUT if you click on the little blue arrow under the Action column you will be presented with different options. You will now see the Country and the State listed. If not, click insert and assign your state to the country (United States). If you do see it listed then click EDIT and just verify that you have correct values in the drop down list.

 

This is a very common mistake with tax calculations as it is a bit hidden.

[Guest]

I made that mistake a long time ago. This isn't the case. Everything is done correctly in admin. And in all the tax zones. It's just not adding the tax properly.

I'm using MS1

[doby48]

I had the exact same thing happen to me. Here is what I did...

 

Removed ALL tax settings in admin. Started from scratch and recreated everything. This all had to be done after I set to false. When I had it set to true it added tax plus some and when I set to false it didn't add anything. I would suggest setting to false and starting from square one with readding your taxes. One note if you have a live store... Check the tables for the existing values of your tax classes as when you create a new one it will assign it a different value. You will want to go in and set it back again otherwise go through all products and reassign the tax class which is a real pain to do.

[Guest]

did that too, didn't work :(

It adds the tax for shipping but does not add the rest of my tax to the total. It shows the correct tax that is being charged but does not add it to the total. ( Only the shipping tax is added to the total)

I started from scratch but it still is not working properly.

[toolcrazy]

I know you are very thorough about what you do, but I have to make this suggestion. Update all your products and make sure that your products are taxable goods. What I mean by update is go ahead and do a edit and press update instead of cancel.

[Guest]

Steve,

Thanks so much for your suggestions but that didn't work either. I've already tried that and I have 500 products! hehe......was a long night....I thought that could have been the problem since it adds the tax for the shipping but it wasn't. I can't seem to crack this one.

[toolcrazy]

I don't know, you got me on that one. Only other thing I can think of is your order_total module got corrupted.

[doby48]

Dont' know then, sounds a lot like the Country hasn't been associated with the state. This is what happened when i recreated everything and forgot to reassociate the two. Are they all showing in your tables? Correct associates as well? If you create a new tax class, associated with a new Zone and associate that with your country. Create a new product and use the new tax class does that do anything?

[Guest]

Name:

United States

 

ISO Code (2): US

 

ISO Code (3): USA

 

Address Format: 2

 

isn't that correct for the country?

[doby48]

In your table zones_to_geo_zones what do you have listed?

 

Also, what do you have listed in your geo_zones table?

[Guest]

geo-to zones table:

 

association_id - 3

zone_country_id - 223

zone_id - 47

geo_zone_id - 3

 

 

I don't have a geo_zones table.

[Guest]

Yes I do, I don't even know why I said that :)

 

geo_zone

 

geo_zone_id - 3

geo_zone_name- Ohio

geo_zone_description -Ohio Tax

[Guest]

This may be what you are after, Marie. In any case, this worked for me:

 

To make taxes work for only a single US State, create two tax zones and rates. One zone and rate for residents of the state and one zone and rate for everyone else. I am in California so my examples will use that state:

 

In Admin -> Locations/Taxes -> Tax Zones:

 

California -> Country: United States Zone: California

Outside California -> Country: All Countries Zone: All Zones

 

In Admin -> Locations/Taxes -> Tax Rates:

 

Tax Class: Taxable Goods Zone: California Tax Rate: 7.75%

Taxable Goods Zone: Outside California Tax Rate: 0%

 

--D

[doby48]

Ok, how about your tax_rates and your tax_class tables?

[Guest]

Tax Rate:

 

tax_rates_id -1

 

tax_zone_id -3

 

tax_class_id -1

 

tax_priority-1

 

tax_rate-5.7500

 

tax_description - Tax 5.75%

 

 

Tax Class:

 

tax_class_id-1

 

tax_class_title -Taxable Goods

 

tax_class_description-The following types of products are included non-food, services, etc

 

 

I don't know what it is, I've tried everything.

Again it adds the correct amount in the total for shipping but does not for the Taxable Goods. It SHOWS the correct amount for tax but does not add it to the total. I'm thinking it has to do with the order_total as well, Steve. Just not sure.

[Guest]

Ok I'm at my wits end. Not much hair left in my head :)

 

I played with it and still can't get it to work.

It's got to be something in the order_total, don't ya think?

See below:

(orders over $100 have free ship)

Sub-Total: $146.00

USPS Table Rate (Ships in 7-10 business days): $0.00

(No Gift Wrap): $0.00

Tax 5.75%: $8.39

Total: $146.00

 

It shows the correct tax but does not add it to the total.

I spoke to someone else who had the problem but they don't remember what they did but said it had something to do with classes/order.php.

I uploaded an older version of my order.php and still had the same problem so I'm not sure if that is my problem or not.

[Guest]

Ok I uploaded a really old order.php and now my tax is sorta working. It does round it off but it's working. It's the contrib-giftwrap that is doing this. Everytime I load the modified order.php for giftwrap it doesn't add the tax but when I uploaded the old one it works. So it has something to do with that mod. It's working now but I don't have giftwrap but I'll deal with that somehow :)