Odoo Help


In POS only display on hand quantity

Harsh Dhaduk
on 3/26/14, 9:40 AM 3,946 views

Hello Every one

i have 15200 products and 10000 up product has no quantity so it takes too much time to load.

please give me advise how can i display product has at least 1 quantity ?

i try in pos in get method to set 'qty_available' > 0 but it's not working.


Thierry Godin

--Thierry Godin--
| 8 7 8
Collegien, France
--Thierry Godin--


Thierry Godin
On 3/26/14, 11:51 AM


You have to override load_server_data() in point_of_sale\static\src\js*model.js* around line 176 :

            return self.fetch(
                ['name', 'list_price','price','pos_categ_id', 'taxes_id', 'ean13', 'default_code',
                 'to_weight', 'uom_id', 'uos_id', 'uos_coeff', 'mes_type', 'description_sale', 'description'],
                {pricelist: self.get('shop').pricelist_id[0]} // context for price

Current filter is [['sale_ok','=',true],['available_in_pos','=',true]],

So You can add :

 [['sale_ok','=',true],['available_in_pos','=',true], ['qty_available' , '>', 0]],

I hope this helps.


I appreciate your ans when i checked in product.product module they have qty_available column but it is function not a column in database when i tried as you suggested also coming product which has quantity 0

Harsh Dhaduk
on 3/27/14, 3:20 AM

@Thierry Godin it's working your rule for me thank you soo much...

can you please do somethink for more please can you please tell me.

if product stock gose to 0 qty it's automaticaly remove from POS with out refreshing page..is it posible?

Usman Farzand
on 1/24/17, 7:10 AM
On 6/1/14, 9:50 AM

I tried the same thing but without success, have you found a solution

shashank verma
On 3/26/14, 10:21 AM

Use domain filter to display products with qty>0



It just an example , you need to pass proper field name to make it work

Thanks for your answer

i tried but same output is coming.

Harsh Dhaduk
on 3/27/14, 3:22 AM

@Shashank Verma can you please tell me how i can put this domain to rule i mean which model

is it possible to nagtive value item not show in pos ????

Usman Farzand
on 1/24/17, 6:58 AM

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

1 follower(s)


Asked: 3/26/14, 9:40 AM
Seen: 3946 times
Last updated: 3/16/15, 8:10 AM