Change sort order of products in a category using phpmyadmin

[mcpisik]

Hi Ajeh and others in the know,
A few years ago you kindly suggested some samples, to change store quantities all to 100 using phpmyadmin.
I was hoping you might throw me an example for another...
Would like to change all products in category 5 for example, to have a sort order of 200. (would like them below other products when a search word is used, as they are accessories)
I would just change them manually but there are 2000 products on the site.
Thanks

[Ajeh]

If all of the Products in categories_id 5 are using that for the master_categories_id then you could use:

UPDATE products set products_sort_order = 200 WHERE master_categories_id = 5;

NOTE: be sure to backup your database before attempting this ...

[mcpisik]

Awesome. That worked a treat.
Thanks for the response and code!

[Ajeh]

Thanks for the update that this worked for you ...

[mcpisik]

Might I ask the php code, to change all products in Category id 1, to have a manufacturer of: XYZ ?

[Ajeh]

What is the manufactuers_id for the manufacturer of: XYZ ?

[mcpisik]

4, thanks

[Ajeh]

If ALL Products that are using categories_id 1 for their master_categories_id need to have their manufacturers_id to be changed to 4, then in the Tools ... Install SQL Patches, you could use:

UPDATE products SET manufacturers_id = 4 WHERE master_categories_id = 1;

NOTE: be sure to backup your database before doing this ...

[mcpisik]

Thanks for the solution again Ajeh :)
I've used this, to change all of our hire/rental items to a manufacturer of "Hire"
And the purchase items to a manufacturer of "Sales"
This allows me to export a report for hire and a report for purchases made for any month, for our accountant.
(perhaps there is a better way, but thought I'd write this in case someone in future may find it useful)

[Ajeh]

Thanks for the update that this worked for you ...