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
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!!
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!!
An awesome Web Development company based in Leeds. E-Commerce Specialists by day, Geeks and Gamers by night
Tel: 0845 634 1838
Web: http://www.welfordmedia.co.uk
Twitter: https://twitter.com/welfordmedia
Facebook: https://www.facebook.com/welfordmedia
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
Who is online
Users browsing this forum: No registered users and 47 guests
