Sort products

[traiyani75]

Hello,

We are using JSON APIs into mobile application for eCommerce. Now, We have end point to get all products and get all products by category.
We have option to assigned them position into categories products. But we are not able to get those products by position.
If we call api to get products without any filters then it is working, but if we pass category id using filter[f_catid] then products are not sorted as per admin position

Regards

[aimeos]

You must use

Code: Select all

<product endpoint>?filter[f_catid]=123&sort=relevance

[traiyani75]

I have tried but its it not working with category filter. I set position for multiple products and tried end point with
sort=relevance and sort=-relevance. Both time result is same

[aimeos]

"-relevance" doesn't exist. If you add filter[f_catid]=10 to the JSON REST API URL of the product endpoint, the returned list of products is automatically sorted by the positions you've assigned to the product references in the catalog panel of the admin interface.

[QuốcTrungNguyễnHoàng]

Sorry it not working,
It still sort by product.id

Both add sort: 'relevance' or not add with filter: {f_catid: categoryId}
It work after i'm rebuild index

[aimeos]

Only one price is stored in the mshop_index_price table and this is the one customers can sort by. If you want to sort by several price types (default and listprice for example), you would have to extend the table by the price type, extend the index price manager to store prices of all types and extend the frontend controller and/or the HTML client to pass the price type to the filter.

[TGergo]

Small bug:

Sort by Rating works well.
But It won't be bold, when selected.

[aimeos]

Thanks for the hint! This has been fixed now in aimeos/ai-client-html dev-master and 2022.10.x-dev