Where the orders came from
The bakery handles multiple customers, products and frequent changes. Messages may also specify packaging and delivery requirements. We compared retrieved messages with the official spreadsheet, keeping the original product, quantity, unit and source reference.
240 packs on both sides, 50 with different products
On November 12, 2026, the team found the discrepancy in an order whose totals matched. The anonymized finding kept the matching message and spreadsheet location and flagged the substitution for staff to verify.
What the daily check covers
- Group orders and changes by delivery date.
- Compare products, quantities, units and special requirements.
- Link each discrepancy to the supporting chat message and spreadsheet record.
- Update the status when evidence arrives and distinguish recorded, pending and issued changes.
- Give staff a list of requirements and discrepancies to review.
Pilot scope and next steps
The workflow was tested using retrieved WeChat messages and the official sheet. Chat replies, issued production changes and completed production are recorded separately and each requires evidence.
Continuous capture and image attachments still need work. Future phases may connect production, packing, delivery and costing records after interface and process checks.
How other teams can apply it
Start with a known set of inputs, a cutoff, defined discrepancy types and named reviewers. Expand after the team can trace each finding and resolve open questions.