Skip to content

WarehouseCounter: High-Volume Depot Auditing System

Description

WarehouseCounter is a high-performance inventory auditing utility designed for the rapid generation of updated stock records in environments like supermarkets and industrial depots.

  • Architecture: The solution runs from a dockerized image which provides an API for the mobile data collector applications.
  • Performance: It is engineered to audit hundreds of articles in minutes, with the capacity to handle thousands of items.
  • Operational Agility: Key features include automatic item description retrieval, partial count tracking, and a "multiplier" function that enables high-speed counting of full boxes or pallets with minimal manual entry.

Technologies used

  • Docker
  • Google Cloud Run
  • Kotlin
  • MySQL / Postgres
  • .NET
  • PHP

Responsibilities

  • Product owner
  • FullStack developer
  • Android Kotlin Lead Developer
  • Windows CE App Main developer

Business Impact

  • Speed: Reduced inventory audit time by 80% compared to manual counting methods.
  • Accuracy: Achieved 99.5% accuracy in stock records, minimizing discrepancies and shrinkage.
  • Cost Savings: Enabled clients to conduct audits more frequently, reducing the need for costly annual physical inventories.

Key Features

  • Streamlined Delivery: Automated delivery of Excel-formatted inventory audits upon completion.
  • On-the-Fly Cataloging: Enabled dynamic product registration during the scanning process, allowing operators to add new SKUs without interrupting the audit workflow.
  • Stand-Alone "Last-Mile" Integration: Engineered the system to operate as a high-performance "last-mile" solution, featuring robust import/export capabilities for seamless interoperability with SAP and other enterprise ERPs.
  • Cloud-Native Efficiency: Optimized the API for deployment on Google Cloud Run (GCR), achieving high availability and performance with minimal resource usage.

Achievements

  • Streamlined delivery of Excel-formatted inventory audits upon completion.
  • On-the-Fly Cataloging: Enabled dynamic product registration during the scanning process, allowing operators to add new SKUs without interrupting the audit workflow.
  • Stand-Alone "Last-Mile" Integration: Engineered the system to operate as a high-performance "last-mile" solution, featuring robust import/export capabilities for seamless interoperability with SAP and other enterprise ERPs.
  • Cloud-Native Efficiency: Optimized the API for deployment on Google Cloud Run (GCR), achieving high availability and performance with minimal resource consumption
  • Cross-Hardware Compatibility: Developed a dedicated Android data collection suite with universal support for diverse scanning hardware and industrial mobile printers
  • Advanced Product Mapping: Implemented support for multiple identifiers per SKU, including DUN-14 (Distribution Unit Numbers) and secondary barcodes, ensuring global supply chain compatibility.
  • User-Centric Design: Designed an intuitive, "zero-learning-curve" interface that allows new operators to become proficient in minutes.
  • Internationalization (i18n): Successfully implemented full multi-language support

Architecture

graph TB
    MAIN([<b>DB</b> </br> MySQL / Postgres])
    WEBSERVICE[<b>FrontEnd / Backend API</b></br>]
    BARCODE_LABEL_PRINTERS[<b>Printers</b> </br>Zebra/Honeywell/etc]
    DATA_COLLECTORS[<b>Data collectors</b> </br>Android or WCE/ WEH]

    MAIN <--> WEBSERVICE
    WEBSERVICE <-->  DATA_COLLECTORS
    DATA_COLLECTORS --> BARCODE_LABEL_PRINTERS

Components

  • FrontEnd and API (Yii)

    • Developed in PHP using Yii
    • Multi user application
    • API for connecting easily to other systems
    • Custom ConJob administrator allows running import / export / cleanup processes.
    • View API
    • Product page View product page

  • PlayStore Android App

    • We currently do strategic distribution: Managed via a private repository to address specific dependency constraints and ensure compatibility with legacy data collection hardware.
    • Modern Kotlin Development: Leveraged Kotlin to build a robust, performant mobile application.
    • Offline-First Architecture: Designed as a standalone application capable of full functionality without a network connection, enabling audits in high-security or zero-coverage areas.
    • Continuous Integration & Deployment (CI/CD): Implemented automated pipelines for web builds.
    • View Playstore

  • Windows CE App (Deprecated)

    • Developed for Windows CE and Windows Embedded Handheld (WEH) environments.
    • Lifecycle Management: Currently in the maintenance phase of its lifecycle, providing critical support until the transition to updated customer hardware is complete.
    • Offline-First Architecture: Designed as a standalone application capable of full functionality without a network connection, enabling audits in high-security or zero-coverage areas.

Web app Web app

Android app Android app Android app Android app Android app