Megabre Creative Solutions...

Overview

StokMaster Pro is a comprehensive stock management and business management system based on PHP and MySQL. The system is designed to meet the inventory tracking, order management, customer relations, financial transactions and reporting needs of small and medium-sized businesses.

Developer

Megabre Team

Version

1.0.0

License

Proprietary (Commercial)

Technical Architecture

Technology Stack

  • Backend: PHP 8.3+
  • Veritabanı: MySQL 8.4+ (InnoDB Engine)
  • Frontend: HTML5, CSS3, JavaScript (jQuery)
  • Framework: Bootstrap 5
  • Kütüphaneler: Chart.js, DataTables, Select2, Font Awesome

Architecture

  • MVC Benzeri Modüler Yapı
  • Singleton Pattern (Database, Cache, Authentication)
  • PDO ile Güvenli Sorgular
  • Dosya Tabanlı Önbellekleme
  • Özel Session Yönetimi

Modules and Features

Dashboard (Home Page)

Statistics Cards
  • Today's receivables
  • Today's debts
  • Low stock (less than 10)
  • Pending orders
Charts
  • Monthly payments and debts (6 months)
  • Order statuses (pie chart)
  • Product categories (bar chart)
Installment Notifications
  • Installments due today
  • Upcoming installments (within 7 days)

Product Management

Product List
  • Advanced table with DataTables
  • Pagination, sorting, search
  • Column filtering
  • Bulk delete
Product Features
  • SKU and barcode support
  • Product image upload
  • Minimum stock level
  • Category-based dynamic fields
  • Currency and price unit support

Stock Management

Stock Movements
  • Stock entry (in)
  • Stock exit (out)
  • Stock adjustment
Stock Tracking
  • Real-time stock level
  • Product-based stock history
  • Stock movement reports
  • Unit support (piece, kg, lt, m, m², m³, package, box, pallet)

Order Management

Order Creation
  • Customer selection
  • Product addition (dynamic form)
  • Automatic total calculation
  • Add/remove VAT
  • Automatic stock reduction
Discount System
  • Percentage-based discount
  • Fixed amount discount
  • Customer tag-based automatic discount
Order Statuses
  • Pending
  • Processing
  • Completed
  • Cancelled

Customer Management

Customer Information
  • Personal information (name, surname, phone, email)
  • Company information
  • Address and notes
  • Dynamic fields
Tag System
  • Colored tags
  • Automatic discount percentage
  • VIP, Special Customer, Standard, etc.
  • Multiple tag support

Financial Transactions

Payment Methods
  • Cash
  • Check
  • Promissory Note
  • Credit Card
  • Wire Transfer/EFT
Installment System
  • Set installment count
  • Automatic installment creation
  • Installment payment tracking
  • Due date tracking
  • Installment notifications

Reporting

Sales Reports
  • Daily sales chart
  • Category-based sales
  • Top selling products
  • Top shopping customers
Inventory Reports
  • Stock summary
  • Category-based stock value
  • Critical stock products
  • Out of stock products
Financial Reports
  • Financial summary
  • Daily financial status
  • Payment method-based reports
  • Customer balances

Database Optimization Module

What is it?

Database Optimization Module is a tool that optimizes your MySQL/MariaDB tables to improve performance. It reduces fragmentation (fragmentation) that occurs over time in tables containing thousands of records and improves query speed.

What does it do?
  • Reduces fragmentation: Cleans up spaces created after delete and update operations, reduces table size
  • Improves query performance: Updates table statistics to enable MySQL to create faster query plans
  • Optimizes disk usage: Reduces database size by cleaning up unnecessary empty spaces
  • Increases system speed: Provides noticeable speed improvement especially in systems with thousands of products, customers and order records
When to use?
  • When the system slows down
  • When fragmentation is more than 10%
  • When many delete/update operations are performed
  • As regular maintenance (monthly/weekly)
Features
  • Optimize all tables with one click
  • Optimize selected tables
  • View table status (record count, size, fragmentation)
  • ANALYZE TABLE: Updates statistics
  • CHECK TABLE: Integrity check
  • REPAIR TABLE: Repairs corrupted tables
  • Cache clearing: Clears table cache
Use Cases
E-commerce

Performance improvement in systems with thousands of products and order records

Stock management

Speed improvement in systems with many stock movements

CRM

Optimization in systems with many customer and transaction records

General use

Maintaining system performance with regular maintenance

Technical Details

The module uses MySQL's OPTIMIZE TABLE, ANALYZE TABLE, CHECK TABLE and REPAIR TABLE commands. All operations are performed safely and results are reported in detail. Requires admin privileges.

Special Features

Multi-Language Support

Turkish and English language support. User-based language preference and dynamic language switching.

Multi-Currency

TRY, USD, EUR, GBP and custom units (M3, etc.) support. Currency conversion rates.

Measurement Unit Support

Support for piece, kg, gram, lt, meter, square meter, cubic meter, package, box, pallet.

Dynamic Field System

Category-based custom fields. Text, number, selection, textarea, date field types.

Security

Bcrypt password hashing, CSRF protection, XSS protection, SQL injection protection, role-based authorization.

Backup System

Full backup, structure backup, data backup. Automatic and manual backup. Backup restore.

System Requirements

Server Requirements

  • PHP 8.3 or higher
  • MySQL 8.4 or higher
  • Apache/Nginx web server
  • mod_rewrite support
  • GD/ImageMagick (image processing)
  • PDO MySQL extension
  • JSON extension
  • mbstring extension

Browser Support

  • Chrome (last 2 versions)
  • Firefox (last 2 versions)
  • Safari (last 2 versions)
  • Edge (last 2 versions)
Try StokMaster Pro Now!
Your professional stock management system is just one click away