ToolBossParser — ERP Integration & Automated Reporting Service

Finance staff were manually copying data between inventory kiosk reports and ERP forms every day — an error-prone, time-consuming process with no audit trail.

Each ERP upload required multiple sequential API calls per line item: part lookup, job lookup, inventory prefetch, and a bin transfer to complete the tooling-to-job assignment. An initial deep-call-stack design — where each step internally called the next — produced enormous, nearly unreadable stack traces when any step failed, making errors nearly impossible to attribute or debug.

The call stack was flattened into a pipeline architecture: each ERP step became a discrete class that received a line item object, performed one operation, appended a result status, and returned. The orchestrator passed each item through the stages in sequence and collected failures without any step knowing about the others. This made the failure surface immediately obvious and the code straightforward to extend. Per-item state and a full retry history were persisted in SQLite, with filename-to-datetime parsing used to detect and skip already-processed files without a separate tracking table.

Deployed across multiple buildings. Up to 10 hours of manual labor saved per week. The daily HTML report became a cornerstone of several managers' workflows.