Woocommerce Status - Sorting bug

[FeIix (FLX)]

Hi,
I’m trying the MainWP Woocommerce Status Extension, and just noticed a small bug with column sorting :

The order is wrong for numeric values :

Sales This Month => If the currency is before the number, it’s placed before sites who have currency after price, even if the value is larger (order by desc) :

€0,00
£0.00
900€
40€
300€
0€…

Look like it’s ordered alphabetically, not with natsort or something like that.

Same problems with all last columns showing X Products and X Orders.

Should be an easy fix !

Thank you

[bojan (Bojan Katusic)]

Hi @FeIix

I couldn’t replicate the issue. The position of the currency symbol appears to be purely visual, and the list is sorted by the amount.

The sorting for the last columns also seems to be fine. Not sure how the last three columns might be affected, considering they all have the same order of data, a value, and then a descriptor: e.g., “2 Products”.

[FeIix (FLX)]

I guess in your example, the alphabetical order and numeric order are the same.
If it’s not the currency, maybe it’s the decimal ?

If you could add a row, for example 30 (€/$), it will be between 300€ and 200$, instead of after 200 :

300 => 30 => 200
Instead of 300 => 200 => 30,

because they both start with 3.

if you had a site with only 9$ sales this month, it would be placed first in descending order, because 9 > 300 alphabetically

[FeIix (FLX)]

Another example with orders, we can see that 5 > 43, etc…

[bojan (Bojan Katusic)]

I’ve tried with your examples and “Sales this month” is sorting properly.

I did, however, replicate the sorting issue with the last columns. They appear to be sorted alphabetically.
I have passed the issue to the Dev team.

[FeIix (FLX)]

Do you have it also with products ?

For the sales, I was thinking it could be a locale problem ? The first 0,00€ has a comma decimal separator
For the second one, maybe it’s the £ symbol ?

[bojan (Bojan Katusic)]

Yeah, it’s the same alphabetical sorting with products.

Indeed, the “Sales this month” does have an issue when there are mixed decimal points.

When all the decimal points are the same, sorting is fine.

I’ve passed this to the dev team as well.
Thank you for reporting it to us.

[bogdan (Bogdan Rapaić)]

Resolved in the MainWP WooCommerce Status Extension version 4.0.7