SOLR not sorting results as expected

[SAPSupport]

When we search for a determined product, sorting by Descending or Ascending is not happening properly as expected.
Instead of Sorting by the final part of the product's name which contains the product's size/dosage, it sorts only by in Alphabetical order.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

This is an expected behavior, as the Ascending/Descending sorting will organise the products in a list from A-Z/Z-A, specially if your Default Sort Order is not defined. However, you can create rules to sort the results of your Search in a way that suits you and your customer's needs better.
Although the title mentions Backoffice, the KBA 3239442 - Articles do not maintain position on Products search result list in Backoffice shows how you can do so with any collection you have.

In this case, you could create a property named "Size", for example, and implement this functionality.

This would be less laborious than rename each product and place the most relevant detail (that you want to be the Sort parameter) before the other keywords.