All templates

Automated Odoo Shipped vs Planned Report

Every night, WebRun opens Odoo Manufacturing, reads the day's manufacturing orders, compares units completed against units planned for each product, works out the attainment gap, logs it to a Google Sheet, and posts your team a Slack report of where the plan was hit or missed.

Runs on WebRun · Strict Lockdown policy
Every night at 9:00 PM WebRunorchestrates each step
1 Odoo read completed vs planned orders
2 Google Sheets work out the attainment gap
3 Slack post the daily report
In short

How do I report daily production against plan in Odoo?

Every night, WebRun opens Odoo Manufacturing and reads the day's manufacturing orders, comparing units produced against units planned for each product. It works out the attainment gap, logs it to a Google Sheet, and posts your team a Slack report with the plant total and the products that fell short, so you know whether the plan was hit before the next shift starts.

  • You know nightly whether the plan was hit
  • Products that fell short are named with the gap
  • Attainment history builds toward a real target

Built for production managers · plant managers · operations leads · manufacturers on Odoo

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.odoo.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Odoo - read completed vs planned orders
    odoo.com
    WebRun in Odoo: read completed vs planned orders
    WebRun reads today's Odoo manufacturing orders, planned versus produced.
    • Open the Odoo Manufacturing app and go to Manufacturing Orders
    • Filter to orders scheduled for today and capture quantity planned and quantity produced for each
    • Note any order left in progress or marked done short of its planned quantity

    Done when Today's manufacturing orders are captured with planned and produced quantities.

  3. 2
    Google Sheets - work out the attainment gap
    google.com
    WebRun in Google Sheets: work out the attainment gap
    WebRun calculates planned-versus-produced attainment in the sheet.
    • Open the production attainment sheet
    • Log planned versus produced units per product and calculate the attainment percentage
    • Roll the products up into a plant total and compare against the daily target

    Done when Attainment by product and a plant total are calculated in the sheet.

  4. 3
    Slack - post the daily report
    slack.com
    WebRun in Slack: post the daily report
    WebRun posts the shipped-versus-planned report to your operations channel.
    • Post a report to your operations channel with today's attainment percentage and the plant total
    • Name the products that fell short and by how many units
    • Leave the schedule changes to your planner. Never reschedule or edit an order in Odoo on its own

    Done when Your team has tonight's shipped-vs-planned report in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.odoo.com
ScheduleRuns automatically on this cadence
Every night at 9:00 PM
DeliveryHow each run's result reaches you
Attainment report · Slack
OutputWhat each run produces - A nightly report of units produced versus planned by product, the attainment percentage, and a plant total against target.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it reschedule or edit my orders?

No. WebRun only reads the manufacturing orders to compare produced against planned. Rescheduling, splitting, or editing an order stays with your planner inside Odoo.

How does it work out attainment?

It reads quantity planned and quantity produced for each of today's manufacturing orders in Odoo, then calculates produced over planned as a percentage and rolls the products into a plant total.

Can it show which products dragged the day down?

Yes. The report names every product that finished short of its planned quantity and by how many units, so it is clear which lines missed rather than just the headline number.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.