[solved]How to set a taxrule for all products

[LuiGi]

Hey everybody,

 

First of all thanks for your help. Let me tell about the problem:

In the beginning i missed to set the taxrule for my products, where i found i just can put the right price into the price field and it's done.

Yeah you always learn...Now i got to set a taxrule to all my products (2088 articles) which i don't want to do manually.

Is there anybody who knows how i can set the taxrule directly for all my products?

 

I already tried to export my database as csv and searched for the setting, but didn't found one.

 

Thanks and have a nice day

LuiGi

[LuiGi]

Hi,

 

Thanks for your advice.

Do you know how i exactly should do this? In the BO?

And how should this query look like to change the value for all products...

 

Thanks and best regards

Lucio

[selectshop.at]

If you want to do it by mass:

 

First of all you need to know the ID of the tax rule you want to set. You will find the ID in database table ps_tax.

 

Than you can apply direct on database with phpMyAdmin this both SQL queries:

 

UPDATE `ps_product` SET `id_tax_rules_group`='2' WHERE  `id_tax_rules_group`=1;

AND

UPDATE `ps_product_shop` SET `id_tax_rules_group`='2' WHERE  `id_tax_rules_group`=1;

 

id tax 2 is the new, id tax 1 is the old one.

 

BEFORE YOU MAKE ANY CHANGES ON DATABASE MAKE A BACK-UP !

 

You can also use the Presta Store Manager for edit by mass, or other free module you will find on the free addons. Or use the back-office option "advanced parameters -> SQL-Manager"

[LuiGi]

Hi,

Sorry, i forgot to answer. I was excited that it worked directly.

Thanks a lot!

BR

LuiGi