Book Shop Management System using Python Django and MySQL

Abstract

 We have developed Book Shop Management System using Python Django and MySQL. The main modules available in this project are Stocks module which manages the functionality of Stocks, Receipts is normally used for managing Receipts, Publications contains all the functionality related to Publications, Sales manages the Sales functionality, Inventory has all the features of Inventory and Books module manages the functionality of Books.

As we know Python Projects, are trending topics for academic python project development. So we had choosen python3 for developing Book Shop Management System. In this project we developed features for Stocks, Receipts, Inventory etc, which reduces the human efforts and increase the efficiency.

Report of Book Shop Management System

  • Stocks report : We can generate all the reports of Stocks in this
  • Receipts report : Generate reports related to Receipts
  • Publications report : All Publications reports will be available in this section
  • Sales report : You can generate filtered reports of Sales
  • You can generates the report of Sales, Stocks, Inventory
  • Receipts, Books, Publications has facility for dynamic search. So you can filter the records run time
  • PDF reporting has been integrated for exporting of the report for Stocks, Receipts, Publications modules
  • You can create the CSV reports for Stocks, Sales, Receipts

Modules of Book Shop Management System:

  • Stocks module : It contains all the functionalities related to the Stocks
  • Receipts module : It manages all the operations related to Receipts
  • Publications module : Manages the Publications related functionalities
  • Sales module : This module manages Sales functionalities
  • Inventory module : Inventory modules contains all the CRUD operations related to Inventory
  • Books module : Books module contains all the required functions which include adding, viewing, deleting and updating Books lists.

Book Shop Management System in python Installation Steps:

  • Download Book Shop Management System zip file and extract it
  • Install Django
  • Open phpmyadmin and create Book Shop Management System database
  • Import database Book Shop Management System.sql
  • Run the project : python manage.py runserver
  • Open Your browser run the project : “http://localhost:8080/BookShop Management System/”

Python Project Book Shop Management System software requirments specification:

  • Python3 : To run this project you need python 3
  • Django : We have developed this project over the django2
  • MySQL : You need mysql database for running this project
  • MySQL Connector : For making the connection from mysql and python, we need it