Kareem pharmacy system
- Pharmacy Tracking System: A comprehensive software solution replacing paper records for a small family pharmacy
- Problem Statement and User Analysis: Identifying current paper-based bottlenecks and defining system stakeholders
- Current Paper Record Limitations: Manual logs lead to lost inventory records and missed stockouts
- High Risk of Human Error: Handwritten entries frequently cause misread dosages or quantities
- Slow Audit Times: Locating specific batch numbers requires manually flipping through thick binders
- Untracked Waste: Expired medications often sit unnoticed until discovered during physical counts
- Primary Pharmacy Staff Users: Daily operators who need intuitive interfaces to minimize training time
- Lead Pharmacist: Requires full access to system administration and procurement reports
- Pharmacy Assistants: Need fast lookup tools for dispensing medications to customers
- Inventory Manager: Focuses on stock replenishment and tracking near-expiry items
- Core Inventory and Expiry Management: Automated tracking mechanisms for stock levels and expiration dates
- Real-Time Stock Level Tracking: Maintaining accurate counts as medications are received and dispensed
- Stock Inflow Logging: Recording supplier deliveries and initial batch quantities accurately
- Dispensing Decrements: Automatically reducing inventory when a prescription is fulfilled
- Low Stock Thresholds: Triggering automated reorder flags when items dip below safety limits
- Automated Expiry Date Alerts: Proactive notifications to prevent dispensing expired drugs
- Ninety-Day Warning: Flagging batches approaching three months before expiration
- Critical Thirty-Day Alert: High-priority dashboard prompts for items expiring within a month
- Removal Workflow: Guiding staff to isolate and dispose of expired stock safely
- Reporting and Audit Logs: Generating historical summaries for regulatory compliance and reviews
- Daily Dispensing Summary: Compiling total medications sold and revenue generated
- Waste Audit Reports: Tracking financial losses due to expired or damaged items
- Export Capabilities: Allowing data export to spreadsheet formats for external analysis
- Barcode Scanning and Data Architecture: Hardware integration and relational database design for fast data retrieval
- Barcode Scanning Integration: Enabling rapid item identification using standard optical scanners
- USB Scanner Compatibility: Connecting plug-and-play hardware directly to terminal devices
- Camera-Based Scanning: Utilizing mobile device cameras as an alternative input method
- Instant Lookup Trigger: Automatically querying the database upon successful barcode read
- Relational Database Schema: Structuring tables to maintain data integrity across operations
- Medicines Table: Storing core product details like generic name and dosage form
- Batches Table: Tracking specific lot numbers and exact expiration dates
- Transactions Table: Recording every stock movement with timestamps and user IDs
- Data Validation and Integrity: Ensuring consistent input quality across all database fields
- Unique Constraint Enforcement: Preventing duplicate barcode entries in the product catalog
- Foreign Key Relationships: Linking batch records strictly to valid medicine entries
- Transactional Atomicity: Using database commits to prevent partial or corrupted writes
- Technology Stack and Development Phase: Selecting robust tools and planning a three-week build schedule
- Software Stack Selection: Choosing lightweight and reliable technologies suitable for local hosting
- Frontend Framework: Utilizing React for a responsive and modern user interface
- Backend Runtime: Implementing Node.js and Express for fast API processing
- Database Engine: Deploying SQLite for zero-configuration local data storage
- Week One Development Goals: Establishing core database models and basic user authentication
- Database Setup: Creating tables and establishing relational integrity constraints
- Basic CRUD Interfaces: Building screens to add, view, and update medicine records
- User Roles: Implementing simple role-based access for staff security
- Weeks Two and Three Milestones: Integrating scanning hardware and finalizing the notification engine
- Scanner Event Handlers: Connecting barcode input streams to search endpoints
- Expiry Alert Logic: Developing background checks for upcoming expiration dates
- System Testing: Conducting end-to-end verification of all inventory workflows
- Deployment and Pharmacy Integration: Transitioning the physical pharmacy from paper ledgers to software
- Hardware Setup on Site: Configuring physical workstations within the pharmacy counter space
- Data Migration and Inventory Entry: Converting existing paper ledgers into the new digital database
- Physical Stock Audit: Conducting a complete manual count of current pharmacy stock
- Initial Data Entry: Inputting current stock quantities and batch expiration dates
- Verification Check: Comparing digital counts against physical shelves before launch
- Staff Training and Go-Live: Ensuring smooth adoption of the digital system by pharmacy staff
- Hands-On Workshop: Demonstrating daily workflows like scanning and dispensing
- Parallel Run Period: Maintaining paper logs alongside software for one transition week
- Full Cutover: Completely retiring paper ledgers and relying entirely on the app
- Budget Constraints: Building a cost-effective solution utilizing open-source tools
- Project Objectives and Scope: Establishing measurable goals for the graduation project implementation
- Zero Paper Dependency: Transitioning all stock logs into a centralized digital database
- Sub-Second Lookup: Ensuring item searches complete instantly during busy customer hours
- Terminal Placement: Positioning desktop computers near dispensing counters
- Peripheral Connection: Testing barcode scanners and receipt printers for reliability
- Local Network Setup: Ensuring stable offline-first connectivity within the shop