Inventory Management System using SQL

Overview

This project is an Inventory Management System built using PHP and MariaDB. The system allows users to manage inventory items, track purchases, record sales, and manage user accounts.

Features

• Inventory Management: Add, edit, and delete inventory items with details like brand, model, category, quantity, base price, and GST.
• Purchase Tracking: Record purchases made from distributors with details like invoice number, date, product ID, distributor name, quantity, and total price.
• Sales Tracking: Record sales transactions with details like invoice number, date, customer name, product ID, quantity, and MRP.
• User Management: Manage user accounts with details like name, position, phone, email, and password.

Database Structure

The database schema consists of four tables:

1. inventory: Stores information about inventory items.
2. purchase: Stores information about purchase transactions.
3. sales: Stores information about sales transactions.
4. users: Stores information about user accounts.

Installation

1. Clone the Repository: Clone this repository to your local machine using the following command:

   git clone https://github.com/Eman-69/Inventory-Management-and-Invoice-System.git
   

2. Import Database: Import the provided SQL dump (electra.sql) into your MariaDB database using phpMyAdmin or any other database management tool.
3. Configure Database: Update the database configuration settings in the config.php file with your database credentials.
4. Run the Application: Start the PHP development server and navigate to the project directory to run the application.

Usage

• Login: Use the provided user credentials to log in to the system.
• Dashboard: Login/Log out or perform sales or purchase functions.
• Manage Inventory: Add, edit, or delete inventory items.
• Record Purchases: Record new purchases made from distributors.
• Record Sales: Record sales transactions to customers.
• Manage Users: Add, edit, or delete user accounts.