跳至內容
選單
此問題已被標幟
1 回覆
3322 瀏覽次數

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?

頭像
捨棄
最佳答案

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

頭像
捨棄