Automated Odoo Inventory Valuation Snapshot
Every night, WebRun opens Odoo, reads the inventory valuation report, splits the on-hand value across raw materials, work in progress, and finished goods, records a dated snapshot to a Google Sheet, and sends you a Telegram summary of total stock value and how it moved since yesterday.
How do I track inventory valuation and stock on hand each night?
Every night, WebRun opens Odoo and reads the inventory valuation report, splitting on-hand value across raw materials, work in progress, and finished goods. It records a dated snapshot to a Google Sheet and sends you a Telegram summary of total stock value and how it moved since yesterday, so you always know what your stock is worth and where it sits.
- Total stock value is captured every night
- Value is split across raw, WIP, and finished goods
- A dated history shows inventory creeping up or down
Built for finance teams · operations managers · small manufacturers · inventory controllers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.odoo.comin a real browser with your saved login - no setup, no API keys. -
1
Odoo - read the inventory valuation
odoo.com
WebRun reads the Odoo inventory valuation report. - Open the Odoo Inventory app and go to Reporting, then Valuation
- Capture the on-hand value of each product and its product category
- Group the value into raw materials, work in progress, and finished goods
Done when Inventory value is captured and grouped into raw, WIP, and finished goods.
-
2
Google Sheets - snapshot value by category
google.com
WebRun records a dated valuation snapshot split by category. - Open the stock valuation snapshot sheet
- Add a dated row with the value of raw materials, work in progress, finished goods, and the total
- Compare against the prior snapshot and record the change in each category
Done when A dated valuation snapshot with category split is recorded in the sheet.
-
3
Telegram - summarise total stock value
telegram.org
WebRun sends a Telegram summary of total stock value. - Send a Telegram summary with total stock value and the split across the three categories
- Note how the total moved since the last snapshot
- Leave any stock adjustment to your team. Never edit a valuation or a quantity in Odoo on its own
Done when You have tonight's stock valuation summary in Telegram.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it change any stock quantities or values?
No. WebRun only reads the Odoo valuation report to build the snapshot. Adjusting a quantity, revaluing stock, or posting an inventory entry stays with your team inside Odoo.
How does it split the value?
It reads each product's on-hand value and product category from the Odoo valuation report, then groups the total into raw materials, work in progress, and finished goods so you see where the money is tied up.
Why snapshot it every night?
A dated nightly row in Google Sheets builds a history of stock value, so you can see whether inventory is creeping up, where it sits across the three categories, and how it moved without rerunning the report by hand.
Related templates
Shopify›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.