Online Shop Management System

View With Charts And Images
Online Shop Management System

CHAPTER – 01

INTRODUCTION

Bangladesh is a developing country. Our people try to improve their future. They are always busy for their work. They have no time to go to a market for shopping. So the time and place are very important. Online shopping is the process whereby consumers directly buy goods or services from a seller in real-time over the internet. An online shop or e-shop or virtual store evokes the physical analogy of buying products or services in a shopping mall, which already exists. But in our country most of the people are not familiar with this new system. So we’ll try to develop an Online Shop Management system where payment system by using mobile, that can everybody familiar and take the benefits of online shop.

1.1 AIMS AND OBJECTIVES

The main objective of this project is to develop a Online shop Management System, which are to familiar our people with an online shop or virtual store and the shopping cart system. Our system brings with it a lot of advantages. To remain honest with our topic, we take a brief look at the main objectives are:

· Our system overcomes Geographical barriers by making it possible to shop from virtually from anywhere in our country providing e-commerce shopping platforms.

· Online shopping system which has been developed in Bengali is relatively a quick process that can be carried out from virtually any location with access to the internet. It saves customers a lot of their precious time.

· Our online shopping project is also a hassle free and sometimes even an enjoyable purchasing activity as customers need not walk to stores, carry heavy loads of their purchases back home, nor does it involve communication and burning fuels. And it does some favor to the environment by limiting the emission of toxics with lesser use of retail outlets and avoiding congestion.

· And most of the Bangladeshi will use this site enjoyably because there is easy way to payment by mobile.

The main aim of online shop management system:

· Enable to maintain a large amount of customer information.

· Enable to maintain a huge collection of information

· Quickly view the current status of a customer

· Provide quickly and easy search of any category of products

· Provide easy transaction and sales of product

· Provide quick change of defective product

· Provide accurate account information for product purchase

· Generate automated order receipt

· Provide three layer security

1.2 USED TECHNOLOGY

The automated online shop management system is based on any windows environment. To run the system only need any popular browser.

To do this, following tools and technologies are used.

· HTML

· PHP

· JAVA SCRIPT

· MYSQL

· APACHEE

· XAMPP

· HTTP

· CSS

· JQuery

1.3 ORGANIZATION OF THE THESIS

The Thesis report is organized into five chapters. Each Chapter provides specific information about the total thesis works.

Chapter 01 (Introduction): Description is about the main concept of the project, aims & objectives, Uses technologies of the project.

Chapter 02 (Initial Study): Discuss the problem statements of present system and benefits of the proposed system.

Chapter 03 (Feasibility Study): This chapter is containing feasibility study of our project. First identify the problem of existing system, then finding solution and finally choose the best solution form it.

Chapter 04 (Design): This phase design the whole project such as database design, table design, ERD design etc

Chapter 05 (Implementation): This chapter containing the whole project forms, entry and process implementation.

Chapter 06 (Validation & Testing): This chapter discuss about the validation and testing of the project.

Chapter 07 (Coding): This chapter shortly describes some important main page coding and how it work.

Chapter 08 (Discussion and Conclusion): this chapter describes the discussions of the project and also describes the future plan. In this chapter also describe the reference to build the project.

CHAPTER – 02

INITIAL STUDY

2.1 INVESTIGATIONS

This is the second phase of the system Development Life Cycle. This phase is very important in this phase will get to know the organization behavior for which doing project

Have visited few super shops. Some of them are maintaining manual system, but large super shops are maintaining point of sale (POS) system. Find that every manual system has lacking and problem in their system. In this age of IT, now it is no more possible to maintain manual system in organization moreover s super shop must use POS for quick access of data and for become faster in service. So I’ll like to develop an online system for help those super shops that are not using POS yet.

Initial investigation is the phase, where we will understand what we have to do in this project, we will determine here, what about the project is? What the project need, what is current status of the project and what are the problems with the current system. As I am going to develop a general system, so I will use strategies of several companies and generates a single solution.

