[TYPO3-shop] sorting by category

[Franz Holzinger]

Hello Bernd,

> I have a littel problem with sorting products in list view.
> I use tt_products. 2.7.0-35 wit mbi_product_categories 0.3.3.
> 
> If I set
> plugin.tt_products.conf.tt_products.LIST.orderBy = category
> nothing is sorted (means sorting is by id)
> 
> If I set
> plugin.tt_products.conf.tt_products.LIST.orderBy = title
> it is sorting as wanted.
> Is this a bug or do I need another sorting argument for categories if I 
> use mbi_product_categories.

This orderby configuration of the tables is always done on the values of 
the table rows shown by phpMyAdmin.
The category field in tt_products will show the first category of the 
product. So it is sorted by the uid of the category, isn't it?

If you want to sort by the category title, you must use
plugin.tt_products.conf.tt_products_cat.LIST.orderBy = title


Franz