Tax Class

[beth99]

I have about 4,000 products and they were all set as Taxable Goods but after the upgrade there is nothing in the Tax Class field. I went to Myphp and tax class is set to 0 for all products and I believe it should be 1. Is there a way to show all products as Taxable Goods without having to update each one? I'm sure there is but i don't now how to do MypHp and I don't know anything about the attribute function.

[Ajeh]

Check that the tax id is 1 by fixing 1 product ...

Then, once you are sure, you could run this in the Tools ... Insert SQL Patch ...

UPDATE products SET products_tax_class_id=1; 

Backup your database first ... before attempting this ...

[beth99]

Yes, the updated product = 1. Do I put that code in Tools using MyPhP? I have never edited in PhP so be kind and guide me so I don't mess up anything.

Thank you.

[Ajeh]

It would be easier to go to your Zen Cart Admin ... Tools ... Insert SQL Patch ...

And copy that UPDATE code into the window and run it from there ... AFTER you make a backup of your database of course ...

[beth99]

Worked perfectly. Thank you so much Linda.

[Ajeh]

Thanks for the update and glad that this worked for you ...

Note: you should fix your signature as it is a mess since the upgrade to the forum and needs tidying up ... it goes off to never never land vs your site ...