Admin product sorting by stock level doesnt work

[havenswift-hosting]

Admin -> Products clicking on stock level (which is supposed to be a sortable column) actually sorts by price !

Validated in multiple stores - it gives url ?_g=products&node=index&sort[price]=ASC

[abrookbanks]

Am I in the wrong place? It's not sortable on my store.

[havenswift-hosting]

No, just my monitor not showing the field division lines and thinking the one next to "stock" was for stock which on a large screen, it looks much closer to.

In this case, can you please add it - simple and useful

[abrookbanks]

Unfortunately this isn't possible because it's dynamic against the product options matrix table. It would be possible if the store didn't use stock level at option level I suppose.

[abrookbanks]

Ok we can do this but only for stores that don't use the option_matrix table for stock.

[havenswift-hosting]

For stores that use matrix stock levels, would it not be possible to use the lower matrix level when doing a low to high sort and the upper matrix level when doing a high to low sort ?

[abrookbanks]

Not without very heavy complex SQL.

[bhsmither]

Perhaps a query very much like what is used to populate the Dashboard, Stock Warnings tab?

Do not filter out by 'stock warning level', and accept the result that when sorting by stock level, the list will contain all the variations, but perhaps not when sorting by any other column.