Odoo Help


Can I get a list of products that are in stock

on 1/13/14, 9:46 AM 1,961 views

I have a bunch of products (around 10.000) but most of them with quantity 0.

Is it possible to get a list of the products that have a non-zero quantity?

Thanks a lot.


Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
On 1/14/14, 1:25 AM

By default, you cannot do this with the Advanced search or by sorting by column because Quantity on hand and Quantity Forecasted are calculated fields.
A workaround is to export your whole list to csv and filter in Excel. (note: you can save export lists if you need to do this often)

On 10/17/14, 6:50 AM

I found this module:


It is also available for 6.1 - I didn't test it yet, but it looks promising.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 1/13/14, 9:46 AM
Seen: 1961 times
Last updated: 3/16/15, 8:10 AM