Negative values

Hi @msamavi

On the “backorders” column should be only displayed figures for products with backorders enabled and negative stock.
What’s the problem here, please?

Best Regards,
Salva.

Hi @salvamb

Thank you for your reply.

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!

Any help would be appreciated.

I’ve just tried it and it’s working as expected for me:

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.

Hi @salvamb

Yes, as I indicated in my initial post, many of my products are variable. Isn’t there any way to sort first and second levels altogether?

Or, filter to list only stock or backorders with negative values?

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:

Hi @salvamb

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?

Thank you

Hi @msamavi

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.

Best Regards,
Salva.