Skip to Content
Dette spørgsmål er blevet anmeldt
stockmodulesAPIInventory
3 Besvarelser
7671 Visninger
Avatar
Juan Yunes

I need to automate the request to the API of a warehouse company and update the stock of my inventory module with the response. I'm new to Odoo and as far as I researched the easiest way to implement anything in Odoo is using some existing module, but I don't know exactly what the appropriate module for this case is (if there is any). Also, I watched some tutorials where people programmed entire API modules and I think that would be more than I need. I would appreciate any help!


To be sure you fully understand the explanation, this would be an example of what I want to achieve:

1. The stock of product X in my inventory is 5.

2. The automated request to Warehouse company's API triggers.

3. The response indicates that product X inventory is actually 3.

4. My inventory gets updated to show product X stock is 3.

Avatar
Kassér
Avatar
Michael Hofer
Bedste svar

I recently had a similar requirement and was able to solve it with these steps:

  • Create a new stock.quant​ model with the following data:
    • ​product_id​: Associated product.product
    • ​location_id​: Warehouse ID
    • ​inventory_quantity​: Stock at hand
  • After creating the new entry, it will not immediately be applied. You will need to call the action action_apply_inventory​ and pass the ID of the new stock.quant​ model.

Maybe someone has a better solution, but this is the only viable solution I have found so far. However, it should thoroughly be tested to see if it has any side implications in your use case.

Avatar
Kassér
Sébastien Feugère

For what version of Odoo? I tried to do this on v17, but after I create a `stock.quant` entry and try to call the `action_apply_inventory` action on it, it says

"Record does not exist or has been deleted."

The record does exist, though. What I noticed is that after a couple of hours, it is automatically deleted.

Avatar
Tommy Gombar
Bedste svar

Hi Michael, 

Are you sure the association is approriate ? 

  • ​location_id​: Warehouse ID

I am leaning much further into saying this is the LotStockLocationID. 



Avatar
Kassér
Avatar
Robert
Bedste svar

I am interested in how you called the action with the API.  All of my attempts have not gotten anywhere.  I can update the quant with the appropriate numbers but can't get it to actual update the count in the system.

Any help is appreciated.

Thanks

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Bulk Inventory Adjustment for Multiple Locations Løst
stock locations Inventory
Avatar
Avatar
1
okt. 24
2641
Can't update the stock of a product with 0 quantity from external API Løst
stock XML-RPC API Lots/Serial
Avatar
1
feb. 23
4030
How to disable merge in stock move(V10.0-V14.0)
stock move picking Inventory
Avatar
Avatar
Avatar
2
aug. 22
5898
Automatically remove products from POS when products are out of stock in v8.0
stock modules pos odooV8
Avatar
Avatar
Avatar
Avatar
Avatar
5
apr. 24
10300
Error when installing stock module
stock modules database addons
Avatar
Avatar
3
sep. 17
6251