IDB-BISEW (OOP) ECOMMERCE

PROJECT

Online Shopping

Report

By

MUSFIQUR RAHMAN (Group Leader) - 01672978576

SHAKILA JAHAN

MUHAMMAD ANAMUL HOQ

MUZAMMEL HAQ

FARID UDDIN

SHAH AL-MAHMUDUN NABY

 E-commerce Documentation

WPSI (Web Presence Solution and Implementation)

BATCH: WPSI/NCLC-01M/R28/01

ROUND – 28

DESCEMBER, 2016

2
 E-commerce Documentation

APPROVAL
This project has been submitted to the following respected members, Md. Moshahidul
Islam, Project Consultant (WPSI), IDB-BISEW IT Scholarship Project and SK Abul
Hasan, Instructor (WPSI), NCLC by the flowing students of Round 28 (WPSI).

MUSFIQUR RAHMAN (Group Leader) - 01672978576

SHAKILA JAHAN

MUHAMMAD ANAMUL HOQ

MUZAMMEL HAQ

FARID UDDIN

SHAH AL-MAHMUDUN NABY

……………………………………………………….

MD.MOSHAHIDUL ISLAM
Show & Tell Consulting Ltd.
2/5A (3rd Floor), Block- A, Road-5, Lalmatia, Dhaka
E- mail: [email protected]
E-mail: [email protected]

……………………………………………………

SK ABUL HASAN
IDB-BISEW IT Scholarship Project (Instructor)
Momtaz Plaza (3rd Floor),House # 7 Road # 4,
E-mail: [email protected]

DECLARATION

3
 E-commerce Documentation

This is to certify that this project is our original work. No part of this work has been
submitted elsewhere partially or fully for the award of any other degree or diploma. Any
material reproduced in this project has been properly acknowledged.

……………………………………… ………………………………………
MUSFIQUR RAHMAN (Group Leader) SHAH AL-MAHMUDUN NABY
Batch ID-WPSI/NCLC-01M/R28/01 Batch ID-WPSI/NCLC-01M/R28/01
ID: 1203378 ID: 1201935

………………………………………… ……………………………………….
FARID UDDIN MUZAMMEL HAQ
Batch ID-WPSI/NCLC-01M/R28/01 Batch ID-WPSI/NCLC-01M/R28/01
ID: 1202987 ID:1204763

………………………………………. ……………………………………….
SHAKILA JAHAN MUHAMMAD ANAMUL HOQ
Batch ID-WPSI/NCLC-01M/R28/01 Batch ID-WPSI/NCLC-01M/R28/01
ID:1203570 ID:1201437

©2016
IDB-BISEW ROUND-28 NCLC STUDENTS
All Rights Reserved

4
 E-commerce Documentation

Abstract
The business-to-consumer aspect of product commerce (e-commerce) is the most
visible business use of the World Wide Web. The primary goal of an e-commerce site is
to sell goods online.

This project deals with developing an e-commerce website for Online Product Sale. It
provides the user with a catalog of different product available for purchase in the store.
In order to facilitate online purchase a shopping cart is provided to the user. The system
is implemented using a 3-tier approach, with a backend database, a middle tier of

Microsoft Internet Information Services (IIS) and PHP, and a web browser as the front
end client. In order to develop an e-commerce website, a number of Technologies must
be studied and understood.

These include multi-tiered architecture, server and client side scripting techniques,
implementation technologies such as PHP(OOP), JQUERY, BOOTSTRAP, HTML5,
relational databases (such as MySQLi, Access). This is a project with the objective to
develop a basic website where a consumer is provided with a shopping cart application
and also to know about the technologies used to develop such an application. This
document will discuss each of the underlying technologies to create and implement an
e-commerce website.

5
 E-commerce Documentation

ACKNOWLEDGEMENT

In completing this graduate project We have been fortunate to have help, support
and encouragement from many people. We would like to acknowledge them for their
cooperation.

First, We would like to thank SK ABUL HASAN, our project advisor, for
guiding us through each and every step of the process with knowledge and support.
Thank you for your advice, guidance and assistance.

