How to query qty_available from products, for a specific location?

Question

I would like to query available stock for a given list of products, in a given location.
Currently I'm searching in stock.quant, with [['product_id.x_some_studio_field','in',[array of blah],['location_id.name','=',location_name]]
the problem with this approach is that it seems if the product never had stock entered in stock.quant, it will not return a line for the product.
Is it possible to query the product.product model, so I can read qty_available, but only for certain locations?

Vishal Thacker · Answer

Hello Hernan,
You can do the following to fetch the available quantities particular for that stock location
product.with_context( {'warehouse': your_warehouse_id}).qty_available  Thanks

Этот вопрос был отмечен

Enjoying the discussion? Don't just read, join in!