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?
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
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.
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'.
Europe, Middle East and Africa