We would also like to thank MD. MOSHAHIDUL ISLAM and IDB-BISEW PROJECT,
who are showed immense patience and understanding throughout the
project and provided suggestions.

Finally, We would like to dedicate this project to our NCLC AND IDB-BISEW Scholarships
project related stuff for their love, encouragement and help throughout the project.

6
 E-commerce Documentation

TABLE OF CONTENTS

Name Page
Introduction……………………………………………………………….. 8
Project Description……………………………………………………….. 8
Database Design……………………………………………….. 10-18

Diagrams…………………………………………………………………….. 19-22
Design And Implementation Of E-Commerce Site For Online Shopping.. 17
Web Page every option Details………………………………………… 24-38
Admin Panel…………………………………………………………. 39-47
Non-Functional / Operational Requirement…… 48
References ……………………………………………………… 49
50

7
 E-commerce Documentation

INTRODUCTION

E-commerce is fast gaining ground as an accepted and used business paradigm. More
and more business houses are implementing web sites providing functionality for
performing commercial transactions over the web. It is reasonable to say that the
process of shopping on the web is becoming commonplace.

The objective of this project is to develop a general purpose e-commerce store where
any kind of product can be bought from the comfort of home through the Internet.
However, for implementation purposes, this paper will deal with an online shopping for
baby product

An online store is a virtual store on the Internet where customers can browse the
catalog and select products of interest. The selected items may be collected in a
shopping cart. At checkout time, the items in the shopping cart will be presented
as an order. At that time, more information will be needed to complete the transaction.
Usually, the customer will be asked to fill or select a billing address, a shipping
address, a shipping option, and payment information such as bKash, or Cash on
Delivery. An e-mail notification is sent to the customer as soon as the order is placed.

8
 E-commerce Documentation

PROJECT DESCRIPTION

Any member can register and view available products.

Only registered member can purchase multiple products regardless of quantity.
Contact Us page is available to contact Admin for queries.
There are four roles available:
 Visitor
 User
 Operator
 Admin.

 Visitor can view, search, compare available products.

 User can view and purchase products.
 Operator can excess add option and can view everything of admin panel.
 Operator can add product, edit product, update and remove product.
 Can access users some information.
 Operato can ship order to user based on order placed by
sending confirmation mail.
 An Admin has some extra privilege including all privilege of visitor and user.

 Admin can add products, edit product information and add/remove

product.
 Admin can add user, edit user information and can remove user.
 Admin can ship order to user based on order placed by
sending confirmation mail.

DESIGN AND DEVELOPMENT ENVIRONMENT

 HTML5
 CSS3
 Bootstrap (Grid & Frameworks)
 jQuery
 Ajax

9
 E-commerce Documentation

 PHP
 MySQL
 Adobe Photoshop CS6
 Netbeans
 Dreamweaver CS6
DATABASE DESIGN

We use MySQL Database for this project total table . We describe the function of each
table below:

DATABASE TABLE
This is the database of our buybuy ecommerce. For complete this
ecommerce we use effective 21 table. We describe the table details on the
above of “database details page”.

BRAND TABLE:
Different type of product brand name stored this table:

10
 E-commerce Documentation

ID: This field use for unique id of Brand Table.

Name: Product brand name goes here.

CATEGORY TABLE
Category : All type of category store this table.

ID: This field use for unique id of Category Table.

Name: Product Category name goes here.

CITY TABLE
Different type of city name of different countries goes here.

ID: This field use for unique id of city table.

Name: City name goes here.
Countryid: Countryid field use here as a foreignkey.
.

COLOR TABLE
Different type of color of different type of product stored this table:

11
 E-commerce Documentation

ID: This field use for unique id of color table.

Name: different type of color name goes here.

COMMENTS TABLE
Product wise user’s comments and rating stored this table:

ID: This field use for unique id of comments table.

DESCRIPTION: comments description stored this field in shortly.
USERID: This field use here as a foreign key.
PRODUCTID: productid field also use here as a foreign key.
RATING: this field use for product rating .
DATE: This field is use for date.

COUNTRY TABLE
Different type of country name stored this table:

ID: this field use for unique id of country table.

NAME: Different type of country name goes here.
.