2.2 PROBLEM STATEMENT

As a sample when a person wants to buy a book he/ she first have to drive to the books store then walk throughout the store until he/ she locates the book he/ she needs. After finding the product if he/ she want to purchase, he/ she may often need to stand in long queue at cash counter for long time.

Have some problem in the above systems that’s:

· Needs more time to searching a specific products.

· It is so time consuming to get daily sales report

· Some time calculation may wrong

· Need more man power to maintain the whole shop such as purchase and Generating order

· To manipulate the products by category it’s so difficult.

· To generate invoice and store the invoice needs no more place

· Sometimes files may be destroyed by cockroach or by another way

· It is unsecured.

· There is not any strong stock control

· Update product price is an another problem

The online shopping is the best and convenient way for shopping. It helps consumer to avoid the disadvantage of traditional or manual shopping system.

With the help of Online shopping system which has been developed for all people, consumer can buy a variety of items from the online store to see the details and they have multiple chose to payment.

2.3 EVALUATION OF THE SYSTEM

A customer visits the online shopping portal. A customer may buy item or just visit the page and logout. The customer can select a segment, then a category, and brand to get the different products in the desired brand. The customer can select the product for purchasing. The process can be repeated for more items. Once the customer finishes selecting the product/s the cart can be viewed, if the customer wants to edit the final cart it can be done here. For final payment the customer has to login the portal, if the customer is visiting for the 1st time he must register with the site, else the customer must use the login page to proceed. Final cart is submitted for payment and card details and address (where shipment has to be made) are be confirmed by the customer .Customer is confirmed with a shipment Id and delivery of goods within 15 days.

As it is a general system, I will try to design the system in a way that every one can use it frequently. So I choose the common events that all the general people use it and then a graphical presentation of report will generate by the system.

The proposed system will contain three sections:

· Admin Section

· Home

· Products

o View all products

o Add new products

o View all categories

o Add new categories

· Order

· List all Order

· View order box

· Change order status

· Delivery order

· Administration

· View all staff

· View all customer

· Add new staff

· Payment

· View all payment

· Add new payment category

· Delete old category

· Password

· Create password for staff

· Change password

· Logout

· Staff Section

· Home

· Products

· View all products

· Add new products

· View all categories

· Add new categories

· Order

o List all Order

o View order box

o Change order status

o Delivery order

· Change password

· Logout

· Customer section

· Home

· Products

o Category wise products show

o Add products to cart

o Details

· My order

o List all orders

o Make new order

o update order

o delete order

· My cart

o View cart

o Order cart products

· Profile

o Change personal info

o Change password

· logout

CHAPTER – 03

FEASIBILITY STUDY

3.1 OVER VIEW OF THE EXISTING SYSTEM

We can divide our present shopping system in two ways. There are:

• Traditional or manual shopping system, and
• Online shopping or electronic shopping system.

The traditional or manual shopping system is the process where, when a customer needs to buy something, first needs to think from where he/ she can get it. Then drive to the specific shop or market, choose the products, bargain for prize. If he/ she want to purchase finally, he/ she may often need to stand in long queue at cash counter for long time. This type of shop or market are not fulfill your requirement all the time and don’t serve you 24 hours of a day. Also to go from one shop to another is killing your precious time.

One the other-hand online shopping system or electronic shopping system is the process where customers directly buy goods or service from a seller. By the help of internet shopping customer take a hassle free and sometimes even an enjoyable purchasing activity. But the existing online shopping system is not popular in our country. All online shopping system which are exist, they use their payment system by VISA card, Master card or etc. But in our country, those type of card use only top level person or very rich man in our society. So, in our country, the present online shopping system is not familiar and popular.

3.2 POSSIBLE SOLUTION

Our proposed system is little different from existing shopping system. Bangladesh is a developing country. A big population of our country can’t use online shop. They don’t know the system, process or mechanism of online shop. So we are added some new feathers with the existing online shopping system. They are

