Custom Product Sorting and Editable Product Sorting Queries

Hello nopCommerce Team,

I have a suggestion which I felt so many times while looking for it but I am writing it today to you guys. Can we provide an option to add or remove Product sorting option in Admin -> Setting -> Catalog -> Product Sorting?

This way advance users will be able to configure their own product sorting or rename an existing product sorting to anything of their choice.

I understand that it is an enum and this is why we have to overwrite this in catalog page whenever there is a customer requirement but would be better if you can link it to some SQL table.

Also, I would suggest to make queries open to edit for each sorting option. For example, I want to change default logic in Position option and make it behave like a few products should always come on top and other should come as position so I could change that SQL query myself.

I hope you are getting me. Same way, when adding a new sorting option I will be able to write and test my own SQL query and all your catalog page have to do is to execute my SQL query for sorting products.

Hope this will be helpful..

Actually you already can do it in admin area > configuration > catalog settings > "Product sorting" block. You can disabled/enable existing values, change order, etc. You can rename enum values on the langauge details page

Hello Andrei,

Yes I saw that earlier but did not knew about changing names from language resources. Thank you for that. But, can we provide an option to add our own sorting options along with editable queries or something like that in future?

a.m. wrote:

In public side all is ok.
But - How I can sort products in /Admin/Product/List.
After add new product I want see it on first row in table.

[email protected] wrote:

I have same question :)
I want my product list to be sorted by time in admin area.just like blog posts list. from older to newest
how could it be done? where should be edited?

I need sorting in admin grid. Why is it so hard to implement it in this awesome application :)

https://www.nopcommerce.com/en/boards/topic/82741/sort-of-productslist-in-admin-panel

Hi Guys,
I am trying to display items by DisplayOrder (Position) when browsing all items, but it looks like its ordered by SomeOtherField..
I exported all items and modified DisplayOrder field in excel, imported back, but it still not working for me.
All other options are working (Sort by Name, Sort by Price).
Somebody please help.

Anton