Is there anything built into the products stored procedure sql that allows for changing the sort order of the products? Specifically I want to change it on our entity pages which are using 'entity.gridwithprices' xml pacakge.
At minimum, is it possible to specify addition sort options, like by date added, alphabetically, etc by adjusting any of the query parameters?
Ultimately though, What I really would like to do if possible, is to randomize it so when the page is loaded there are a different set of products every time. is this possible?