01. View All product details Easily

02. Easy payment system

03. Quickly Delivery process

04. Generate Secure Delivery Card

05. A total help guide, and

06. A customer care.

3.3 CHOOSING THE BEST SOLUTION

In our proposed system, the main highlight-able criteria are, here we use easy payment process. Such as by Mobile, by cash card, visa card or Bank account chooses by the customer. After completion of our project:

• Use an online shopping mall in easy payment process
• All of our general people can use this site,
• Save their time,
• Get a 24 hours service,
• Avoid to go several market,
• Reduced man power.
• Quick delivery service
• Easily Get the details products information
• High secure system,
• Avoiding congestion, and
• Get a new way for shopping in our country.

Table: Time Requirement

Stage
Initial study
Feasibility study
Problem Analysis
User Requirement
System Requirements
Functional Requirements
Basic Design
Input & Output Design
Back End Design
Day	10	20	30	40	50	60	70	80	90	100	110

Fig3.4.1: Time completion Gantt Chart

CHAPTER – 04

DESIGN

4.1WORKFLOW DIAGRAM

Fig 4.1.1: Work Flow Diagram for Online Shopping

Database design is the process of producing a detailed data model of database. And for that, first we give the use case diagram which required for the project:

Figure – 4.1.2 Work Flow for administrator

Figure – 4.1.3 Work Flow for customers

The relation that are implemented to create the database for the Development of a Generic Shopping Cart system described are order, order details, products, product advertise, temp order, user info. Here’s a brief description of the objects we identified with respect to our project.

4.2 STRUCTURE DIAGRAM

STRUCTURE DIAGRAM FOR CUSTOMER

Fig 4.2.1: Structure Diagram for Customer

STRUCTURE DIAGRAM FOR SHOP ADMIN

Fig 4.2.2: Structure Diagram for Shop Admin

4.3 OUTPUT AND INPUT DESIGN

SAMPLE INPUT FORM FOR SHIPPING INFORMATION

Fig 4.3.1: Sample input form

SAMPLE OUTPUT FORM FOR SHIPPING INFORMATION

Fig4.3.2: Sample output Form

4.4 DATABASE DESIGN

4.4.1 TABLE DESIGN

Table designs are completed in few steps:

1. Project Definition

2. Process Definition

3. Requirement Analysis

4. 1^st Normalization

5. 2^nd normalization

6. 3^rd normalization

1. PROJECT DEFINITION

· Product databases

· Stock databases

· Order

· Order details

· Customer database

· Employee databases

· Shipment information

· Payment information

2. PROCESS DEFINITION

· Product

· Stock

· Customer

· Employee

· Order

· Order details

· Shipment info

· Payment info

· Login

3. REQUIREMENT ANALYSIS

	Product Product ID Product Name Category Buy Price Sell price Product Image Description

Employee Emp ID First Name Middle Name Last Name Father Name Mother Name email Gender Date of Birth Marital Status Address Contact Joint Date Image

Customer Cus ID First Name Middle Name Last Name Shipping Address Email Contact Reg Date

	Order Order No Customer Date Is deliver
			Payment Payment No Payment Type Date Amount		Login User ID Password Access level

			Stock Product Name Quantity Date Stock by
	Shipment Shipment Address Shipment Date Note Shipment Contact
					Order Details Order No Product name Quantity

4. 1^st normalization

1^st normalization is defined each table primary key foreign key and define each field data type

			key Product type PK Product ID INT Product Name CHAR FK Category ID INT Purchase Price INT Sell price INT Product Image File Description CHAR
		key Orders type PK Order No INT FK User ID INT Issue Date DATE Is deliver INT Delivery Date DATE
			Key Stock type PK Stock ID INT FK Product ID INT Quantity INT Date DATE FK User ID INT
								key Product_category type PK ID INT Name CHAR
	Key Login Type PK Login ID INT FK User ID INT Password CHAR FK Access level ID INT
									key Order Details type PK Order ID INT FK Product ID INT Quantity INT

	Key Payment Type PK Payment No Payment Type INT Date DATE Amount INT
			Key Shipment Type PK Ship_id INT Shipment Address CHAR Shipment Date DATE Note CHAR Shipment Contact CHAR

