← All Projects Inventory & Logistics

Crate Track

Web-based factory inventory tracking for crate and item movement via salesmen in the field.

Flask · SQLite · ReportLab Web + Android Barcode Scanning

Overview

Crate Track is a complete inventory management system built for manufacturing units that track crate and item movement between factory, salesmen, and customers. It provides real-time stock visibility at three levels — company warehouse, salesman, and customer — with mobile-friendly interfaces for field staff and thermal PDF slips for transactions.

Key Features

  • Multi-level stock tracking: Company → Salesman → Customer
  • Material in/out, item issue, and stock return workflows
  • 2-inch thermal PDF transfer slips for stock movements
  • Barcode scanning via phone camera on items and transactions
  • Role-based access: Administrator, Store Incharge, Salesman
  • Mobile-optimised UI for salesmen with bottom navigation
  • Excel export on stock reports
  • GPS location capture on field transactions
  • Customer groups for filtered salesman workflows
  • Packaged as Windows EXE for easy deployment

Screenshots

Crate Track stock dashboard with charts
Stock Dashboard
Crate Track salesman mobile stock out screen
Salesman Mobile View

Transaction Flows

Material InExternal → Company
Item IssueCompany → Salesman
Stock OutSalesman → Customer
Stock InCustomer → Salesman
Material ReturnSalesman → Company