Reply To: Ordering result article numbers

#15303

Ernest Marcinko
Keymaster

Hi,

Thank you for the details. I have checked the configuration, and both the primary and secondary ordering is set to by 'relevance' as default. However you want to order the results by '_sku' as well as relevance.

I have made the following changes:
– Secondary ordering set to '_sku': https://i.imgur.com/UCd8xQe.png
– Custom field relevance set to 0: https://i.imgur.com/3GmmPF6.png

Explanation
This is sort of a strange configuration at first, but it should do the trick. By changing the custom field relevance to 0, the _sku fields do no longer affect the primary ordering (the relevance itself). But since '201120' only matches the '_sku' field, the primary 'relevance' ordering has no effect, as all items have the same relevance. Because of that, the secondary ordering is used, which re-orders the results by the '_sku' field.

This should more likely give you the expected ordering in most case, however it is not perfect by any means.

I hope this helps!

Best,
Ernest Marcinko

If you like my products, don't forget to rate them on codecanyon :)