5. 2^nd Normalization

In the 2^nd normalization Split repeated field into table

6. 3^rd normalization

In the third normalization removed Dependent field.

key Product_category type PK ID INT Name CHAR

Key Login Type PK Login ID INT FK User ID INT Password CHAR FK Access level ID INT

key Order Details type PK Order ID INT FK Product ID INT Quantity INT

Key Payment Type PK Payment No FK Payment Type INT Date DATE Amount INT

key Address type PK Address ID INT FK Employee ID INT FK Type ID INT Address CHAR FK City ID INT

key Country type PK ID INT Name CHAR

key City type PK ID INT Name CHAR FK Country ID INT

key Gender type PK ID INT Name CHAR

key Address type type PK ID INT Name CHAR

	key Access Level type PK ID INT Name			key Marital type PK ID INT Name CHAR
	key Payment type type PK ID INT Name CHAR

4.4.2 ENTITY RELATIONSHIP DIAGRAM

Fig4.4.2.1: Entity Relationship Diagram

4.4.3 RELATIONSHIP DIAGRAM

Fig4.4.3.1: Relationship Diagram

RELATIONSHIP DIAGRAM SOFTWARE SNAPSHOT

Fig4.4.3.2: Relationship Diagram using Software

4.5 System flowchart

Fig4.5.1:

Fig4.5.2: Data flow between Customer Shop and admin

Fig4.5.3: login

Fig4.5.4: Payment

Fig4.5.5: Add to cart

4.6 VALIDATION

Validation check for ID

ID
Present Check	Id must be present
Type check	it VARCHAR
Length Check	It must be 6 character

Validation Check for date of birth

Date of Birth
Present Check	Id must be present
Type check	it is must be date type
Format Check	Check date format

CHAPTER – 05

IMPLEMENTATION

5.1 Home page

At the home page, we want to give access to all the important links to the user. The home page divided into three parts. The first part is the top menu bar, where he got all the link of this site.

Fig: Home page

5.2 Customer Registration

There is the registration form. For the new customer gives all of those information properly and submit the form.

Fig: Customer Registration Form

5.3 Shipment & Delivery information form

Fig: Shipment and delivery information form

5.4 Home page after registration and login

Fig: Home page after registration and login

5.5 Admin Home page

Fig: Admin Home

 5.6 Employee Registration

Fig: Employee Registration

5.7 Employee addresses and contact info

Fig: employee address and Contact info

 5.8 Employee Login Information:

Fig: Employee login information

5.9 Completion of Employee Registration:

Fig: Employee registration completion window

 5.10 After login admin page

Fig: After login admin Page

5.11 Shopping cart details

Fig : View Shopping cart

CHAPTER – 06

VALIDATION & TESTING

6.1 Login validation

Fig: Login validation

6.2 input validation

Fig: input validation

CHAPTER – 07

CODING

7.1 Home page

<?php include(‘header.php’); ?>

Current Available Products </span></h2></div>

<table width=”100%” border=”1″>

<?php

include(‘include/cn.php’);

$cmt = 0;

$lid = 0;

$sql2 = “select count(id) from product”;

$r2 = mysql_query($sql2);

while($s = mysql_fetch_row($r2))

{

$cmt = $s[0];

}

if(isset($_GET[‘lid’]))

{

$lid =$_GET[‘lid’];

}

/**************************************/

$sql=”select p.id, p.product_name, p.image, c.name, u.name, s.quantity, s.sell_price from product p join category c on p.category_id=c.id join unit u on p.unit id = u.id join stock s on s.product_id=p.id where s.quantity>0 limit “.$lid.”, 9″;

$view_r=mysql_query($sql);

$count=0;

