Skip to content

sukhmani1303/Billing-and-Business-Management

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This is my project for First Year CSE

Billing and Business Management

image

Introduction

We aim to provide intel to the business owner for making proper business decisions to facilitate a better revenue stream along with an adequate record for the same.


Approach

  • To capture data through bill generation & user inventory.

  • Using this data to analyze sales, revenue, profit and overall business

  • Indicate this to User using certain Key Pointers


Dependencies

  • Python3 must be installed
  • MySQL must be installed and setup
  • The device must have a Camera (for barcode scanning)

Python Libraries

alt text

Inside the terminal (with admin. permissions) enter the following

pip install -r requirements.txt

Features

  • Generate Bill & Email to Customer
  • Scan Barcode with Camera
  • Add products to inventory
  • View, Update & Delete Products
  • View Product Statistics
  • View Business Analysis
  • Daily update of revenue & profit

Benefits

  • Provides Business Vision
  • Helps increase profitability
  • The software helps identify trends
  • Helps in tracking progress
  • Increases Efficiency
  • Reducing carbon footprint
  • Automation for Accounting & Inventory Management

Analysis

  • Generate offers for specific products & days
  • Understanding consumer behaviour
  • Understanding Foot traffic
  • Analyze inventory of items
  • To make the best use of shelf space
  • To get a clear overview of the entire business

SETUP DATABASE

  1. Download & Install Xampp in the default directory

  2. Open Xampp and Start the following Services

    • Apache
    • MySQL

    image
  3. Open any Browser & go to http://localhost/phpmyadmin/

  4. Create a new Database and name it pbl

  5. Select pbl & Import the file import_me.sql


ER Diagram

alt text


Flow of Certain Functions

  • Add Products

image


  • Update/ Delete Products

image


  • Barcode Scanning

image


  • Bill Generation

image


MEET THE TEAM

image