Inventory Management System - Python + Streamlit IMPORTANT: This is a PYTHON application, NOT PHP/MySQL. Requires Python 3.9+ installed. TECHNOLOGY STACK • Python 3.9+ (Required)• Streamlit web framework• SQLite database (built-in, no MySQL needed)• Pandas, ReportLab, OpenPyXL libraries KEY FEATURES Product Management• Complete CRUD operations (Create, Read, Update, Delete)• Product images with thumbnail display• SKU, model, and rack number tracking• Production and expiry date management• Distributor and selling price tracking• Custom low stock alert thresholds per product• Category and warehouse assignment• Supplier linking• Export to Excel, PDF, and printable HTML• Advanced search and pagination (8 items per page)• Inline editing with save/cancel Professional Invoice System• Auto-generated invoice numbers (INV-YYYYMMDD-XXX format)• Multiple products per invoice with real-time stock validation• Automatic stock deduction on invoice creation• Discount and payment tracking• Payment status: Paid, Partial, Unpaid• Update payments anytime• Print and export invoices• Invoice history and search Customer Management• Complete customer database (ID, name, phone, email, address)• Payment tracking system• Customer payment history• Filter by paid/unpaid/partial status• Integrated with invoice system Supplier & Warehouse Management• Supplier database with contact details• Multiple warehouse support• Rack number tracking for precise location• Easy assignment to products Real-Time Dashboard• Total sales count (products sold)• Revenue and receivables tracking• Total products, invoices, customers, suppliers• Stock levels overview• Recent invoices list• Key metrics at a glance Smart Notification System• Facebook-style notification bell in header• Live badge count for alerts• Low stock alerts (yellow indicators)• Expired products alerts (red indicators)• Preview first 5 items with "view all" option• Click to navigate to detailed views Stock Monitoring• Low Stock Alerts: Products below threshold with visual indicators• Dead Stock Tracking: Products with no sales (configurable days)• Expired Products: Items past expiration date• Comprehensive stock reports ‍ Staff Management• Employee records (name, role, salary, age)• Contact information (phone, email)• Start date tracking• Full CRUD operations Comprehensive Settings• Store name and logo customization• 30+ international currencies support• Currency symbol position and decimal places• Default low stock alert thresholds• About page with commercial information Modern UI/UX• Professional dark theme• Responsive layout• Interactive cards with hover effects• Clean, intuitive navigation• Collapsible sidebar with organized menus• Consistent design across all pages SYSTEM REQUIREMENTS • Python 3.9, 3.10, 3.11, or 3.12• pip package manager• 50MB free disk space• Works on Windows, macOS, Linux• No web server required (Apache/Nginx NOT needed)• No MySQL server required (uses SQLite) EASY INSTALLATION (3 Steps) 1. pip install -r requirements.txt2. streamlit run app.py3. Open http://localhost:8501 The application will start automatically. No complex configuration needed! FILES INCLUDED Complete Python source code (20+ well-organized modules) Comprehensive README.md (installation, setup, troubleshooting) requirements.txt with all dependencies Fully commented code with docstrings SQLite database schema (auto-created on first run) Custom CSS styling Professional UI components Logging system for debugging Export utilities (Excel, PDF, HTML) Pagination helpers Error handling throughout Project Structure:• app.py - Main application entry point• config.py - Centralized configuration• db.py - Database initialization• models.py - Data models• pages/ - UI pages (dashboard, products, invoices, etc.)• services/ - Business logic layer• ui/ - Theme and reusable components• utils/ - Helper functions (export, pagination, logging) DOCUMENTATION Professional README.md with:• Detailed installation guide (Windows/macOS/Linux)• Complete feature list• Project structure explanation• Configuration and customization guide• Troubleshooting section with solutions• Database schema details• Security considerations Code Documentation:• Module-level docstrings explaining file purpose• Function docstrings for all public functions• Inline comments for complex logic• Clear variable names PERFECT FOR • Small to medium businesses• Retail stores• Warehouses and storage facilities• Inventory tracking• Sales and invoice management• Stock level monitoring• Supplier and customer management CUSTOMIZATION OPTIONS • Easy theme color changes (modify ui/theme.py)• Add new currencies (simple list in services/settings_service.py)• Adjust page size (change PAGE_SIZE in config.py)• Modify low stock thresholds (config.py)• All configuration centralized in config.py SUPPORT INCLUDED First 3 months: Free support, bug fixes, technical assistance Contact via Telegram: @N7_miracle Contact via WhatsApp: +201012469699 Extended Support Plans Available:• 6 months total: $15• 12 months total: $26• Each additional 3 months: $12 Updates & New Features Access:• 6 months: $19• 12 months: $33• 18 months: $49 Custom Feature Development:• Simple features: $19• Medium complexity: $34• Complex features: $50+ WHAT YOU GET Complete, working application Clean, professional code Well-documented and commented Easy to install and run Ready for immediate use Customizable and extensible Regular updates (with support plan) IMPORTANT NOTES • This is a Python application, NOT PHP• Requires Python 3.9+ installed on your system• No web hosting needed - runs locally• Database is SQLite (file-based), not MySQL• Basic Python knowledge recommended for customization• Detailed README guides you through everything DATABASE SCHEMA Built-in SQLite database with tables:• products (16 fields including images, prices, dates)• categories (id, name)• warehouses (id, name, rack_number)• suppliers (contact info, address)• customers (contact info, payment status)• customer_payments (payment history)• invoices (invoice details, payment tracking)• invoice_items (products per invoice)• staff (employee records)• settings (app configuration) All tables auto-created on first run. No manual database setup required! LICENSE Commercial license - Install on unlimited local machines for your business.Cannot redistribute or resell source code.

Product Management:
• Add, edit, delete, search products
• Image upload & display
• SKU, model, rack tracking
• Production & expiry dates
• Low stock alerts per product
• Category & warehouse assignment
• Supplier linking
• Export to Excel/PDF/HTML

Invoice System:
• Auto-generated invoice numbers
• Multiple products per invoice
• Real-time stock validation
• Payment tracking (paid/unpaid/partial)
• Discount support
• Print & export invoices
• Invoice history

Customer & Supplier:
• Complete contact database
• Payment history tracking
• Status filtering
• Easy management interface

Dashboard & Alerts:
• Real-time metrics & statistics
• Smart notification bell
• Low stock & expiry alerts
• Recent invoices list
• Sales & revenue tracking

Additional Features:
• Multiple warehouses
• Staff management
• 30+ currencies
• Custom branding
• Modern dark theme
• Cross-platform
• Easy installation
• 3 months support

 Python 3.9+ required

Web Framework
streamlit>=1.25.0,<2.0.0

 Data Processing
pandas>=1.5.0,<3.0.0

Export Features
openpyxl>=3.1.0          # Excel export
reportlab>=3.6.0         # PDF export

 Image Processing
Pillow>=9.0.0

 Optional: Environment Variables (uncomment if using .env file)
 python-dotenv>=1.0.0

1. Extract the downloaded ZIP file to any folder on your computer

1. Run Setup - Double-click setup.bat to install all dependencies

•  will>

• Wait until you see "Installation Complete!"

1. Run Application - Double-click run.bat to start the application

• Your browser will automatically open at http://localhost:8501

• If not, manually open your browser and go to: http://localhost:8501

1. Optional - Run generate_sample_data.py to create demo data for testing