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
:ok: :ok: :dance: thanks men , it is great , i want to ask is if have a way to make a command like this for other options in opencart system to set up products , category , etc. properties of system

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.