Hi
I created a uk zone with its countries, together with the required uk vat tax rate.

I find the florida entry just won't delete, even though I deleted the tax rate for it and zone definitions in it.

The silly thing says in the top line in yellow, when trying to delete florida zone,
' WARNING: Tax Rate(s) are defined for this zone. Please delete the Tax Rate(s) before removing this zone'

But i removed florida's tax rate, and when you look at florida's tax rate list its empty.

This seems to be that when the florida tax rate is deleted, the database reference to it in Florida zone was not removed?

This is a fresh 1.3.5 install with no file mods

Is this a bug, or did I miss something?

https://www.zen-cart.com/tutorials/index.php?article=76

Make sure you have reversed all of the steps.

Other tax-related articles:
https://www.zen-cart.com/tutorials/index.php?article=75
https://www.zen-cart.com/tutorials/index.php?article=32

The tax-class interface in v1.3.5 mistakenly allows you to delete a tax class while tax rates are still assigned to it.

This will be fixed in a future release.

Meanwhile, you can truncate the geo_zones, tax_rates, tax_classes, and zones_to_geo_zones tables in order to start fresh ...

DrByte:

The tax-class interface in 1.3.5 mistakenly allows you to delete a tax class while tax rates are still assigned to it.

This will be fixed in a future release.

Meanwhile, you can truncate the geo_zones, tax_rates, tax_classes, and zones_to_geo_zones tables in order to start fresh ...

Dear Doctor,

I think i need to "truncate" as you say above. Can you explain how and where i can do this please? I accidently deleted all my tax rates and now i cannot delete all my zones which have been incorrectely set.

Thank you so much.

Arpeggio

If you're using phpMyAdmin, the "Empty" tab performs a "truncate table" command on the selected table.

So ... to completely empty a given table using phpMyAdmin:

1. select your database from the pulldown on the left
2. click on the table you wish to purge
3. you'll see the table structure appear on the right side
4. click on the "Empty" button on top right button bar
5. confirm.

If you're trying to purge all tax rates and defined zones, purge these tables:

• tax rates
• zones_to_geo_zones
• geo_zones

You'll have to re-enter all your zone and tax info from scratch again.

