Odoo Help


This community 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.


Can I get a list of products that are in stock

on 1/13/14, 9:46 AM 1,256 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 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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