跳至内容
菜单
此问题已终结
1 回复
3335 查看

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

形象
丢弃