Bakery Order Ingestion
An ingestion pipeline that turns wholesale order emails into a production dashboard.
What it does
Wholesale orders from S-kauppa and K-kauppa arrive as PDF attachments in the bakery’s inbox. The system:
- Reads the email.
- Parses the PDF.
- Writes the order to the database.
- Aggregates ingredient amounts across the day’s orders so the next morning’s dough volume is already calculated.
- Drafts an invoice for each order.
The owner opens a dashboard, reviews the production numbers, and approves the invoice drafts.
What changed
Before, the owner read each order by hand and worked out the dough on paper. Hours per week, with the standing risk that a missed order means an empty shelf at the supermarket.
Now it’s minutes a day. Zero errors since launch.
Status
Live. Running every day.