How do I change the sort order of a category?

[mipavluk]

It also worked for me!!! Thanks!

[khopek]

AHHH FINALLY!!!!!!!!!!!! This took me FOREVER to find. I needed all my categories to sort newest to oldest and this worked!

There were to places where this code showed up

$listing_sql .= " order by p.products_sort_order, pd.products_name";

My products didn't sort right til I replaced the second.

Thank you!!!!!!!

[HappyMom]

AHHH FINALLY!!!!!!!!!!!! This took me FOREVER to find. I needed all my categories to sort newest to oldest and this worked!

There were to places where this code showed up

$listing_sql .= " order by p.products_sort_order, pd.products_name";

My products didn't sort right til I replaced the second.

Thank you!!!!!!!

Also - make sure tha the "Display Product Listing Default Sort Order" option, in your Store->Configuration->ProductList is set to blank/empty. If you put zero, you first product listing page will be sorted correctly, but the next page (using the arrows links and/or the page numbers), will go back to sorting using the "1a" option.