Sort Category Box?

[suntower]

Is there a way to resort the categories so that they display alphabetically in the list in the left box?

As it stands, if I add a category it always show up at the bottom.

TIA,

---JC

[Ajeh]

By default the Categories sort by sort order, category name ... if you have no sort order than you will get categories name ...

[suntower]

By default the Categories sort by sort order, category name ... if you have no sort order than you will get categories name ...

That's not what's happening. Is there a place in the Admin to specify the sort of the category box?

TIA,

---JC

[stevesh]

That's not what's happening. Is there a place in the Admin to specify the sort of the category box?

Not that I know of. As Ajeh said, if there's no sort order specified, the list is sorted aplhabetically by category name, unless (apperently) you have categories in different product types. It looks like the Music product type categories display first.

[Ajeh]

If you look at the SELECT statements in the class categories_tree, they all use:

order by sort_order, cd.categories_name";

Unless you are using something else for your categories sidebox, that is the way things are sorted ...

You could customize that, but if you are not using the categories sort order, and just the categories_name, then it is difficult to say why they do not sort by name for you ...

[suntower]

Thanks, this gave me the clue.

I checked the category table in Navicat and the 'sort' column was all Nulls. I set the values to 0 and all is well.

We moved servers several months ago and did an import/export. Must've happened then and I didn't notice because we haven't changed any categories since then.

CHEERS!

---JC

If you look at the SELECT statements in the class categories_tree, they all use:

order by sort_order, cd.categories_name";

Unless you are using something else for your categories sidebox, that is the way things are sorted ...

You could customize that, but if you are not using the categories sort order, and just the categories_name, then it is difficult to say why they do not sort by name for you ...