Custom sorting field

[pla]

Hi,

is there a way to add a custom sorting field into the mshop_product table which I then can use in the search of the list view?

At the Moment we have some products in different categories. The products are (like usual) only set to the categories of the last level. There I can store a numerious index for default sorting which works when I navigate to that specific category. But When I am now on e.g. the main categoy or any category obove in the rootline and search for a product or set a filter I get the sort order of MySQL which I got from this post I found:

Re: frontend sorting

In that post are also links to three files which need to be adjusted or extended but unfortunatelly the links are too old and therefore dead.

Does anyone know which files have to be changed/extended?

I am using TYPO3 13.4.23 and AIMEOS:
- aimeos/aimeos-core: 2024.10.15
- aimeos/aimeos-typo3: 24.10.5
- aimeos/ai-typo3: 2024.10.5
- aimeos/ai-client-html: 2024.10.7

Would be nice if there is a solution for that. Otherwise I have to add the product into every category of the rootline.

Thanks and kind regards
Pla

[aimeos]

There are two things you may do:

1.) Use client/html/catalog/lists/levels = 3
This displays products of sub-categories in parent categories (up to root) using the position values. If you have assigned several products at e.g. position 1, their order is random/database dependent for all products with position 1.

2.) Set the product.boost value of each product
It's a relevance multiplicator mainly used for full text search but it may be used for this kind of ordering too if you adapt 1-2 code lines.