Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Product Display order not working

  1. 03-03-2010, 05:30 PM #1
    tessaluu is offline Junior Member
    Join Date
    Sep 2009
    Posts
    3

    Unhappy Product Display order not working

    Hi,
    I have ML version 7.x and I am having problems with getting the product display order to work properly. I go to the respective category, then "display order", then change the order of the products I want to appear first as 1,2,3,4 etc. For some reasons the change does not display on the live site properly. It changes the display order on the back-end, but not on the live site. I can't figure out how to else to change it and I searched all over the forum without success.

    See below for screen shots.

    Secondly, does anyone know how to change the product display order so that the newest products are displayed first automatically? Newest products being the ones with the most recent entered date.

    Thanks in advance!

    Back end is working fine:
    http://www.insideavenue.com/images/upload/example1.gif

    but front end does not show the changes:

    http://www.insideavenue.com/c-460-deal-of-the-week.aspx
  2. 03-03-2010, 06:12 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Sometimes (specially if cachemenus is set to true) you need to do a "reset cache" in the admin to have your changes reflected. What is the exact four digit version you're on so I can verify?

    It is possible to change the product display order according to createdon field, yes. You should be able to modify that in Aspdnsf_GetProducts stored proc, there's something like ORDER BY pf.rownum at the bottom you can change it to ORDER BY p.CreatedOn.