Order Management Automation

From scattered spreadsheets to one connected workflow.

Problem: Information scattered across multiple documents and channels
Sector: Food Production
Result: One Centralized Order System + Messaging

Watch

Intro

Walkthrough

The challenge

Orders lived in too many places.

Client and order data spread across ~15–20 Google Sheets
Day-to-day coordination running mainly through Slack
No single view of a client, order, status, batch or delivery

How it works

One file. One flow.

01ClientsDatabase + new-client entry
02Order entryStructured order form
03All OrdersOne central register
04ProductionOrder Status sheet
05Slack alertsNew orders + threaded updates
06DeliveryDelivery note as PDF

Order print view
Delivery-note log
Delivery tracking
Archive / restore
CSV export

Result

One place for every order.

~150 contacts and ~250 orders in one system
Every department notified in Slack, with traceable threads
Main order tool for ~2–3 months, until replaced by a CRM-based system

Role: Operational needs were researched, departmental workflows were mapped, and a central order-management system was designed, developed and implemented — alongside the Production Manager role. ChatGPT assisted with code generation and debugging.

Google Sheets
Apps Script
Slack
PDF generation

Try the live demo Simplified version · fictional data

← All work Next projectHockey Game Management