Custom Sorted List

Is there any way to have a custom sorted list. I tried to add a open text field, similar to the listing module, so you can add a custom sorting string, but i can't make the coding work. I need a very custom sort string, so just sorting on a single field won't work.

Remember this is a sorting string (not a where string):
[ id=45, id=23, RAND() ]

In this case, I need to have a particular product ID display first, then another and then the rest by random.

Also, the cache is interfering with a random display.

A solution could be to create an attribute that you could call "product sorting" i.e.

Then, in your Isotope Product List Module, you can select this field (ascending or descending) to sort your products in front office.

For each product, assign a number in this attribute field and thats it...

Regards
Vinny

The problem is that you need to specify multiple parameters of sorting, this is the problem in essence. I can use a featured to move the "advert items" to the top and then sort by name or random. The current system can't sort random, because it's caching.

I think the team needs to look at that.