Unfortunately we do not have a "weightreverse" parameter for the product module at this stage.
You'll need to adjust your weight for the older product items with a higher wieght value then the new products in this case.
Thats great, just a shame as this is available on web apps i think.
What I'll probably do to keep it intuitive for the customer is to do them
in normal date order using the product weight field and then use something
to reverse them (so keeping it simple for customer)
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.
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.
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.
Thanks for the reply, my small maths brain is definitely starting to hurt
I think that may be too complex for my client to impliment as they are
doing the data entry and I have just about got them to do the extra step by
adding the date to the weighting field so that may be a step too far for
them. Its a great idea though and will certainly use it on other projects
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'.
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: http://archive.plugins.jquery.com/project/reverseorder
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.