[SOLVED] Need to set tax class/group on all products at once

Hi there,

I am currently building a shop on 3.0.3.9 and used a tool to migrate my products. That went well execpt that it didn't migrate the tax group.

Is there a way in phpmyadmin to set all products to tax group "BTW hoog" (in this case)?

I have found the way to do it in OC 2.x but since i am no database guru i am asking here just to be sure.

Thanks, it will save my updating 1100 products.

Hi,

Made backup of database.
Changed one product to right tax class/group
Looked in database for ID of that tax class/group, in my case it was 11
Then ran this code in phpmyadmin UPDATE `oc_product` SET `tax_class_id` = '11';

And yippikayee it worked. All products hafe the right tax class/group