TAX Question... Please help !

[signprint]

Hi to all !

I have a zencart installation Zen Cart 1.3.8a, and have recently gone VAT registered.

I have all the TAX/VAT setup and working fine on new products that i add. But for my 5000 old products, is there a way of updating the "Tax Class" for each product, without manually editing each one ?? As all the old products are set as "Tax Class" 'none'.


Steve

[Absolute]

Run a quick SQL patch in Tools >> Install SQL Patches.

YOU MUST BACKUP YOUR DATABASE BEFORE RUNNING THIS PATCH

update products set products_tax_class_id = '1';

You MUST ensure you replace the 1 with the actual tax class ID. This can be found in Locations/Taxes >> Tax Classes. Use the ID on the left of the relevant tax class.

Absolute

[Absolute]

PS - Obviously this updates ALL products within your database! If you want to only do selected items, then these need to be done either one at a time, or using the EasyPopulate routine, and then use excel or similar to update the exported file, before re-importing all the products.

Absolute

[signprint]

Yup, thats exactly what i want to do !!!

Thanx a million !

Best Regards,

Steve

[signprint]

Thanks for your help, VAT is now being calculated in the total shown to the customer on checkout, but it doesn't display "VAT" and the amount, just adds it up invisibly.

Any ideas ?

Kind Regards,
Steve

[signprint]

Please ignore me, i didn't have "Order Tax" installed in the Order Total modules !

doh.

fixed now.

Thanks once again.