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. 1st Normalization

5. 2nd normalization

6. 3rd 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. 1st normalization

1st 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. 2nd Normalization

In the 2nd normalization Split repeated field into table

6. 3rd 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:

The information contains in this web-site is prepared for educational purpose. This site may be used by the students, faculties, independent learners and the learned advocates of all over the world. Researchers all over the world have the access to upload their writes up in this site. In consideration of the people’s participation in the Web Page, the individual, group, organization, business, spectator, or other, does hereby release and forever discharge the Lawyers & Jurists, and its officers, board, and employees, jointly and severally from any and all actions, causes of actions, claims and demands for, upon or by reason of any damage, loss or injury, which hereafter may be sustained by participating their work in the Web Page. This release extends and applies to, and also covers and includes, all unknown, unforeseen, unanticipated and unsuspected injuries, damages, loss and liability and the consequences thereof, as well as those now disclosed and known to exist.  The provisions of any state’s law providing substance that releases shall not extend to claims, demands, injuries, or damages which are known or unsuspected to exist at this time, to the person executing such release, are hereby expressly waived. However the Lawyers & Jurists makes no warranty expressed or implied or assumes any legal liability or responsibility for the accuracy, completeness or usefulness of any information, apparatus, product or process disclosed or represents that its use would not infringe privately owned rights. Reference herein to any specific commercial product process or service by trade name, trade mark, manufacturer or otherwise, does not necessarily constitute or imply its endorsement, recommendation or favouring by the Lawyers & Jurists. The views and opinions of the authors expressed in the Web site do not necessarily state or reflect those of the Lawyers & Jurists. Above all, if there is any complaint drop by any independent user to the admin for any contents of this site, the Lawyers & Jurists would remove this immediately from its site.