I am still looking for a way to list only products with negative values in the ‘Current Stock’ or ‘Back Orders’ column of Stock Central. My Woocommerce shop has hundreds of simple and variable products, of course.
The Backorder column does show negative values, but when you click on the column header to do an ascending sort, it starts from zero not negative values!
Secondly, I have not found any way to list only items with negative values in stock or backorder!
Perhaps what you have are negative stock in variation products? In this case, the column sorting cannot sort these values as variation products are on a second level. Only products in the first level (simple products, for example) are effective for sorting.
But the negative values should appear on the variations when applicable, of course.
Actually is not possible to sort them all together. Just take this as an example:
If you have a variable with 10 variations and only one of them has negative stock and the rest have stock (but different quantities each one), how we would sort them in the same level as all the other simple products? Please, note that the variations always have the variable product at the top (as a container). So, in this case, we would have to repeat the variable container row as many times as the number of variations and sorting positions to be able to sort them all in the correct place. So two levels at the same time is not technically possible in the way ATUM works, I’m sorry.
However, if you click on the top “Backorders” view, it should show only products with backorders enabled and stock lower or equal to 0:
I tried many possibilities, for example I filtered product types as ‘Simple’ or ‘Variable’ (using the top dropdown filters), but no sorting action takes the negative values into account!
Do you advise checking mysql table field settings or so?
But do you have negative values in simple products?
If so, the first thing I would try is to check for any possible conflict with any 3rd party plugin by disabling all your plugins except WooCommerce and ATUM.
