Back to case studies

Apps & APIs

Pegasus Scanner — Inventory Scanning & Cycle Count App

Inventory scanning and cycle-count application that turns scanner input, BIN-based counts, receiver checks, and export-ready audit records into a controlled warehouse workflow.

FastAPIHTML / JSAzure SQLBarcodeDetectorCSVInventory ScanningCycle CountsAudit Exports

Scanner workflow command view

Pegasus Scanner Cycle Count App

Scan input, BIN counts, receiver checks, validation, and audit exports

warehouse-ready

Scan Modes

3

manual / wedge / camera

Cycle Counts

BIN

location workflow

Receiver

Track

remaining qty

Exports

CSV

audit output

Scan panel

Active scan

200-00456

Manual entry
Wedge scanner
Camera scan

Cycle count review

CSV export
PartBINExpectedCountedStatus
100-00123A-142424Matched
200-00456B-021816Variance
300-00789C-094242Matched
400-00112D-1187Review

Inventory workflow

ScanMatchCountValidateExport
Scanner Input
Manual / wedge / camera
Cycle Count
BIN-based workflow
CSV Exports
Audit-ready outputs

Business problem

Cycle counts and receiver checks needed a more controlled workflow. Manual notes, loose spreadsheets, and disconnected count activity made it harder to validate inventory, review variances, and keep a clean audit trail.

The process needed a scanner-friendly app that could support part lookup, BIN-based counts, receiver tracking, finalization, and export-ready records.

System built

Built a FastAPI-backed inventory scanning application with manual entry, hardware wedge scanner support, camera scanning, Azure SQL inventory lookup, cycle-count finalization, receiver tracking, and CSV exports.

The system turns warehouse scanning activity into a structured operational workflow that can be validated, reviewed, and exported.

Scan signals

Signals reviewed

The app evaluates scanner input, inventory context, quantity data, and finalization status before producing review-ready outputs.

Part number scan
Barcode input
BIN location
On-hand quantity
Counted quantity
Quantity variance
Receiver quantity
Remaining receiver quantity
User / session activity
Finalize status
CSV export readiness

Inventory flow

How it works

01

Scan

Capture part activity through manual entry, scanner wedge input, or browser-based camera scanning.

The app supports multiple ways to enter part data so inventory workflows can fit the operating environment.

02

Match

Normalize the scanned value and match it against inventory or receiver records.

Part and barcode normalization help reduce lookup friction and make scanned inputs more useful inside the workflow.

03

Count

Record BIN-based counts, receiver checks, and quantity updates in a structured workflow.

The system turns physical inventory activity into a controlled digital process instead of loose manual notes.

04

Validate

Review remaining quantities, count differences, finalize status, and audit-ready records.

Validation helps users confirm the count or receiver activity before the workflow is finalized.

05

Export

Generate CSV outputs for audit review, reconciliation, downstream reporting, or operational follow-up.

The output layer makes the scanning activity portable and easier to review outside the app.

System layers

What the app coordinates

Scanner interface

Supports manual entry, hardware wedge scanner input, and camera-assisted scanning where browser support is available.

Inventory lookup

Connects scanned values to inventory records, normalized part numbers, BIN data, and quantity context.

Cycle count workflow

Guides users through count entry, review, finalization, and export-ready audit records.

Receiver tracking

Supports receiver scanning and remaining-quantity checks so receiving activity can be monitored more clearly.

Impact signals

What the scanner improved

Scanner-driven inventory workflows

BIN-based cycle counts

Receiver remaining-quantity tracking

Audit-friendly CSV exports

Controlled workflow for count finalization

Operational value

Warehouse work turned into a controlled scan flow

Less manual count handling

Moves cycle counting away from disconnected notes and toward a structured scanning workflow.

Cleaner inventory validation

Gives users a clearer path to compare scanned activity against inventory and receiver records.

Better audit trail

Exports and finalized counts create a more reviewable record of inventory activity.

Warehouse-ready workflow

Supports scanner-friendly input patterns that better fit real inventory and receiving environments.

Why this project matters

A physical inventory workflow converted into a digital control system.

This project shows how warehouse activity can be turned into a more reliable data workflow. Scanner input, BIN-based counts, receiver checks, and export outputs create a clearer bridge between physical inventory work and operational reporting.

The value is not only faster scanning. The value is a more controlled process for validating, finalizing, and auditing inventory activity.

Confidentiality note

Visuals and descriptions are sanitized conceptual representations. They do not expose private company data, customer records, credentials, raw exports, internal pricing, operational screenshots, or proprietary source files.