Sales Management System

---

A database management system based project.

📝 Table of Contents

• About
• Features
• Getting Started
• Built Using
• Authors
• Quick Preview

🧐 About

This is an admin based dbms web project developed for the management of the records of product, billing and product sales. It is created with the motive of creating ease for the counter-management side of any seller.

✨ Features

For Registered Users :

• Admin Mode
  • Admin can register new staff.
  • Admin can CREATE, RETRIEVE, UPDATE and DELETE products.
  • Admin can CREATE, RETRIEVE, UPDATE, PRINT and DELETE invoices.

• Staff Mode
  • Staff can CREATE, RETRIEVE, UPDATE and DELETE products.
  • Staff can CREATE, RETRIEVE, UPDATE and PRINT invoices.

For Unregistered users :

• Normal mode:
  • Can only view products list.

🏁 Getting Started

• Clone the repository or download the zip file

• For zip file extract it, then cd into the directory

• Create new virtualenv using python's virtualenv package:

  $ virtualenv venv
  
  $ venv\Scripts\activate (in windows) or $source venv/bin/activate (in Mac OS/linux)
  
  

• Install all dependencies by executing the following command:

  $pip install -r requirements.txt
  

• Connect a MySQL database:

  For development environment:

  
  In **SalesManagementSystem/settings.py** replace the following code snippet according to your mysql database.

  DATABASES = {
  'default': {
      'ENGINE': 'django.db.backends.mysql',
      'NAME': '<databasename>',
      'USER': '<username>',
      'PASSWORD': '<password>',
      'HOST': 'localhost',
      'PORT': '3306',
      }
  }
  

• For running the application simply execute the following commands:

  $python manage.py migrate
  $python manage.py runserver
  

• If you want to populate database with dummy data as shown in preview:

  $python manage.py loaddata sms.json
  

• For login you can use username/password from dummyUsers.txt file assuming you loaded sms.json
  or
  to create new superuser execute:

  $python manage.py createsuperuser
  

• You can now login to the system!

• Now you can use the app by visiting http://127.0.0.1:8000/

⛏️ Built Using

• TailwindCSS - CSS Framework

• Undraw.co - Open Source Illustrations

• Django - Web Framework

  Note : In this project, Django's builtin database-abstraction API is not used . All the create, insert, retrieve, update and delete operations of objects are done through embedded raw SQL.

• MySQL - Relational Database

✍️ Authors

• @MishanKhatri

👀 Quick Preview

• Homepage

• Login

• Products-list

• Create Invoice

• Add Items to Invoice

• Print Invoice as Pdf

• Dashboard For Admin

• Dashboard For Staff

• Update Profile

• Add product to Database

• Delete product from Database

• Register New Staff (admin only view)

• Sales Admin View

• Staff Sales View

• Particular Invoice Details

• Deletion of Invoice (admin only)