COUPON TABLE
Coupon information stored this table:
12
 E-commerce Documentation

ID: This field use for unique id of coupon table.

CODE: Product coupon code goes here.
AMOUNT: This field use for product amount.
DISCOUNT: Product discount enters in this field.

PRODUCT TABLE
Product’s information stored in this table. The table structure describes
below:

ID : This field use for unique id of product table.

TITLE: This field receive product title .
PRICE: Different type of product’s price goes here.
UNITID: Unitid use here as a foreign key.
DATE: Product entry and sales date goes here.
SUBCATEGORYID: Subcatagoryid use here as a foreign key .
BRANDID: Brandid use here as a foreign key.
VAT: Product related vat keep this field.
DISCOUNT: Product discount keep this field.
PICTURE: Product pic type keep this field.
STOCK: This field used to get product stock.
13
 E-commerce Documentation

PRODUCTCOLOR TABLE
Productcolor’s information stored in this table. The table structure describes
below:

ID : This field use for unique id of productcolor table.

PRODUCTID: This field use here as a foreign key .
COLORID: This field use here as a foreign key .

PRODUCTSIZE TABLE
Product Size’s information stored in this table. The table structure
describes below:

ID : This field use for unique id of productsize table.

PRODUCTID: This field use here as a foreign key .
SIZEID: This field use here as a foreign key .

PRODUCTTAGS TABLE
Producttag’s information stored in this table. The table structure describes
below:

14
 E-commerce Documentation

ID : This field use for unique id of productsize table.

PRODUCTID: This field use here as a foreign key .
TAGSID: This field use here as a foreign key .

SALES TABLE
Sales information stored in this table. The table structure describes below:

ID : This field use for unique id of sale’s table.

USERID: This field receive user id .and it is a foreign key .
SHIPINGID: Different type of shiping id goes here.and it is a foreign key .
COUPON_DISCOUNT: Coupon discount amount goes here.
FULLNAME: Customer’s full name goes here.
CONTACT: Customer’s contact goes here .
ADDRESS: product’s shiping address goes here.
POSTCODE: product Postcode keep this field.
DATE: Product sales date keep this field.
PAYMENT: peyment type keep this field.
TRANSACTIONID: This field used to get transactionid.

15
 E-commerce Documentation

SALESDETAILS TABLE
Sales details information stored in this table. The table structure describes
below:

ID : This field use for unique id of salesdetails table.

SALESID: This field use here as a foreign key .
PRODUCTID: This field use here as a foreign key .
QUANTITY: Quantity field use for sales product quantity.
SHIPPING TABLE
Shipping information stored in this table. The table structure describes
below:

ID : This field use for unique id of shipping table.

NAME: Area name saved this field.
CITYID: This field use here as a foreign key from city table .
AMOUNT: Shipping amount saved in this field.
SIZE TABLE
Size information stored in this table. The table structure describes below:

ID : This field use for unique id of size table.

16
 E-commerce Documentation

NAME: This field use here as a foreign key.

SUBCATEGORY TABLE
Subcategory information stored in this table. The table structure describes
below:

ID : This field use for unique id of subcategoryid table.

NAME: This field use here as a foreign key.
CATEGORYID: This field use here as a foreign key.
TAGS TABLE
Tags information stored in this table. The table structure describes below:

ID : This field use for unique id of Tags table.

NAME: This field use here as a foreign key.

UNIT TABLE
Unit information stored in this table. The table structure describes below:

ID : This field use for unique id of Unit table.

NAME: This field use here as a foreign key.

17
 E-commerce Documentation

USERS TABLE
User’s information stored in this table. The table structure describes below:

ID : This field use for unique id of Unit table.

NAME: This field use here for keeping username.
EMAIL: This field use here as a foreign key.
PASSWORD: This field use here for user’s account password.
TYPE: This field uses for type of users.
ADDRESS: usr’s address keeping here.
CONTACT: user’s contact keeping here .
GENDER: This field keeps users gender.
PICTURE: This field use for keeping type of user’s picture.

WISHLIST TABLE
wishlist information stored in this table. The table structure describes
below:

PRODUCTID : This field use here as a foreign key.

USERID: This field use here as a foreign key .

