A private full-stack business application built for internal retail and wholesale operations at Panmed.
This repository is a public case study only. The production source code, databases, supplier data, inventory records, API credentials, and business-sensitive information are not included for privacy and security reasons.
Panmed is an internal retail and wholesale software platform designed to support product management, inventory tracking, sales analysis, purchase planning, reorder recommendations, and inter-store stock transfer decisions.
The application was independently designed and developed as a full-stack project, including the mobile frontend, backend APIs, database structure, data-processing workflows, business logic, and operational tooling.
Role: Sole Developer / Full-Stack Developer
Responsibilities included:
- System architecture and technical planning
- Flutter/Dart mobile application development
- Node.js/Express.js REST API development
- SQLite database design and data modeling
- Inventory, reorder, and stock transfer business logic
- Historical sales and purchase data processing
- Authentication, user roles, and admin functionality
- Testing, deployment scripts, backup/restore workflows, and documentation
The business needed a more efficient way to manage products, stock levels, sales history, purchase planning, and internal stock movement between retail locations.
Before this system, many operational decisions required manual checking of product data, stock quantities, purchase history, suppliers, and sales trends.
The goal was to build a practical internal application that helps users make faster and better inventory and purchasing decisions.
The system provides a mobile-first interface connected to a backend API and SQLite-based data storage.
Main capabilities include:
- Product search and barcode-based workflows
- Product details with current stock information
- Inventory tracking across retail locations
- Minimum stock settings
- Historical sales analysis
- Reorder recommendation logic
- Purchase order draft support
- Inter-store transfer suggestions
- Category-based product navigation
- Expiry alerts and product correction workflows
- Admin users, roles, audit logging, and device registration
- Reporting-ready data structures for future Power BI integration
The application allows users to search products, view product details, check stock levels, update minimum quantities, and navigate products by category.
The system analyzes historical sales, current stock, minimum stock rules, supplier parameters, and product data to support purchase planning and reorder decisions.
The application suggests stock transfers between two retail stores based on sales trends, current stock levels, minimum stock requirements, and available inventory.
Historical sales and purchase data are processed into structured summaries that can be used for business reporting and future Power BI dashboards.
The system includes authentication, role-based access, admin user management, audit logging, device registration, and operational safeguards.
- Frontend: Flutter, Dart
- Backend: Node.js, Express.js
- Database: SQLite
- APIs: REST APIs
- Data Processing: JavaScript scripts, Python scripts
- Tools: Git, deployment scripts, backup/restore scripts
- Reporting: Reporting-ready data structures, Power BI integration in progress
flowchart LR
A[Flutter Mobile App] --> B[REST API - Node.js / Express.js]
B --> C[SQLite App Database]
B --> D[SQLite Business Data Snapshot]
E[Legacy Business Data Sources] --> F[Import & Processing Scripts]
F --> C
F --> D
C --> G[Inventory, Orders, Transfers, Users]
D --> H[Sales History, Product Data, Purchase Data]
G --> I[Reporting-Ready Data]
H --> I
This repository does not contain:
- Production source code
- Production databases
- Supplier data
- Real inventory records
- Real sales data
- API keys or credentials
- Internal network details
- Business-sensitive information
Screenshots are anonymized where necessary.
The project is actively developed and used as an internal business software platform. Additional reporting and Power BI dashboard integration are planned as part of the ongoing development.