(you can do the "tax_class" table too, but that is most likely not necessary, as changes to it are seldom made, and you'd have to recreate a new tax class too.)

Holy smoke!! it works! damn well never done anything like that before!

Fantastic Sensei Byte. Arigato!

have another prob. of a different kind now however if ya dont mind:

I'm tryin' to follow the Colorado Tax example to the tee... It says:

"Go to:*
Admin > Locations/Taxes > Zones Definitions > Insert

** Zone Name: Colorado
Description: Colorado State Sales Tax (or whatever you like)
click on 'insert'

Click on 'Details' after creating a zone
Click on 'Insert'
Country = United States
Zone = Colorado
Click on 'insert' "

*My problem is that:

1. i cannot select "Colorado" as a Zone (see underlined part above). From the pull down box i can only select "United States" or "All Zones". That is, the name "Colorado" is not in the pull down box.

2. Since i have very imited knowledge of how the tax system here works, is there a chart or something diagramatical showing all the terms relationship?

again, thank you so much.

It sounds like you've ended up purging the "zones" too, and the evidence of that would be found if you go to Admin->Locations/Taxes->Zones ... and see nothing in the list.

To re-populate the zones supplied with Zen Cart, you would need to go into your phpMyAdmin, select your database, then click on the SQL tab, and paste the following into the textarea field, and click Go:```
#Empty the table for fresh data
TRUNCATE TABLE zones;

USA

INSERT INTO zones VALUES (1,223,'AL','Alabama');
INSERT INTO zones VALUES (2,223,'AK','Alaska');
INSERT INTO zones VALUES (3,223,'AS','American Samoa');
INSERT INTO zones VALUES (4,223,'AZ','Arizona');
INSERT INTO zones VALUES (5,223,'AR','Arkansas');
INSERT INTO zones VALUES (6,223,'AF','Armed Forces Africa');
INSERT INTO zones VALUES (7,223,'AA','Armed Forces Americas');
INSERT INTO zones VALUES (8,223,'AC','Armed Forces Canada');
INSERT INTO zones VALUES (9,223,'AE','Armed Forces Europe');
INSERT INTO zones VALUES (10,223,'AM','Armed Forces Middle East');
INSERT INTO zones VALUES (11,223,'AP','Armed Forces Pacific');
INSERT INTO zones VALUES (12,223,'CA','California');
INSERT INTO zones VALUES (13,223,'CO','Colorado');
INSERT INTO zones VALUES (14,223,'CT','Connecticut');
INSERT INTO zones VALUES (15,223,'DE','Delaware');
INSERT INTO zones VALUES (16,223,'DC','District of Columbia');
INSERT INTO zones VALUES (17,223,'FM','Federated States Of Micronesia');
INSERT INTO zones VALUES (18,223,'FL','Florida');
INSERT INTO zones VALUES (19,223,'GA','Georgia');
INSERT INTO zones VALUES (20,223,'GU','Guam');
INSERT INTO zones VALUES (21,223,'HI','Hawaii');
INSERT INTO zones VALUES (22,223,'ID','Idaho');
INSERT INTO zones VALUES (23,223,'IL','Illinois');
INSERT INTO zones VALUES (24,223,'IN','Indiana');
INSERT INTO zones VALUES (25,223,'IA','Iowa');
INSERT INTO zones VALUES (26,223,'KS','Kansas');
INSERT INTO zones VALUES (27,223,'KY','Kentucky');
INSERT INTO zones VALUES (28,223,'LA','Louisiana');
INSERT INTO zones VALUES (29,223,'ME','Maine');
INSERT INTO zones VALUES (30,223,'MH','Marshall Islands');
INSERT INTO zones VALUES (31,223,'MD','Maryland');
INSERT INTO zones VALUES (32,223,'MA','Massachusetts');
INSERT INTO zones VALUES (33,223,'MI','Michigan');
INSERT INTO zones VALUES (34,223,'MN','Minnesota');
INSERT INTO zones VALUES (35,223,'MS','Mississippi');
INSERT INTO zones VALUES (36,223,'MO','Missouri');
INSERT INTO zones VALUES (37,223,'MT','Montana');
INSERT INTO zones VALUES (38,223,'NE','Nebraska');
INSERT INTO zones VALUES (39,223,'NV','Nevada');
INSERT INTO zones VALUES (40,223,'NH','New Hampshire');
INSERT INTO zones VALUES (41,223,'NJ','New Jersey');
INSERT INTO zones VALUES (42,223,'NM','New Mexico');
INSERT INTO zones VALUES (43,223,'NY','New York');
INSERT INTO zones VALUES (44,223,'NC','North Carolina');
INSERT INTO zones VALUES (45,223,'ND','North Dakota');
INSERT INTO zones VALUES (46,223,'MP','Northern Mariana Islands');
INSERT INTO zones VALUES (47,223,'OH','Ohio');
INSERT INTO zones VALUES (48,223,'OK','Oklahoma');
INSERT INTO zones VALUES (49,223,'OR','Oregon');
INSERT INTO zones VALUES (50,163,'PW','Palau');
INSERT INTO zones VALUES (51,223,'PA','Pennsylvania');
INSERT INTO zones VALUES (52,223,'PR','Puerto Rico');
INSERT INTO zones VALUES (53,223,'RI','Rhode Island');
INSERT INTO zones VALUES (54,223,'SC','South Carolina');
INSERT INTO zones VALUES (55,223,'SD','South Dakota');
INSERT INTO zones VALUES (56,223,'TN','Tennessee');
INSERT INTO zones VALUES (57,223,'TX','Texas');
INSERT INTO zones VALUES (58,223,'UT','Utah');
INSERT INTO zones VALUES (59,223,'VT','Vermont');
INSERT INTO zones VALUES (60,223,'VI','Virgin Islands');
INSERT INTO zones VALUES (61,223,'VA','Virginia');
INSERT INTO zones VALUES (62,223,'WA','Washington');
INSERT INTO zones VALUES (63,223,'WV','West Virginia');
INSERT INTO zones VALUES (64,223,'WI','Wisconsin');
INSERT INTO zones VALUES (65,223,'WY','Wyoming');

Canada

INSERT INTO zones VALUES (66,38,'AB','Alberta');
INSERT INTO zones VALUES (67,38,'BC','British Columbia');
INSERT INTO zones VALUES (68,38,'MB','Manitoba');
INSERT INTO zones VALUES (69,38,'NF','Newfoundland');
INSERT INTO zones VALUES (70,38,'NB','New Brunswick');
INSERT INTO zones VALUES (71,38,'NS','Nova Scotia');
INSERT INTO zones VALUES (72,38,'NT','Northwest Territories');
INSERT INTO zones VALUES (73,38,'NU','Nunavut');
INSERT INTO zones VALUES (74,38,'ON','Ontario');
INSERT INTO zones VALUES (75,38,'PE','Prince Edward Island');
INSERT INTO zones VALUES (76,38,'QC','Quebec');
INSERT INTO zones VALUES (77,38,'SK','Saskatchewan');
INSERT INTO zones VALUES (78,38,'YT','Yukon Territory');

Germany

INSERT INTO zones VALUES (79,81,'NDS','Niedersachsen');
INSERT INTO zones VALUES (80,81,'BAW','Baden-Wrttemberg');
INSERT INTO zones VALUES (81,81,'BAY','Bayern');
INSERT INTO zones VALUES (82,81,'BER','Berlin');
INSERT INTO zones VALUES (83,81,'BRG','Brandenburg');
INSERT INTO zones VALUES (84,81,'BRE','Bremen');
INSERT INTO zones VALUES (85,81,'HAM','Hamburg');
INSERT INTO zones VALUES (86,81,'HES','Hessen');
INSERT INTO zones VALUES (87,81,'MEC','Mecklenburg-Vorpommern');
INSERT INTO zones VALUES (88,81,'NRW','Nordrhein-Westfalen');
INSERT INTO zones VALUES (89,81,'RHE','Rheinland-Pfalz');
INSERT INTO zones VALUES (90,81,'SAR','Saarland');
INSERT INTO zones VALUES (91,81,'SAS','Sachsen');
INSERT INTO zones VALUES (92,81,'SAC','Sachsen-Anhalt');
INSERT INTO zones VALUES (93,81,'SCN','Schleswig-Holstein');
INSERT INTO zones VALUES (94,81,'THE','Thringen');

Austria

INSERT INTO zones VALUES (95,14,'WI','Wien');
INSERT INTO zones VALUES (96,14,'NO','Niedersterreich');
INSERT INTO zones VALUES (97,14,'OO','Obersterreich');
INSERT INTO zones VALUES (98,14,'SB','Salzburg');
INSERT INTO zones VALUES (99,14,'KN','Kärtnen');
INSERT INTO zones VALUES (100,14,'ST','Steiermark');
INSERT INTO zones VALUES (101,14,'TI','Tirol');
INSERT INTO zones VALUES (102,14,'BL','Burgenland');
INSERT INTO zones VALUES (103,14,'VB','Voralberg');

Swizterland

INSERT INTO zones VALUES (104,204,'AG','Aargau');
INSERT INTO zones VALUES (105,204,'AI','Appenzell Innerrhoden');
INSERT INTO zones VALUES (106,204,'AR','Appenzell Ausserrhoden');
INSERT INTO zones VALUES (107,204,'BE','Bern');
INSERT INTO zones VALUES (108,204,'BL','Basel-Landschaft');
INSERT INTO zones VALUES (109,204,'BS','Basel-Stadt');
INSERT INTO zones VALUES (110,204,'FR','Freiburg');
INSERT INTO zones VALUES (111,204,'GE','Genf');
INSERT INTO zones VALUES (112,204,'GL','Glarus');
INSERT INTO zones VALUES (113,204,'JU','Graubnden');
INSERT INTO zones VALUES (114,204,'JU','Jura');
INSERT INTO zones VALUES (115,204,'LU','Luzern');
INSERT INTO zones VALUES (116,204,'NE','Neuenburg');
INSERT INTO zones VALUES (117,204,'NW','Nidwalden');
INSERT INTO zones VALUES (118,204,'OW','Obwalden');
INSERT INTO zones VALUES (119,204,'SG','St. Gallen');
INSERT INTO zones VALUES (120,204,'SH','Schaffhausen');
INSERT INTO zones VALUES (121,204,'SO','Solothurn');
INSERT INTO zones VALUES (122,204,'SZ','Schwyz');
INSERT INTO zones VALUES (123,204,'TG','Thurgau');
INSERT INTO zones VALUES (124,204,'TI','Tessin');
INSERT INTO zones VALUES (125,204,'UR','Uri');
INSERT INTO zones VALUES (126,204,'VD','Waadt');
INSERT INTO zones VALUES (127,204,'VS','Wallis');
INSERT INTO zones VALUES (128,204,'ZG','Zug');
INSERT INTO zones VALUES (129,204,'ZH','Zrich');

Spain

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'A Corua','A Corua');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alava','Alava');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Albacete','Albacete');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alicante','Alicante');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Almeria','Almeria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Asturias','Asturias');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Avila','Avila');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Badajoz','Badajoz');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Baleares','Baleares');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Barcelona','Barcelona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Burgos','Burgos');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Caceres','Caceres');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cadiz','Cadiz');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cantabria','Cantabria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Castellon','Castellon');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ceuta','Ceuta');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ciudad Real','Ciudad Real');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cordoba','Cordoba');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cuenca','Cuenca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Girona','Girona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Granada','Granada');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guadalajara','Guadalajara');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guipuzcoa','Guipuzcoa');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huelva','Huelva');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huesca','Huesca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Jaen','Jaen');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'La Rioja','La Rioja');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Las Palmas','Las Palmas');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Leon','Leon');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lleida','Lleida');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lugo','Lugo');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Madrid','Madrid');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Malaga','Malaga');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Melilla','Melilla');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Murcia','Murcia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Navarra','Navarra');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ourense','Ourense');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Palencia','Palencia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Pontevedra','Pontevedra');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Salamanca','Salamanca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Segovia','Segovia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Sevilla','Sevilla');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Soria','Soria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Tarragona','Tarragona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Teruel','Teruel');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Toledo','Toledo');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valencia','Valencia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valladolid','Valladolid');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Vizcaya','Vizcaya');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zamora','Zamora');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zaragoza','Zaragoza');

#australian zones
INSERT INTO zones VALUES (NULL, 13, 'ACT', 'Australian Capital Territory');
INSERT INTO zones VALUES (NULL, 13, 'NSW', 'New South Wales');
INSERT INTO zones VALUES (NULL, 13, 'NT', 'Northern Territory');
INSERT INTO zones VALUES (NULL, 13, 'QLD', 'Queensland');
INSERT INTO zones VALUES (NULL, 13, 'SA', 'South Australia');
INSERT INTO zones VALUES (NULL, 13, 'TAS', 'Tasmania');
INSERT INTO zones VALUES (NULL, 13, 'VIC', 'Victoria');
INSERT INTO zones VALUES (NULL, 13, 'WA', 'Western Australia');

Thank you again Sensei Byte. Oshogatsu omedetou!(Happy New Year!)

Sorry to get back to ya after so long but i'm in shanghai and as you may be aware we aint had use of the internet due to the earthquake in Taiwan. Only now is the speed anywhere near usable again. (Takes about 1min to load a forum page!)
I did already have those zones which you kindly pasted for me above. however i still cant find what is causing the sales tax figure not to be calulated or appear in the cart (see attached file). I have checked and re-checked all the Tax Zones, classes, rates, etc as per the Colorado tutorial. the product is also set to "Taxable Classes". I'm sure it's something small, as usual, but being such, the problem eludes frustrated me still. Can you please give me say a list of "finer point" possibilities that i can check. arigato.

Me again!! I have just been doing some more research and further to the above i've confirmed the following also:

• Products have been set to “Taxable Goods”.
• Tax rate has been entered at “10”. not “10%”, etc.
• Admin/MyStore: Basis of Product Tax=”Shipping”, Basis of Shipping Tax = “Shipping”
• Admin> Modules> Order Totals> Tax is value "300".I really hope you maybe able to help. thanks in advance.

arpeggio:

I'm tryin' to follow the Colorado Tax example to the tee... It says:

"Go to:*
Admin > Locations/Taxes > Zones Definitions > Insert

** Zone Name: Colorado
Description: Colorado State Sales Tax (or whatever you like)
click on 'insert'

Click on 'Details' after creating a zone
Click on 'Insert'
Country = United States
Zone = Colorado
Click on 'insert' "

*My problem is that:

1. i cannot select "Colorado" as a Zone (see underlined part above). From the pull down box i can only select "United States" or "All Zones". That is, the name "Colorado" is not in the pull down box.
   It sounds like you've ended up purging the "zones" too, and the evidence of that would be found if you go to Admin->Locations/Taxes->Zones ... and see nothing in the list.
   I did already have those zones which you kindly pasted for me above.
   If you have not been able to add "Colorado" as a specific zone in the "Details" part of the Zone Definition, then you will not see taxes added to Colorado addresses.

Try adding "United States - All Zones" as a test -- you should see taxes calculated for all US addresses when you do that (problem is that they'll all be calculated using your colorado tax rate, which is not correct). This is just a test to see if the tax system is linking to the zones properly.

You would be better off starting from a fresh install and building up from there, as it sounds like you may have done a lot of damage to the database while deleting things earlier (c/f your earlier posts).

It's working now thanks so much but the weirdest thing!!

I've posted my new concern as a new post for future forum searchers!!

"Sales tax is not changing with Shipping address"

http://www.zen-cart.com/forum/showthread.php?p=309606#post309606

koko made arigato!! (Thanks up to now!!):yes:

That is due to a bug in v1.3.5 ... you should really upgrade to v1.3.7 ... :smile:

DrByte:

If you're using phpMyAdmin, the "Empty" tab performs a "truncate table" command on the selected table.

So ... to completely empty a given table using phpMyAdmin:
1. select your database from the pulldown on the left
2. click on the table you wish to purge
3. you'll see the table structure appear on the right side
4. click on the "Empty" button on top right button bar
5. confirm.

If you're trying to purge all tax rates and defined zones, purge these tables:

• tax rates
• zones_to_geo_zones
• geo_zones

You'll have to re-enter all your zone and tax info from scratch again.

(you can do the "tax_class" table too, but that is most likely not necessary, as changes to it are seldom made, and you'd have to recreate a new tax class too.)

I am having the same problem with the florida sales tax. What is this phpMyAdmin?

http://www.phpmyadmin.net/home_page/index.php phpMyAdmin is a tool for manipulating a MYSQL database.

Dear Obaa sama, 1.3.7 ni henkou shimashita. (i changed to 1.3.7) and all is well with the tax issue there. the tax rate changes when i change the delivery address!! arigato!

I do have one query though regarding the "Your Total" section.(see attached) The Sub-Total figure includes the tax which is misleading! Then tax is also listed seperately. So when someone naturally tallies the numbers in the column, the "Total" is out by the tax figure! It is mis-leading so can i change it to show only the raw total? (but still display products prices inclusive of tax on the screen?) If not change it to:"Sub-Total (incl. tax, $xx)" and xx is the GST figure shown? Looking forward to your comments. Thank you in advance.

BTW, I was lucky to have got phpMyAdmin bundled with XAMPP( which already has MySQL, Apache, PHP, and other stuff already integrated upon installation. I really had a hard time integrating these 3 (MySQL, Apache, PHP)programs for my localhost.) I dont know if getting XAMPP is a recommended way to setup the platform(if it's called that!:blush:) but if it was a good idea, maybe it could be suggested at the installation tutorial of zencart (by someone with more autority and a lot more knowledge than I!!). It certainly helped me get started (and keep going!) using ZenCart. Not sure if there are any unforeseen drawbacks down the line apart being less experienced in the knowledge of how to set a server, database up.)

Because the tax is already included in the subtotal, perhaps you should re-arrange the order totals and place the tax line below the total line. You can use the sort order to do this. You might also want to modify the tax description to say Australia GST (included).

Hi All,

FYI, I'm running on 1.3.7.1 . Problem still surfacing.

Mavvy:

Hi All,

FYI, I'm running on 1.3.7.1 . Problem still surfacing.

Please be more specific.
Start from a fresh install of v1.3.7.1.
Did you install with or without demo products?
What did you do with respect to zones and taxes to come to the point of saying this problem still surfaces?
I need a step-by-step to reconstruct the scenario in order to determine how to fix it if it is indeed a bug.

Also, what addons/contributions have you installed?

Hi DrByte,

Thanks for reading my post. :clap:

I did install from fresh install of v1.3.7.1.(Web install) without demo products.
If I recall correctly, I think I delete the tax class without deleting the tax rate first. So Zone definition is not possible to delete. Sorry if I recalled wrong steps wrongly, was in urgency to bring up the eshop.

Using the methods stated in front of the post.. using the colorado steps reversal,
now I got two tax rates instead of 1 while zone is still 0. I did delete Tax Rate first then followed by Classes.

My addons should be
Super Orders
RFQ_v1
Ultimate SEO URLs V2
Free Shipping Rules

I'm still new to ZenCart.

DrByte:

Please be more specific.
Start from a fresh install of v1.3.7.1.
Did you install with or without demo products?
What did you do with respect to zones and taxes to come to the point of saying this problem still surfaces?
I need a step-by-step to reconstruct the scenario in order to determine how to fix it if it is indeed a bug.

Also, what addons/contributions have you installed?

Thanks for the clarification of the details. We'll work on a fix.

I suggest that you purge everything related to taxes and zones, and start over.
The steps for that are in my post #5 above. Include the tax_class table as well.

Then create your zone definitions, your tax classes, your tax rates, and then edit each of your taxable products to verify and set the appropriate tax class again.

For v1.3.8, logic will be added to the tax-class page to prevent deletion of tax classes if products or tax rates are associated with them.
In the meantime, purging the orphaned data as mentioned above will let you start with a clean slate.