Skip navigation
Currently Being Moderated

Can you set a product list  to be ordered by 'weightreverse' intsead of 'Weight'?

May 15, 2012 7:05 AM

Cant seem to get this work with my products?


I have in the weighting field reverse dates so 20120405, and want them ordered by this date (the oldest date first).


Is this possible to order in reverse?





  • Currently Being Moderated
    May 15, 2012 10:33 AM   in reply to Malcolm-Maclean

    Hi Malcom,


    Unfortunately we do not have a "weightreverse" parameter for the product module at this stage. 


    KB reference:


    You'll need to adjust your weight for the older product items with a higher wieght value then the new products in this case.


    Kind regards,


    Mark as:
  • Currently Being Moderated
    May 21, 2012 9:44 PM   in reply to Malcolm-Maclean

    maldc, with the absence of weightreverse, I too have used reverse dates like your example (20120405) to intentionally create a product list in 'reverse chronological', displaying the most recent at the top.


    It seems like you want to display the oldest at the top, but are working in the confines of the reverse date.


    Without javascript, I employ an extra step when entering the data myself, however, someone proficient in javascript may know how to apply this automatically. (Please add something here javascript aficionados?)


    I simply use a calculator to invert the reverse date. For all instances, subtract your reverse date (an 8 digit number) from a fixed 9 digit number, and you will achieve an inverse of that number, which can in turn achieve the reversing effect within a group of numbers.


    For example:


    Older date/lower number: 100,000,000 minus 20120405 = 79879595 (higher number as outcome)

    New date/higher number: 100,000,000 minus 20120406  = 79879594 (lower number as outcome).


    This calculation creates a lower weight value for more recent dates/newer product entries. Thus, your older products entries will show up in the top of the list.


    Does that make sense to you? I hope it can help. It does need further work if there are multiple releases on the same date; in which case, using a larger number will help, such as adding hours, minutes and seconds to your reverse date number, eg. 20120504230053


    If using a spreadsheet to enter product data, perhaps the calculation can be incorporated there.




    Mark as:
  • Currently Being Moderated
    May 22, 2012 1:44 AM   in reply to Malcolm-Maclean can also do the calculation easily using 9's instead of the 100,000,000 in my example. eg. Using 999999999 , and it enables easier mental arithmetic as well.

    Mark as:
  • Currently Being Moderated
    May 22, 2012 5:39 PM   in reply to Malcolm-Maclean

    I know what you mean, my clients are pretty unhappy having to do any extra steps like that. It's doubly astounding to them (and me) that one area of BC has weightreverse, and not other areas. The wishlist has this logged, though the list doesn't seem to get much attention anymore.

    Mark as:
  • Currently Being Moderated
    Mar 30, 2013 8:36 AM   in reply to Sidney Mitchell

    any progress on this?

    Mark as:
  • Liam Dilley
    6,685 posts
    Feb 28, 2012
    Currently Being Moderated
    Mar 30, 2013 2:09 PM   in reply to Todd H&M

    Dont expect to see this any time soon, you need to work around not having this feature.

    Mark as:
  • Currently Being Moderated
    Apr 1, 2013 1:32 PM   in reply to Liam Dilley

    Hi Liam,


    Thanks for the input. While I understand there there are other priorities it would be nice to know that this feature request, and numerous others like it, are logged somewhere when BC does have the time. Once upon a time there was a wish list. Is  there something like the wish list now? If not, perhaps a BC partner could put one together so when BC does come back up for breath on all their infrastucture work they's have a list. Perhaps they have this internally but it would be nice as a partner to know what they actually plan to do 'some day'.


    Thanks, Todd

    Mark as:
  • Currently Being Moderated
    Jul 10, 2013 2:58 PM   in reply to Todd H&M

    This is certainly someting BC should resolve. The order of products needs more options, and should be a simple function for clients to implement and manage without any coding.


    I found that the jquery option works to a point. Use this example:


    The problem with it is that if your product list runs onto two pages (product list) the order gets confusing.


    A normal page without the reverseOrder jquery would show items A to G on page one and would show items H to Q on page two.


    With the reverseOrder jquery you get  items G to A on page one and items Q to H on page two. Rather than the desired Q to A in order across both pages.


    It's simply that the reverseOrder is done client-side after the server-side pages are created. Therefore, it's something BC needs to address as they won't allow us any server-side scripts of our own.


    The inverse date for weighting is an option, and I use it too, but in the scheme of things seems like a poor feature to sell BC on.

    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points