How to change ordering of categories?

[dohuythai]

As title, could someone tell me how to do that? (I don't want remove all categories and re-make them 🙁)

 

[Rodolfo]

Categories are sorted alphabetically. Can't be modified.

 

[dohuythai]

Categories are sorted alphabetically. Can't be modified.

I know but it's crazy if can't modified ordering, could you please process this? thanks

 

[Rodolfo]

app/loader.php

$categories_db = DB::queryFetchAll('SELECT * FROM ' . DB::getTable('categories') . ' ORDER BY category_name ASC;');

You will need to edit the ORDER BY clause. http://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html

 

[dohuythai]

app/loader.php

$categories_db = DB::queryFetchAll('SELECT * FROM ' . DB::getTable('categories') . ' ORDER BY category_name ASC;');

You will need to edit the ORDER BY clause. http://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html

Thank you, I got it

Hope next version you will add a ordering in setting, so we can use it easy to ordering by myself

Here is example: https://jqueryui.com/sortable/