How do we find products with 0 stock?

We have some products P in warehouse A without any stock (i.e. the product is empty in the warehouse), and perhaps 1 stock in warehouse B. We can see “stock 0” when we go to Products → List and scroll through all the 1000 products, but we have a hard time finding “stock 0” when going to the warehouse A.

We have tried these:

  1. Products → Warehouse → List → (Select Warehouse A)
  2. Products → Warehouse → Stocks at date → (Select warehouse A)

In none of these two cases, we can find product P with stock 0. All listed products are the ones that have stock > 0.

How can we quickly find all products with stock = 0 so we can purchase new ones?

V19. 0.0

1 Like

Hello,

Wich version of Dolibarr ?
Mine is 19.0.2 and shows everything.

Sorry, forgot version. We use 19.0.0

Have you found a way? :stuck_out_tongue:

Hello everybody,
I have the exact same problem on 19.0.4 and am unable to find which parameter to modify to get this working right…
My main problem is when I come to check what’s missing in our stocks to create manufacturing orders by ticking the “insufficient stocks” box (I’m using the French version so I apologize if the terms are not exactely what appears on the english one) , none of the items with stock 0 are showing, whereas I can see all the items with stocks above and below 0.
I then have to go to the products list and check all the alerts on products with 0 stocks.
Does anyone managed to fix that?

have you set a minimum stock for that product?

Hello jonbendtsen
Sorry for my late answer and thank you for your interest.
Oh yes of course. I wouldn’t expect to have any “insufficient stocks” without a minimum stock set on that products too.
All parameters are the same for all products, it’s only the products with 0 stocks that don’t show in this case.

i use 20.0.4 and I also don’t use stocks for selling dance classes since they are services.

Anyway, when I go to /product/stock/list.php?leftmenu=

I click my warehouse
I then sort by number of units

and I get a list of negative stocks.

If I go to /product/stock/stockatdate.php
and I pick a date, I can not click “Stocks at date” to sort by that, but I can click the “current stock” column then I do get products and service which has 0 current stock.

If I go to /product/reassort.php?type=1&leftmenu= (I use services here, because I only sell services). Then I get a list of stocks and I can sort them by the “physical stock”

I can also put in a limiter, like in the picture where I have only stocks below -20

Maybe if you type in 0 in that physical stock field then it will show you what you want?

There’s also that “Stock too low” checkbox in the top. That does not make any different for me, but I also don’t use stock management because we sell dance classes, and we are more concerned with having a good balance on the 2 roles in partner dancing. We are also concerned about the classes having a similar skill level.

If I where you, I would try upgrading to a newer version of Dolibarr - maybe it has what you are asking for?