RAW LOGICREAL SYSTEMS.EL

CASE STUDY / 03

Sklavounos Warehouse

STOCK · PRODUCTION · LABELS

An autonomous operational product for stock, transfers, shortages, purchasing, production and controlled label printing — designed around the real movement of a warehouse.

CURRENT STATEIn use · under controlled ongoing development

00 / AT A GLANCE

The project at a glance.

PROBLEM

A final balance is not enough; every change needs a location, direction, reason, pending state and auditable trail.

SOLUTION

An autonomous system that organizes stock, transfers, purchasing, special workflows and controlled printing into distinct operational areas.

IN USE BY

Warehouse operations covering stock, transfers, shortages, purchasing, production and labels.

OPERATES ACROSS

A Postgres-backed web service and an internal Windows print agent; One receives bounded read-only projections only.

MY ROLE

Product design and UX, backend, data flows, labels/printing and deployment.

STATUS

The core service is in production and evolves under controlled gates; Inventory v1, One SSO and Label Designer 1.0.16 remain gated candidates.

01 / THE NEED

Inventory must explain every change.

A real warehouse needs more than a final number. It needs location, movement direction, reason, pending state, receipt, shortage and an auditable record of who did what.

  • CENTRAL and WORKSHOP need clear balances and linked transfer movements.
  • Shortages, pending quantities and partial receipts must remain visible until closed.
  • Labels and print jobs must stay bound to the exact approved data and layout version.

02 / IN PRACTICE

Critical workflows remain visible.

Warehouse organizes critical operations into distinct, controlled workflows while remaining the source of truth.

  • Every stock change is tied to a location, direction, reason and movement history.
  • Transfers between CENTRAL and WORKSHOP, shortages, pending quantities and partial receipts remain visible until they are closed.
  • Printing runs through station-scoped jobs with version-bound payloads, keeping data and layout tied to the approved version.

03 / THE FLOW

From movement to an evidence trail.

The system organizes distinct operational areas without conflating product stock, freezer balances, consumables and controlled printing.

  1. 01

    STOCK

    Locations and movements

    Balances, IN/OUT, paired transfers, overdraw protection and movement history.
  2. 02

    SUPPLY

    Purchasing and receiving

    Purchase suggestions, pack rounding, partial receiving and idempotent repeat handling.
  3. 03

    SPECIAL FLOWS

    Shortages, freezer, consumables

    Separate workflows and ledgers for operations that should not be compressed into one table.
  4. 04

    LABELS

    Queue and HPRT agent

    Station-scoped jobs, terminal states and version-bound payloads for controlled physical printing.

The public visual is a synthetic functional map. It uses no real products, quantities, suppliers, lots or production labels.

04 / EVIDENCE

Critical flows have been characterized and tested.

The case study is grounded in real code, tests, restore evidence and guarded release handoffs without exposing operational data.

01

Stock integrity

Negative-balance protection, paired transfers, exact missing/owed reduction and a verified movement trail.

02

Purchasing and receiving

Stable purchase suggestions, pack rounding, capped receiving and safe retries without duplicate movements.

03

Read-only integration

The production-active aggregate bridge to One is GET-only, bounded and exposes no rows, suppliers or credentials.

04

Controlled label evolution

Label Designer 1.0.16 provides immutable drafts, separate activation, audit reasons and snapshot-bound print jobs, while remaining a gated candidate.

05 / TODAY

Live core. New features behind separate gates.

The core Warehouse service is in production and remains autonomous. Newer extensions are not presented as already active: they require backup, exact-version evidence, a physical test print and a reversible rollout.

CURRENT FOCUS

  1. 01A synthetic public demo for stock, transfers and shortages.
  2. 02Staged activation evidence for inventory projections and SSO.
  3. 03Controlled rollout of Label Designer and the compatible HPRT Agent.
  4. 04An append-only freezer ledger and stricter print-job leases.

Sklavounos Warehouse retains its own independent product identity. Christos Fragoulis is its sole creator and sole legal owner, as well as the owner of the original source code, designs, documentation, assets and deliverables he has created for it. RAW LOGIC serves only as his personal creator/portfolio identity and is never placed on regulated labels.

06 / CONTACT

Does an operational workflow need a clearer system?

Describe the current process and the point where time, information or control is being lost.