All projects / Operations and warehouse

ShiftFlow Data Studio

A desktop app that builds recurring Excel reports from WMS exports in one click.

Live version coming soonDesktop app + browser demo

Problem

Shift reports are prepared daily by hand-adding formula columns, lookups and rules to WMS exports. With no database or API access, automation is hard.

Solution and key decisions

  • Recognises open WMS reports from one-time definitions and catches format changes
  • Builds the report automatically from a saved scenario with "Create report"
  • Daily archive, historical reporting and previous-shift comparison
  • Emails the end-of-shift report to multiple recipients

Tech summary

PythonPySide6pandasopenpyxl

Feedback

Have an improvement idea? Write to me, I read every suggestion. iletisim@ysfdurak.com

In the same category

Runs in the browser

Sorter Studio

Sorter selection and sizing decision support for an operation that does not exist yet.