Product Sort Options

Hi RomanovM, my problem is in 3.7 version

and i use "traction" theme

hi there,

I need the product sort option by 'popularity' or respectively 'bestseller' (how ever you want to call it).
NOP Version 3.8

Is this option available?

Further the sort option 'best rated' would be nice.

Best regards,

Stephan

stevo977 wrote:

Hi, Stephan

unfortunately there is no such sort options out of the box.

RomanovM wrote:

I'm using 3.8. Can you tell me how to add a value to that list where I want the field to be AvailableEndDateTimeUtc with a title of Course Data? Really need some help.

Thanks!
Jon

Anyone know how to add additional sort options in 3.8?

Anyone? Any tips to add another sort option? Please?

I found that in 3.8 the "ProductLoadAllPaged" stored procedure orderby default was set at 'position' which ends up being the 'Id' of the product.

I altered the SP to this:

--sorting
  SET @sql_orderby = ''  
  IF @OrderBy = 5 /* Name: A to Z */
    SET @sql_orderby = ' p.[Name] ASC'
  ELSE IF @OrderBy = 6 /* Name: Z to A */
    SET @sql_orderby = ' p.[Name] DESC'
  ELSE IF @OrderBy = 10 /* Price: Low to High */
    SET @sql_orderby = ' p.[Price] ASC'
  ELSE IF @OrderBy = 11 /* Price: High to Low */
    SET @sql_orderby = ' p.[Price] DESC'
  ELSE IF @OrderBy = 15 /* creation date */
    SET @sql_orderby = ' p.[CreatedOnUtc] DESC'

  
-- added this
  ELSE IF @OrderBy = 0 /* SKU */
    SET @sql_orderby = ' p.[SKU] ASC'


  ELSE
   /* default sorting, 0 (position) */

Hi everybody,

I want to set a different sorting function to product page.
On category page I want the products to be sorted by random and in vendor page I want the product to be sorted by newest.

I couldn't understand what I should change in the code in order to do so..
Does anybody know how can I do that?

Thanks in advance!