while($row=mysql_fetch_array($view_r))

{

$p_id=$row[0];

$p_image=$row[2];

$p_name=$row[3].”-“.$row[1];

$p_price=$row[6].”Tk./”.$row[4];

$p_qty=$row[5];

?>

<?php if($count==0){ ?>

<tr>

<?php } ?>

<td width=”33%”>

<div >

<div ><img src=”admin/<?php echo $p_image; ?> ” /></div>

<div ><b><?php print $p_name; ?> </b><br />Price : <?php print $p_price; ?><br />Available:<?php print $p_qty.$row[4]; ?></div>

<div ><a href=”add_cart.php?id=<?php echo $p_id; ?>”><input type=”button” value=”Add to cart”/></a><a href=”product_details.php?id=<?php echo $p_id; ?>”><input type=”button” value=”View”/></a></div>

</div>

</td>

<?php $count++; if($count==3){ ?>

</tr>

<?php $count=0; }?>

<?php } ?>

</table>

<table width=”100%” border=”1″ align=”center” >

<tr >

<td width=”25%”><?php if($lid>0){print “<a href=\”index.php?lid=0\”>First</a>”;} else {print “First”;} ?></td>

<td width=”25%”><?php if($lid>=9){print “<a href=\”index.php?lid=”.($lid-

9).”\”>&lt;&lt;Previous</a>”;} else {print “&lt;&lt;Previous”;} ?></td>

<td width=”25%” align=”right”><?php $c=($cmt-1)-(($cmt-1)%9); if($lid<$c){print “<a href=\”index.php?lid=”.($lid+9).”\”>Next&gt;&gt;</a>”;} else {print “Next&gt;&gt;”;} ?></td>

<td width=”25%” align=”right”><?php $c=($cmt-1)-(($cmt-1)%9); if($lid<$c){print “<a href=\”index.php?lid=”.(($cmt-1)-(($cmt-1)%9)).”\”>Last</a>”;} else {print “Last”;} ?></td>

</tr>

</table>

<?php include(‘footer.php’); ?>

7.2 Login page

<?php

session_start();

?>

<?php

include(‘include/cn.php’);

$password=$_POST[‘pass’];

$user_name=$_POST[‘user_name’];

$sql=”select user_id,login_name,access_level_id from login where login_name='”.$user_name.”‘ and password='”.$password.”‘”;

$login_result=mysql_query($sql);

if(mysql_num_rows($login_result)>0)

{

$row=mysql_fetch_array($login_result);

$_SESSION[‘cus_idno’]=$row[0];

$_SESSION[‘user_name’]=$row[1];

$_SESSION[‘access_id’]=$row[2];

if($row[2]==3)

{

$sql2=”select id, name, image from customer where cus_id='”.$row[0].”‘”;

$cus_result=mysql_query($sql2);

$cus_r=mysql_fetch_array($cus_result);

$_SESSION[‘cus_id’]=$cus_r[0];

$_SESSION[‘cus_name’]=$cus_r[1];

$_SESSION[‘cus_image’]=$cus_r[2];

print “<script type=’text/javascript’>window.location=’index.php'</script>”;

}

else

{

$sql2=”select id,first_name,last_name,image,type_id from employee where emp_id_no='”.$row[0].”‘”;

$cus_result=mysql_query($sql2);

$cus_r=mysql_fetch_array($cus_result);

$_SESSION[‘cus_id’]=$cus_r[0];

$_SESSION[‘cus_name’]=$cus_r[1].$cus_r[2];

$_SESSION[‘cus_image’]=$cus_r[3];

$_SESSION[’emp_type’]=$cus_r[4];

print “<script

type=’text/javascript’>window.location=’admin/display_products.php'</script>”;

}

}

else

{

$_SESSION[‘msg’]=”Error user name or password”;

print “<script type=’text/javascript’>window.location=’index.php'</script>”;

}

?>

7.3 View cart

<?php include(‘header.php’); ?>

<?php

