This is my project for First Year CSE

Billing and Business Management

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

• How to Install the requirements ?

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
     

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

Flow of Certain Functions

• Add Products

• Update/ Delete Products

• Barcode Scanning

• Bill Generation

MEET THE TEAM