As that is just straight SQL, it can work with any version ...
NOTE: Be sure to backup your database before attempting it and then when done, go to the Tools ... Store Manager ... and update the:
Type: Posts; User: Ajeh
As that is just straight SQL, it can work with any version ...
NOTE: Be sure to backup your database before attempting it and then when done, go to the Tools ... Store Manager ... and update the:
You can run the same command from the Zen Cart Admin in the Tools ... Install SQL Patches ...
Otherwise, you would need to customize the code to build this in as something more user friendly ...
Thanks for the update that this was able to do the Product Price increase that you needed ... :smile:
If all of those Products use that Category's categories_id as their master_categories_id ...
You can backup your database and then run:
UPDATE products SET products_price = products_price *...