session_start();

?>

Shopping cart

<br /><br />Order No # ORD-000001</span></h2></div>

<table width=”100%” border=”1″ >

<tr>

<th width=”10%”>SL#</th>

<th width=”10%”>Title</th>

<th width=”15%”>Image</th>

<th width=”20%”>Quantity </th>

<th width=”20%”>Price</th>

<th width=”25%”>Subtotal</th>

</tr>

<?php

include(‘include/cn.php’);

$item=count($_SESSION[“cart”]);

$p_qty=1;

$total=0;

$sl=1;

for($i=0;$i<$item;$i++)

{

$_SESSION[‘cart’][$i];

$sql=”select p.product_name, p.image, s.sell_price from product p join stock s on p.id=s.product_id where p.id=”.$_SESSION[‘cart’][$i];

$cart_result=mysql_query($sql);

$row=mysql_fetch_array($cart_result);

$p_title=$row[0];

$p_image=$row[1];

$p_price=$row[2];

$sub_total= $p_qty*$p_price;

$total+=$sub_total;

if($sl%2==0)

$;

else

$;

?>

<tr >

<td><?php echo $sl; ?></td>

<td><?php echo $p_title; ?></td>

<td align=”center”><img src=”admin/<?php echo $p_image; ?>” /></td>

<td align=”center”><?php echo $p_qty; ?></td>

<td align=”right”><?php echo $p_price; ?></td>

<td align=”right”><?php echo $sub_total; ?></td>

</tr>

<?php $sl++; }?>

<tr>

<td colspan=”5″>&nbsp;</td>

<td align=”right”><b>Price = </b><?php echo $total; ?></td>

</tr>

<tr>

<td colspan=”5″>&nbsp;</td>

<td align=”right”><b>Vat =</b> <?php echo $vat=$total*0.15; ?>tk.</td>

</tr>

<tr>

<td colspan=”5″>&nbsp;</td>

<td align=”right”><b>Total Price =</b> <?php echo $total+$vat; ?> Tk.</td>

</tr>

</table>

<?php include(‘footer.php’); ?>

7.4 Customer Registration

<?php

session_start();

include (‘include/cn.php’);

if(isset($_POST[‘Submit’]))

{

$cus_id=trim($_POST[‘cus_id’]);

$cus_name=$_POST[‘cus_name’];

$email=$_POST[’email’];

$gender=$_POST[‘gender’];

$phone=$_POST[‘phone’];

$country=$_POST[‘country’];

$reg_date=date(‘Y-m-d’);

$user_name=$_POST[‘user_name’];

$pass=$_POST[‘pass’];

if($_POST[‘chNoImg’]!=1)

{

$image_tempname = $_FILES[‘file_pic’][‘name’];

$imageDir=”images/”;

$imageName=$imageDir.$image_tempname;

if(move_uploaded_file($_FILES[‘file_pic’][‘tmp_name’],$imageName))

{

//get info about the image being uploaded

list($weidth,$height,$type,$attr) = getimagesize($imageName);

switch ($type)

{

case 1:

$ext=”.gif”;

break;

case 2:

$ext=”.jpg”;

break;

case 3:

$ext=”.png”;

break;

default;

print “Sorry, but the file yopu uploaded was not a GIF,JPG, or PNG file.<br>”;

print “Please hit your Browser’s ‘back’ button and try again.”;

}

$newfilename=$imageDir.$cus_id.$ext;

rename($imageName, $newfilename);

$sql=”INSERT INTO customer(cus_id,name,email,gender_id,phone,cuntry_id,image,reg_date)

VALUES(‘”.$cus_id.”‘,'”.$cus_name.”‘,'”.$email.”‘,'”.$gender.”‘,'”.$phone.”‘,'”.$country.”‘,'”.$newfilename.”‘,'”.$reg_date.”‘)”;

if(mysql_query($sql))

{

$_SESSION[‘cus_id’]=mysql_insert_id();

Disclaimer: