Custom Product Sorting and Editable Product Sorting Queries

Posted: November 30, 2017 at 1:43 PM Quote #197050
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..
This post/answer is useful
-1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thank's,
Atul Rungta
====================================================
Skype: atulrungta
Email: [email protected]

Surat, Gujarat - INDIA
@ * Save paper {Save Trees} *@
Posted: December 01, 2017 at 3:08 AM Quote #197079
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
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Interested in the dedicated Premium support services provided by core developers? Please visit http://www.nopcommerce.com/supportservices.aspx

Regards,
Andrei Mazulnitsyn
Posted: December 01, 2017 at 1:21 PM Quote #197116
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?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Thank's,
Atul Rungta
====================================================
Skype: atulrungta
Email: [email protected]

Surat, Gujarat - INDIA
@ * Save paper {Save Trees} *@
Posted: December 05, 2017 at 3:39 PM Quote #197281
a.m. wrote:
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


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.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.