tax is charged twice

7 Aug 2006, 11:29 PM

#1

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

tax is charged twice

Hi, I have zone defined as SC (South Carolina), , whenever someone buys any products and is from South carolina the tax is charged twice, CUD you tell me how to rectify this problem, regards:sanjeevg

Sub-Total: $225.00

United Parcel Service (Ground): $10.16

SC TAX + SC Tax 5%: $23.06

Total: $258.22

8 Aug 2006, 1:37 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

Admin->Localization/Taxes -> Tax Rates .... how many are listed?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 8:45 AM

#3

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

Hi

this is what is mentioned in admin> Localization/taxes> tax rates::

Priority: 1, Tax Class: SC 5% Tax, Zone: South Carolina, Tax rate: 5%

regards: sanjeevg

8 Aug 2006, 8:47 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

What version of Zen Cart are you using? Sounds like something got mixed up on you...

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 8:50 AM

#5

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

From where do i check the version:blush:

8 Aug 2006, 8:50 AM

#6

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

Admin->Tools->Server Info

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 8:50 AM

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

I think you have a hidden tax rate in your shop ...

Try this to wipe out ALL tax-rates and recreate:

Go to: Admin->Tools->Install SQL Patches
In the text field, enter this:```
truncate table tax_rates;

3. Click Send
4. Go to: Admin->Localization/Taxes->Tax Rates 
5. Recreate your SC tax rate.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 8:53 AM

#8

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

the version is Zen Cart 1.2.1

8 Aug 2006, 8:57 AM

#9

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

I do not have this option Install SQL Patches under Admin->Tools->

8 Aug 2006, 9:02 AM

#10

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

I just observed that i have deleted the entire tax rate from the admin-> localization/tax rate -> tax rate, then i checked on site strangely it was still showing:

SC TAX + SC Tax 5%: $6.15

8 Aug 2006, 9:17 AM

#11

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

sanjeevg:

the version is Zen Cart 1.2.1
Wow ... you really should consider upgrading .... v1.3.0.2 has been released and contains numerous bugfixes and security fixes since your version was released almost 2 years ago.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 9:19 AM

#12

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

sanjeevg:

I do not have this option Install SQL Patches under Admin->Tools->

You'll have to use phpMyAdmin instead:

open phpMyAdmin
select your Zen Cart database from the pulldown on the left menu
Click on the SQL tab in top center
In the text field, enter this:

truncate table tax_rates;

Click Go
Go to: Admin->Localization/Taxes->Tax Rates
Recreate your SC tax rate.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Aug 2006, 9:24 AM

#13

sanjeevg

New Zenner

Join Date:: Jul 2006
Location:: India
Posts:: 20
Plugin Contributions:: 0

Re: tax is charged twice

DrByte:

Wow ... you really should consider upgrading .... v1.3.0.2 has been released and contains numerous bugfixes and security fixes since your version was released almost 2 years ago.

My only worry is that i have never upgraded before and if i do that will my online store be intact and unaffected,

8 Aug 2006, 9:26 AM

#14

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: tax is charged twice

sanjeevg:

My only worry is that i have never upgraded before and if i do that will my online store be intact and unaffected,
You will definitely want to stage your upgrade in a separate folder+database and take your time to re-implement your customizations into the new version. A LOT has changed... Leave your current site online until all your testing is done on the new version.

meanwhile, you still need to fix the taxes on the live site

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.