Page 1 of 1
how to make at once modification of tax for all products
Posted: Thu Feb 14, 2013 12:54 am
by karadev
hi, i have a question >> how to make at once modification in data base of tax for all products because i have so mach product that now need to use taxes , i need some sql code to alter in database for all product use my only one tax class
best regards
Re: how to make at once modification of tax for all products
Posted: Thu Feb 14, 2013 6:20 am
by welfordmedia
Create your tax class that you want to assign to all products and get the ID from the database.
The SQL is
UPDATE product SET tax_class_id = '12345'
Change the ID to what you created.
TAKE A BACKUP OF THE DATABASE INCASE YOU MAKE A MISTAKE!!
thanks , will try in to test subdomain first :)
Posted: Sat Feb 16, 2013 11:03 pm
by karadev
Re: how to make at once modification of tax for all products
Posted: Sun Feb 17, 2013 2:41 am
by Johnathan
You could use
Bulk Product Editing if you're often making these kinds of mass changes.