How to sort product list on SKU content?
Despite reading many articles of other kickstart users who try to sort on the SKU without success, like them I cannot find any solution for the following:
I use something like AB1234-knife and AB1234-spoon as the SKU
If I search in AB1234 I get both correct presented in the product list results which is intended. Both items were added at a random point in time, so, in the unfiltered product list they don't show up next to each other, thats due to the basic sort like 'newest not top' in the product list display.
I want to have the product list sorted on SKU, the sort filter above the page (newest/oldest, title etc) is irrelevant for me though sorting on 'newest' remains handy. Problem is that as I cannot add the sku in that section so I cannot create a sorted product page by making this the default in the search api, I cannot add it here either (and then add 'default and descending'. So I tried to override this by forcing the product display to sort on the sku and then on descending. But this also seems completely impossible.
There is no SKU field in the product view sort criteria (at /products). However, I can add this add a field in 'Fields -> add' when I use HTML with forced fields. Yet it still does not appear in 'sort' and neither in 'Relationships -> add'.
So how do you make a product list to be sorted on the SKU only and bypass the search api sort or add the SKU to the search api and make it here the default descending order? (tab Sorts)
It should be simple but despite reading for weeks now I cannot find any solution for such a simple concept. can anyone guid me to a solution or tell me if this is a mistake in the Kickstart design?