Need to reorder the side menu categories in PowerStore 4

I need to show the categories in the main menu products drop down as well as the side menu categories in reverse alphabetical order. I found other articles that talk about reordering the categories, but I am not seeing the intermediate.php or main.dwt.php files in PowerStore 4. Has this changed in version 4?

yes, it has changed in PS4.


the sidemneu is generated by the webassist/plugins/sidemenu/sidemenu.php page.




you can change the recordset code:

$query_SubCategoryList = "SELECT * FROM ps4_categories WHERE CategoryParent = ".$StartWith . " ORDER BY CategoryName";

to order descending:

$query_SubCategoryList = "SELECT * FROM ps4_categories WHERE CategoryParent = ".$StartWith . " ORDER BY CategoryName DESC";

Adding ORDER BY ... DESC works for the main menu products drop down, (main_menu/menu.php). However, I changed side_menu/sidemenu.php to:

$query_SubCategoryList = "SELECT * FROM ps4_categories WHERE CategoryParent = ".$StartWith . " ORDER BY CategoryName DESC";

and it has no affect on the order of the categories in the side menu. Any other ideas?

sorry, the recordset to edit is in the side_menu/nested_accordion/sidemenu.php page:

$query_SubCategoryList = "SELECT * FROM ps4_categories WHERE CategoryParent = ".$StartWith . " ORDER BY CategoryName DESC";

That did it. Thanks! I also found that if you remove the ORDER BY clause completely, it follows the order in the categories database. Good to know.

OK, glad to hear it is working.

I need to not use alphabetical for category order. Is there a way to do that? Perhaps I can add another field to that table and sort numerically?

Or perhaps the category parent number would be the right path?

thanks

Figured out a work around. A space before the category name moves it up to the top. Two spaces moves it above the single space. Works perfectly fine for my needs. Thanks.