woocommerce results – sku sort

[stavroch]

Thank you for this.

I didn’t change anything from the back end and in front end i can’t see any product when I search for 101-0100

Why?

[Ernest Marcinko]

Hi,

Because there are no products starting with SKU ‘101-0100’, and there is no word in the text starting or ending with ‘101-0100’, in any of the products.

I see you want partial matching within text word centers, so I have turned off the index table engine. This will however yield less relevant results.

[stavroch]

Ok now I search for 01-101-0100 which start sku product.

Again that product is not displayed in the result page in front end first.

[Ernest Marcinko]

Once again, because you wanted ‘_sku’ sorting, with partial matches within the text, and the partial matches with the alphabetically preceeding ‘_sku’-s preceed that product.

It’s simply not possible to have the target product as first, when the primary sorting is set by ‘_sku’ , when the partial match ‘_sku’ are alphabetically preceed the target product – the target is simply pushed to the back, beyond the limit, because of the primary sorting by ‘_sku’.

[stavroch]

sorry again.

ok i see what you mean.

Why when I search for 01-101-0100-0 displayed in 4th page? and in Greek page is not displayed?

Is the same reason as you describe?

[stavroch]

So the result page is combination of sku and title name. right?

ex.
101-11111 – Aproduct…
101-0100 – Bproduct…

so when I search for 101-0100 it will be displayed with the above order?

[Ernest Marcinko]

Hi,

The results page layout, and how the name is displayed does not affect the sorting, it does no effect.

If the primary sorting is set by ‘_sku’, it means that for example if you type in ‘101-0100’, then no matter where the match was, it will be ordered by ‘_sku’: http://i.imgur.com/ussuvon.png
(this is same on the results page, it’s just an example)

The ordering is correct as configured (_sku ascending):
01-044-5800-0
01-044-5801-0
01-044-5804-0
01-044-5814-0
…
01-101-0100-0

The ordering is applied after the search, and because ‘101-0100’ matches other products in the product content, it displays those as well, ordered by their SKU.

[stavroch]

ok thank you.

[Author]

Posts