18
 E-commerce Documentation

Diagrams of buybuy Shopping Website Management System

Login Activity:

Registration Activity Diagram:

19
 E-commerce Documentation

Admin Activity Diagram:

20
E-commerce Documentation

21
 E-commerce Documentation

Admin Activity Diagram:

22
 E-commerce Documentation

User Activity Diagram:

23
 E-commerce Documentation

DESIGN AND IMPLEMENTATION OF E-COMMERCE SITE FOR ONLINE SHOPPING

Web Pages details:

 Home Page
 Shop Page
 Blog Page
 Article List
 Registration Page
 Profile Page
 Feedback Page
 FAQ Page
 Login Page
 Contact Page

HOME PAGE: This is home page or welcome page.

24
 E-commerce Documentation

IMAGE SLIDER
This is a image slider section of the side.

25
 E-commerce Documentation

IMAGE ZOOM PAGE

Image zooming is special feature of our buybuy ecommerce. If customer’s use this
zooming tool on picture then they will see good resolution of product item.so it’s help’s
the customer to chose product efficiently.

LETEST ITEM PAGE

26
 E-commerce Documentation

This is the one of the front end page part of our buybuy ecommerce .New
arrival product we show here.

MENU BAR
This is the manu of our buybuy ecommerce.

DETAILS BUTTON & CART BUTTON

The Details Button will redirect to Product Details Page. Which contains product
information, description of products, ratings & reviews and recommended items. With
Add to Cart Button you can cart a product.

27
 E-commerce Documentation

WISH LIST & CART

Wish list icon contains the number of wish list. Wish list icon can redirect Wish list page.
Cart icon contains the number of Cart product. Cart icon redirects to Checkout page.

CATEGORY LIST

28
 E-commerce Documentation

The category list contains all product category. If we press on a category it will show the
subcategory list. Subcategory list will show the product under subcategory.

BRAND LIST
Brand list contains all brands of product. It also show the related brand products.

29
 E-commerce Documentation

CONTACT PAGE:
This page contains contact information about company.

30
 E-commerce Documentation

POPULAR PRODUCTS
This page contains only popular product. Where customer can add to cart a product,
can view products information that sort by product name, filter by product price, can
search a product according it’s keyword and can show pages according product
quantity. In the sidebar of this page also have categories, tags, recently views products
and popular products.

31
 E-commerce Documentation

PRODUCT DESCRIPTION PAGES

This page show product description. Where customer can add to cart a product, can
view products information that sort by product name, filter by product price, can search
a product according it’s keyword and can show pages according product quantity. In the
sidebar of this page also have categories, tags, ratings, recently views products and
popular products.

REVIEW SYSTEM PAGE

This page shows product reviews and ratings. Where customer can add ratings and
review about a product, can view products reviews and ratings.

32
 E-commerce Documentation

SEARCH OPTION
This option gives us the facilities to search products by category, name, keyword, and
brand.

PAGINATION
This is a pagination menu. By this menu we can move next or previous pages.

33
 E-commerce Documentation

SHOP NOW PAGE

This page shows product. Where customer can add to cart a product, can view products
information that sort by product name, filter by product price, can search a product
according it’s keyword and can show pages according product quantity. In the sidebar
of this page also have categories, tags, recently views products and popular products.

34
 E-commerce Documentation

WISHLIST ITEM PAGE

This page contains only wishlist product. Where customer can view a product
information that thay have wished.

RECOMMENDED ITEM PAGE

35
 E-commerce Documentation

This page shows recommended product. Where customer can add to cart a product,
can view products information that sort by product name, filter by product price, can
search a product according it’s keyword and can show pages according product
quantity. In the sidebar of this page also have categories, tags, recently views products
and popular products.

COMPARE PRODUCT PAGE:

This page is the page of comparing product. We can compare two or more product and
their price in this page.

36
 E-commerce Documentation

SHIP-TO VIEW PAGE

This page shows ship-to data, resident area, order date of product of a customer.

VIEW ORDER PAGE OF CUSTOMER

This page shows order details of a customer about there purchase of product.

PAYMENT OPTION PAGE:

