Tax is calculating wrong

[chris32882]

If you're really adventurous, you can change the value for all products at once in phpmyadmin.

Back up your database first, this is very important!!!!!

Then enter this command in the sql section of phpmyadmin:

update products set products_tax_class_id = 1

Ed

I type it exactly like that?


update products set products_tax_class_id = 1

[chris32882]

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




Ooops...that's for new products. Thought I'd found something there.

Yeah I already configured my taxes for every new product I add, the tax Id is set to 1

[edadk]

I type it exactly like that?


update products set products_tax_class_id = 1

Yes, that will change every product in your store to be a taxable item. Again, please back up before ever doing anything with phpmyadmin.

Ed

[chris32882]

Yes, that will change every product in your store to be a taxable item. Again, please back up before ever doing anything with phpmyadmin.

Ed

Alright, I backed up my database and tried inputing the above in a query and this is what I get returned

#1146 - Table 'tms_zc1-back-1226445866.products' doesn't exist

[chris32882]

Alright, I backed up my database and tried inputing the above in a query and this is what I get returned

#1146 - Table 'tms_zc1-back-1226445866.products' doesn't exist

my site was backed up before and thats the name of the backup tms_zc1-back-1226445866

[edadk]

Alright, I backed up my database and tried inputing the above in a query and this is what I get returned

#1146 - Table 'tms_zc1-back-1226445866.products' doesn't exist

Do your tables have a prefix? If so, try adding your prefix to the front of the table name like this:

update sometableprefix_products set products_tax_class_id = 1

[chris32882]

Do your tables have a prefix? If so, try adding your prefix to the front of the table name like this:

update sometableprefix_products set products_tax_class_id = 1

have no idea man , don't really mess with sql much, hrmmm

[edadk]

have no idea man , don't really mess with sql much, hrmmm

In that case it might be better to stick with using admin to change each product individually.

Ed

[chris32882]

In that case it might be better to stick with using admin to change each product individually.

Ed

its like any other installation of Zen-Cart the prefix should be the same Im assuming?

[chris32882]

Just want you to know the prefix was zen I added:

update zen_products set products_tax_class_id = 1

now should it of been update products set products_tax_class_id = 1 normally