OdooV13 Get product availability in warehouses using odoo ORM

Question

We have two warehouses and several products in our system. quantity of products are updated and assigned to these warehouses. Is there any way to find out a specific product is available in which warehouse? for example we have a product named 'testproduct'. I want to see which warehouses have this product using odoo ORM. (in which warehouses quantity of testproduct is not zero). thanks in advance.

Arian Shariat · Accepted Answer

I've figured it myself.
product = self.env['product.product'].browse(PRODUCT_ID)
available_qty = product.with_context({'warehouse' : WAREHOUSE_ID}).qty_available
if available_qty <= 0 ...

Tom Van de Velde · Answer

Hi Arian,
You can find that in the inventory report. There you can filter on product, and you'll find all stock locations in the list. In my screenshot below, I have 2 warehouses: M and TT.
There are 11 pieces of the whiteboard in warehouse M and 10 pieces in warehouse TT.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Product Stock stock warehouse product	0 kesäk. 16	3200
Odoov13 object.with_context(...) result doesn't change Ratkaistu stock warehouse product context	2 heinäk. 22	5800
Fraccionar lotes en / Splitting Lots in Odoo 18 stock warehouse	2 elok. 25	1242
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Ratkaistu stock warehouse	2 elok. 25	9186
The inventory module does not assign the next storage location but the central location. stock warehouse	2 toukok. 25	1731

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!