--- title: "ReelManager Electronics Component Inventory Manager" canonical: https://hamzadenizyilmaz.com.tr/projeler/reelmanager-electronics-inventory author: "Hamza Deniz Y\u0131lmaz" created: 2026-07-23T02:34:58.0332956+00:00 published: 2026-07-23T02:34:58.0332956+00:00 --- # ReelManager Electronics Component Inventory Manager ## ReelManager — Electronics Component Inventory Manager ![Version](https://img.shields.io/badge/version-v2.2.0-blue) ![MySQL](https://img.shields.io/badge/Database-MySQL-4479A1) ![Prisma](https://img.shields.io/badge/ORM-Prisma-2D3748) ![Node.js](https://img.shields.io/badge/Node.js-Express-339933) ![Next.js](https://img.shields.io/badge/Next.js-15-black) [![Node.js Version](https://img.shields.io/badge/node-%3E%3D22-brightgreen)](https://nodejs.org) [![License](https://img.shields.io/github/license/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/blob/main/LICENSE) [![Last Commit](https://img.shields.io/github/last-commit/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/commits/main) [![Repo Size](https://img.shields.io/github/repo-size/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager) [![Commit Activity](https://img.shields.io/github/commit-activity/m/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/graphs/commit-activity) [![Top Language](https://img.shields.io/github/languages/top/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager) [![Issues](https://img.shields.io/github/issues/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/issues) [![Pull Requests](https://img.shields.io/github/issues-pr/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/pulls) [![Stars](https://img.shields.io/github/stars/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/stargazers) [![Forks](https://img.shields.io/github/forks/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager)](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/network/members) **ReelManager** is an enterprise-grade web application for managing electronic component stock, SMD reels, BOMs, locations, datasheets, barcode/QR labels, purchase needs and component activity history. The project is designed for electronics labs, R&D teams, PCB prototyping workflows, production shelves, component boxes and personal or professional component inventory management. This repository contains the **v2.2.0 Enterprise** release. The release upgrades the previous **v2.1.0 Enterprise** package with a stronger update center, SQL backup export, improved logs, smaller footer, language settings, corporate page copy, update-safe backup workflow and a more stable UI/UX foundation. > Current release: **v2.2.0 Enterprise** --- ## Repository GitHub repository: ```text https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager ``` --- ## Highlights - Component inventory management for resistors, capacitors, ICs, diodes, inductors, modules and connectors - Category, supplier and storage location management - Stock IN / OUT / RESERVE / RELEASE operations - Full movement history and activity tracking - Project and BOM management - BOM stock availability check - Low stock and out-of-stock views - Datasheet enrichment module - Provider-based component information lookup - QR and barcode scanner page - Browser-based label printing studio - Zebra-compatible ZPL output helper - CSV / XLSX import preview - CSV / XLSX export - Project BOM PDF export - Turkish / English UI support - Dark / light theme support - Responsive SaaS-style dashboard - JWT authentication and frontend route guard - Role-ready user management foundation - Swagger API documentation --- ## Tech Stack ### Frontend - Next.js 15 App Router - JavaScript - Tailwind CSS - Zustand - Axios - Lucide React icons - Recharts - React Hook Form - Zod - html5-qrcode - qrcode.react ### Backend - Node.js - Express.js - Prisma ORM - MySQL - JWT authentication - bcrypt password hashing - Joi validation - Helmet - CORS - express-rate-limit - Swagger UI - PDFKit - Multer - PapaParse - XLSX --- ## Main Screens Recommended screenshots for GitHub: ```text assets/screenshots/login.png assets/screenshots/dashboard.png assets/screenshots/components.png assets/screenshots/component-detail.png assets/screenshots/new-component.png assets/screenshots/projects-bom.png assets/screenshots/labels.png assets/screenshots/settings.png assets/screenshots/swagger.png ``` --- ## Quick Start ### 1. Clone ```bash git clone https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager.git cd ReelManager-Electronics-Component-Inventory-Manager ``` ### 2. Backend setup ```bash cd backend cp .env.example .env npm install npx prisma generate npm run prisma:migrate npm run prisma:seed npm run dev ``` Backend default URL: ```text http://localhost:4000 ``` ### 3. Frontend setup ```bash cd frontend cp .env.example .env npm install npm run dev ``` Frontend default URL: ```text http://localhost:3000 ``` --- ## Default Admin ```text Email: admin@example.com Password: Admin123! ``` Change this account immediately before production use. --- ## Environment Variables ### Backend ` .env ` ```env DATABASE_URL="mysql://root:password@localhost:3306/reelmanager" JWT_SECRET="change_this_secret" JWT_EXPIRES_IN="7d" PORT=4000 FRONTEND_URL="http://localhost:3000" NEXAR_CLIENT_ID="" NEXAR_CLIENT_SECRET="" DIGIKEY_CLIENT_ID="" DIGIKEY_CLIENT_SECRET="" DIGIKEY_REDIRECT_URI="" MOUSER_API_KEY="" DATASHEET_PROVIDER_TIMEOUT_MS="8000" DATASHEET_CACHE_TTL_DAYS="30" ``` For MySQL servers that enforce TLS: ```env DATABASE_URL="mysql://USER:PASSWORD@HOST:3306/ReelManagerDB?sslaccept=accept_invalid_certs" ``` Use a trusted CA certificate for production instead of accepting invalid certificates. ### Frontend ` .env ` ```env NEXT_PUBLIC_API_URL="http://localhost:4000/api" NEXT_PUBLIC_APP_NAME="ReelManager" ``` --- ## Datasheet Enrichment The datasheet enrichment module can search or enrich a component by manufacturer part number or supplier part number. Provider order: 1. Local database 2. Nexar / Octopart API 3. DigiKey API 4. Mouser API 5. Local parser fallback 6. Manual datasheet URL Endpoints: ```text GET /api/datasheets/providers GET /api/datasheets/search?query=RC0402FR-07330RL GET /api/datasheets/enrich?mpn=RC0402FR-07330RL POST /api/components/:id/enrich POST /api/components/bulk-enrich ``` API keys are optional. If a provider key is missing, the provider is skipped safely. --- ## Label Printing ReelManager includes a browser-based label printing studio. Supported profiles include: - Thermal 50 × 25 mm - Thermal 40 × 30 mm - Thermal 58 × 40 mm - Brother DK-11201 29 × 90 mm - DYMO 89 × 36 mm - Mini QR 30 × 20 mm - A4 Sheet 70 × 37 mm Features: - Print only the label area, not the full application page - Choose visible fields: SKU, part number, value, package, quantity, location, manufacturer - Select QR content: SKU, part number or component detail URL - Copy ZPL output for Zebra-compatible printers - Bulk label selection from component search --- ## Security Model Frontend protection: - Middleware-based route protection - Token stored in localStorage and SameSite cookie - Central Axios interceptor - Automatic Authorization header - Session cleanup on 401 - Login redirect on expired session Backend protection: - JWT authentication middleware - Role middleware foundation - Password hashing with bcrypt - Helmet headers - Rate limiting - CORS origin allowlist - Joi request validation - Prisma parameterized queries - Standard API response format Production recommendations: - Use HTTPS - Use strong JWT secret - Rotate secrets periodically - Disable default admin password - Configure secure CORS domains - Use trusted MySQL certificates - Keep API keys in server-side environment only --- ## API Documentation Swagger UI: ```text http://localhost:4000/api/docs ``` Swagger JSON: ```text http://localhost:4000/api/docs.json ``` --- ## CI/CD Included GitHub Actions: ```text .github/workflows/frontend-ci.yml .github/workflows/fullstack-ci.yml ``` The workflows are prepared for: - Dependency installation - Frontend production build - Backend syntax checks - Prisma validation - Node.js 22 --- ## Version History See [` CHANGELOG.md `](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/blob/HEAD/./CHANGELOG.md). Current version: ```text v2.1.0 Enterprise ``` --- ## Documentation Detailed docs are available under [` docs/ `](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/blob/HEAD/./docs): - Architecture - API - Database - Security - Deployment - Development - Datasheet enrichment - Label printing - GitHub release checklist --- ## License GPL-3.0 License. See [` LICENSE `](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager/blob/HEAD/./LICENSE). ## ReelManager Electronics Component Inventory Manager — kaynak ve uygulama notları ### Proje ve belgeyi birlikte değerlendirin Bu kayıt için kaynak açıklama korunmuştur. Kurulum, bağımlılık ve lisans kararlarında bu kayda bağlı proje ve dokümanı birlikte inceleyin; doğrulanmamış sürüm, ölçüm veya özellik bu ekle ilan edilmemiştir. ### Metinde geçen depo bağlantıları - [Depo bağlantısı](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager) - [Depo bağlantısı](https://github.com/hamzadenizyilmaz/ReelManager-Electronics-Component-Inventory-Manager.git) ### İlgili okuma yolu - [ReelManager-Electronics-Component-Inventory-Manager Proje Dokümanı](/dokumanlar/github-reelmanager-electronics-component-inventory-manager) - [Plesk Migration Manager ile Kesintisiz Site Taşıma](/blog/plesk-migration-manager-ile-kesintisiz-site-tasima) - [Proxmox HA Manager, Fencing ve Failover Testi](/blog/proxmox-ha-manager-fencing-ve-failover-testi)