Jewellery Shop Management System Project
A Jewellery Shop Management System in PHP and MySQL for gold and silver stock, daily rates, billing and customer orders.
- PHP
- CodeIgniter
- MySQL
- Remote setup included
See the project running first, then pay.
What is the Jewellery Shop Management System?
The Jewellery Shop Management System is a web application that helps a jewellery retailer manage its inventory, sales, customers, and billing with the precision the trade demands. It records each item with details such as metal type, weight, purity, making charges, and stone value, and calculates accurate prices that reflect current rates. When a sale is made, the system generates an itemised invoice, updates stock, and records the customer, giving the shop a clean transaction history and reducing manual pricing errors. Administrators manage product categories, rates, customers, and staff from a central dashboard, while reports reveal best-selling items, daily sales, and stock valuation.
Built with PHP and the CodeIgniter framework over a MySQL database, this mini project uses an MVC architecture that keeps pricing logic, data, and presentation neatly separated and easy to extend. Role-based logins distinguish administrators, salespeople, and managers, keeping pricing and inventory controls secure. By handling weight and rate-based pricing, the project demonstrates business logic that goes beyond simple fixed prices. Detailed reports support better purchasing and pricing decisions.
Complete source code and documentation are included, letting students study how specialised pricing and inventory interact in a real retail context. This project suits learners who want a focused example of detailed billing and stock management.
Key Features
Main things you can do with the Jewellery Shop Management System.
- Item stock with weight, purity and design
- Daily gold and silver rate update
- Bill with making charges and GST
- Old gold exchange
- Custom order tracking
- Customer records
- Karigar (craftsman) work tracking
- Stock and sales reports
Project Modules
The project is divided into these modules. Each one has its own screens and tasks.
1Admin
- Manage staff
- Update metal rates
- Manage categories
- View reports
2Stock
- Add items with weight and purity
- Tag and barcode items
- Track sold items
- Stock audit
3Billing
- Create bills
- Add making charges
- Handle old gold exchange
- Print invoices
4Orders
- Take custom orders
- Assign karigar
- Track progress
- Deliver orders
What You Get
Everything you need to submit, run and explain the project.
Complete Source Code
Full, working source code with clean folder structure and helpful comments. No locked or hidden files.
Database File
Ready-to-use MySQL database with tables and sample data, so the project runs on day one.
Project Documentation
Full project report in Word and PDF: abstract, SRS, ER diagram, DFD (level 0, 1, 2), use case and class diagrams, screenshots, testing and conclusion.
PPT Presentation
A 15–20 slide presentation for your seminar, review or final viva. Easy to edit with your name and college.
Remote Project Setup
We connect to your laptop with AnyDesk or Google Meet, install everything and run the project for you.
Project Explanation
A simple walkthrough of the code and flow, plus common viva questions, so you can explain it with confidence.
Project Documentation includes
- Certificate, acknowledgement and abstract
- Introduction, problem statement and objectives
- Existing system vs proposed system
- Software Requirement Specification (SRS)
- System design: ER diagram, DFD (level 0, 1, 2), use case and class diagrams
- Module description and screenshots
- Testing and test cases
- Conclusion, future scope and references
PPT Presentation slides
- Title and team details
- Introduction and problem statement
- Objectives
- Existing vs proposed system
- System architecture
- Modules
- Technology used
- Screenshots / demo
- Advantages and future scope
- Conclusion
Tech Stack
| Part | Technology | Used for |
|---|---|---|
| Frontend | HTML5, CSS3, Bootstrap 5, JavaScript | Clean and mobile-friendly screens |
| Backend | PHP (CodeIgniter) | Business logic, login and validations |
| Database | MySQL | Stores users, records and reports |
| Server | Apache (XAMPP / WAMP) | Runs the project on your laptop |
Software and hardware requirements
- Windows 10/11, macOS or Linux laptop with 4 GB RAM or more
- XAMPP or WAMP (PHP 7.4 / 8.x, Apache, MySQL)
- Any modern browser: Chrome, Edge or Firefox
- VS Code or any code editor (to read and edit code)
How the Jewellery Shop Management System Works
Login
Admin and users log in with their own account and role.
Daily work
Users add, search, update and view records from simple forms.
Save data
Every action is checked and saved safely in the MySQL database.
Reports
Admin sees dashboards and prints or downloads reports.
Remote Project Setup Guidance
Not sure how to run it? We set up the project on your laptop over AnyDesk or Google Meet. No need to visit us.
-
1
Share your detailsTell us your laptop type (Windows / Mac) and a time that suits you.
-
2
Install AnyDeskInstall free AnyDesk (or join Google Meet) and share the access code.
-
3
We set it upWe install the required software, import the database and configure the web application.
-
4
Test togetherWe run the project in front of you and check every main feature.
-
5
Understand itWe explain the code, flow and database so you are ready for your viva.
- Install XAMPP and start Apache and MySQL from the XAMPP control panel.
- Copy the project folder into
C:\xampp\htdocs\(orhtdocson Mac). - Open
localhost/phpmyadmin, create a new database and import the.sqlfile we provide. - Open the database config file and enter your database name, username and password.
- Open
localhost/project-folderin your browser and log in with the admin details given in the documentation.
Jewellery Shop Management System Images
What You Will Learn
Frequently Asked Questions
Project Details
Available- ProjectJewellery Shop Management System
- TypeMini Project
- CategoryManagement System
- LanguagePHP
- FrameworkCodeIgniter
- DatabaseMySQL
- DocumentationReport + PPT
- SetupRemote help
- DeliverySource Code + Documentation
