[Resolved] Sorting by article number not working

[Author]

Posts

[renatoR]

Hello Toolset
We have a problem with the sorting of thze search results in our product database. Since the alphabetcial sorting didn't get us the correct results, we tried switching to sorting it by article number.

hidden link

as you can see, this is also not in the correct order. The article numbers should sort from the lowest to the highest number. Is there something wrong with our shortcode? Could you please have a look?

The password to look at the site is: "gümligen"

[Shane]

Hi Renato,

Thank you for getting in touch.

I've enabled the private fields for your next response so that you can allow me to have admin access to check on the the issue for you.

Thanks,
Shane

[renatoR]

Hi Shane

I hope the access worked. Did you have a chance to look into this yet?
Thanks much and kind regards
Renato

[Shane]

Hi Renato,

Yes I was able to access the site and check on the view for you. I need some more time on this one to check to see what I can do, however from what I can see it will be difficult to sort because none of the attributes that you are using to sort is numeric or alphabet , rather alphanumeric.

In a case like this you will need to perform a natural sort using the natsort php function below.
hidden link

The only way to get this to sort in the desired way is to write a completely custom wordpress database query so that you can control the sorting.

Thanks,
Shane

[renatoR]

Hi Shane.

O.K, so if I get this right it, it's not possible to do this with the Toolset View Filters but has to be custom coded? 🙁

Thanks for looking into it.

Kind regards
Renato

[Shane]

Hi Renato,

That is correct because of the alpha numeric values. Views relies on the WordPress WP_Query function in order to sort the items and this type of sorting isn't supported by the function.

Thanks,
Shane