Payment option sets payment type for product buying. It is the part of checkout page.
The available Payment types are Bkash, cash on delivery, PayPal, Bank Transfer. We
also can use coupon code for discount from payment option.

37
 E-commerce Documentation

CONTACT MAP PAGE

This page show the information of how to go the buybuy shop from anywhere of this
country.in shortly this is the contact map of our buybuy shop.

38
 E-commerce Documentation

ADMIN PANEL
Admin panel is a panel where the admin fully control of the website.it is the
most important for the website. A admin panel is called a controller of the
website. Our admin panel has new profile, change password, product,
Brand,category,Subcategory,city,country,shipping,customer,tag,color
,coupon, size, Invoice etc.

Change password
Change password is the most important part of the website. A user may
register or create account. Suddenly he needs to change the password. We
are given this facility for every user.

39
 E-commerce Documentation

Categroy view:
Category is the identifier of the product.A category tell what type of product
here.A customer can easily find their product to see the category.Our
project categories here

40
 E-commerce Documentation

PRODUCT VIEW PAGE

This page shows product. Where customer can add to cart a product, can view products
information that sort by product name, filter by product price, can search a product
according it’s keyword and can show pages according product quantity. In the sidebar
of this page also have categories, tags, recently views products and popular products.

SHIPPING VIEW PAGE

This page shows shipping area and shipping cost of product and user can also edit and
delete the shipping area and cost from this pages.

41
 E-commerce Documentation

PRODUCT SIZE VIEW PAGE

This page shows product size in veryus dimensions. user can also edit and delete the
product size from this pages.

PRODUCT TAGS VIEW PAGE

This page shows product tags. user can also edit and delete the product tags from this
pages.

42
 E-commerce Documentation

SUB-CATEGORY VIEW PAGE

This page shows subcategory of product. user can also edit and delete the product
subcategory from this pages.

City view:
city is the part of this admin pannel. City tell us users are which
country register here.

43
 E-commerce Documentation

INVOICE PAGE:
This is our invoice page. After product buying customer will get this invoice which will be
sent with product

44
 E-commerce Documentation

COLOR VIEW PAGE:

This is the page of viewing product color. We can edit and delete the product color.

COUPON VIEW PAGE:

This is the page of viewing product coupon list. We can edit and delete the product
coupon list.

45
 E-commerce Documentation

COUNTRY VIEW PAGE:

This is the page of viewing product selling country. We can edit and delete the product
selling country.

46
 E-commerce Documentation

PRODUCT VIEW PAGE:

This page contains all product lists that are in stock. This page contains product’s
details information as like title, price, date of include, vat, discount, picture of product
and stock of product. The admin only can view the page. Admin can edit and delete the
product information from this page.

47
 E-commerce Documentation

NON-FUNCTIONAL / OPERATIONAL REQUIREMENTS

 Security
Pages of the website must be access in the way they were included files shall
not be accessed outside of their parent file.
Administrator can only perform administrative task on pages they are privileged
to access. Customers will not be allowed to access the administrator pages.
 Efficiency and Maintainability
Page loads should be returned and formatted in a timely fashion depending on
the request being made.
Administrators will have the ability to edit the aspects of the order forms, product
descriptions, prices and website directly

CONCLUSION:
The Internet has become a major resource in modern business, thus electronic
shopping has gained significance not only from the entrepreneur’s but also from the
customer’s point of view. For the entrepreneur, electronic shopping generates new
business opportunities and for the customer, it makes comparative shopping possible.

As per a survey, most consumers of online stores are impulsive and usually make a
decision to stay on a site within the first few seconds. “Website design is like a shop
interior. If the shop looks poor or like hundreds of other shops the customer is most
likely to skip to the other site.

Hence we have designed the project to provide the user with easy navigation, retrieval
of data and necessary feedback as much as possible. In this project, the user is
provided with an e-commerce web site that can be used to buy all types baby products
online.
In this project the ‘add to cart’ functionality made by raw PHP without using any plugin
and bKash payment system is not included properly in this project because to complete
bKash payment system we require a particular payment gateway.

REFERENCES:
http://www.w3schools.com/

http://www.php.net

================ END ===================

48