Project Report

On

E-COMMERCE STORE

Internal Guide: By:

Prof. Keyurbhai Arvindbhai Jani Shah Mahek (15012011044)
Ranpura Henali(15012011041)

B. Tech Semester VII Computer Engineering

Nov - Dec 2018

Submitted to
Department of Computer Engineering
U. V. Patel College of Engineering
Ganpat University, Ganpat Vidyanagar - 384012
1
 U. V. PATEL COLLEGE OF
ENGINEERING

Nov – Dec 2018

C E RT I F I C AT E
T O W H O M S O E V E R I T M AY C O N C E R N

This is to certify that Mr. Mahek Shah student of B. Tech Semester

VII Computer Engineering has completed B. Tech Minor Project titled
“E-Commerce Store” in the year 2018.

Project Guide name: Head of

Department
Prof. Keyurbhai Arvindbhai Jani

Sign:_________________ CE Department

Date: 05/12/2018

2
 U. V. PATEL COLLEGE OF
ENGINEERING

Nov – Dec 2018

C E RT I F I C AT E
T O W H O M S O E V E R I T M AY C O N C E R N

This is to certify that Ms. Ranpura Henali student of B. Tech

Semester VII Computer Engineering has completed B. Tech Minor
Project titled “E-Commerce Store” in the year 2018.

Project Guide name: Head of

Department
Prof. Keyurbhai Arvindbhai Jani

Sign:_________________ CE Department

Date: 05/12/2018

3
 ACKNOWLEDGEMENT

The satisfaction and euphoria that accompany the successful completion of any task would be
incomplete without the mentioning of the people whose constant guidance and encouragement made it
possible. We take pleasure in presenting before you, our project, which is result of studied blend of both
research and knowledge.

We express our earnest gratitude to our internal guide, Assistant Professor Keyurbhai Arvindbhai Jani,
Department of CE/IT, our project guide, for his constant support, encouragement and guidance. We are
grateful for his cooperation and his valuable suggestions.

Finally, we express our gratitude to all other members who are involved either directly or indirectly for
the completion of this project.

4
 ABSTRACT

The Project entitled "E-COMMERCE STORE" is a web-based application Software developed in PHP
using HTML5,CSS,BOOTSTRAP. The main aim of "E-COMMERCE STORE" is to improve the
services of Customers and vendors. It maintains the details of customer payments, product receipts,
addition of new customers, products and also updating, deletion for the same. It also stores the details of
invoices generated by customer and payments made by them with all Payments details like credit card.
The primary features of the project entitled "ONLINE SHOPPING" are high accuracy, design flexibility
and easy availability. And also it uses database tables Representing entities and relationships between
entities.

5
 INDEX

1. INTRODUCTION…………………………………………………………………………….6
1.1 PROJECT OVERVIEW……………………………………………………………………...6
1.2 SCOPE OF PROJECT………………………………………………………………………..6
1.3 PURPOSE OF PROJECT…………………………………………………………………….7
1.4 PROPOSED SYSTEM……………………………………………………………………….7

2.FEASIBILITY ANALYSIS……………………………………………………………….....8
2.1TECHNICAL FEASIBILITY……………………………………………………………......8
2.2 ECONOMICAL FEASIBILITY………………………………………………………….....8
2.3OPERATIONAL FEASIBILITY………………………………………………………….....8

3. HARDWARE AND SOFTWARE REQUIREMENTS……………………………………9

3.1 HARDWARE………………………………………………………………………………..9
3.2SOFTWARE………………………………………………………………………………….9

4.SYSTEM STUDY…………………………….………………………………………..........10
4.1DEFINATION OF SYSTEM ………………………………………………………...........10
4.2 NEEDS OF SYSTEM……..………………………………………………………………..10
4.3SYSTEM ANAYSIS……………………………………………………………………...…10

5.PROJECT PLANING………………………………………….……..……………..….…...11
5.1 PRILIMINARY INVESTIGATION…………………………………………………...…...11
5.2 INFORMATION GATHERING……………………………………………………...….....11
5.3 STRUCTURED ANALYSIS………………………………………………………….........11

6. SYSTEM DESIGN……………..……………………………………………………............12
6.1USE CASE DIAGRAM……………………………………………………………………...12
6.2DATA FLOW DIAGRAM…………………………………………………………………..12
6.3CLASS DIAGRAM…………………………………………………………………….........13
6.4E-R DIGRAM………………………………………………………………………………..14

7. SCREENSHOTS…………………………………………………………...………………..15
7.1ADMIN PANEL……………………………………………………………………………..15
7.2E-COMMERCE STORE(USER MODULE)………………………………………………..23

8. DATA DICTIONARY………………………..………………………………,………........31

9. INTERPRETATION OF PROJECT……………………………………………………..35
9.1ADVANTAGES…………………………………………………………………………….35

10.CONCLUSION………………………………………………………………..……………36

11.REFERENCE & BIBLIOGRAPHY…………………………………...………………….37

6
12.ABOUT TOOLS & TECHNOLOGY…………………………...………………………38

LIST OF TABLES
Table.8.1.ADMINS………………………………………………………………………..31
Table.8.2.CART……………………………………………………………………………31
Table.8.3.CATAGORIES………………………………………………………………….31
Table.8.4.CUSTOMER……………………………………………………………………34
Table.8.5.CUSTOMER_ORDER………………………………………………………….34
Table.8.6.PENDING_ORDER……………………………………………………………35
Table.8.7.PRODUCTS……………………………………………………………………35
Table.8.8.PRODUCT_CATAGORIES……………………………………………………36
Table.8.9.SLIDER…………………………………………………………………………36.

LIST OF FIGURES
Fig.6.1.USE CASE DIAGRAM……………………………………………………………12
Fig.6.2.DATA FLOW DIAGRAM…………………………………………………………12
Fig.6.3.CLASS DIAGRAM…………………………………………………………………13
Fig.6.4.1.CUSTOMER ENTITY……………………………………………………………13
Fig.6.4.2.PRODUCT ENTITY………………………………………………………………14

TABLE OF IMAGES

7.1 ADMIN PANEL:

Fig.7.1.1 Admin Panel…………………………………………………………………15
Fig.7.1.2 Dashboard……………………………………………………………………15
Fig.7.1.3 view products………………………………………………………………..16
Fig.7.1.4 view customers……………………………………………………………..16
Fig.7.1.5 view product catagories……………………………………………………17
Fig.7.1.6 view Order…………………………………………………………………..17
Fig.7.1.7 insert product…………………………………………………………………18
Fig.7.1.8 insert product category……………………………………………………18
Fig.7.1.7 View Categories…………………………………………………………..19
Fig.7.1.8 insert slide…………………………………………………………………19
Fig.7.1.9 View Slides…………………………………………………………………20
Fig.7.1.10 View payment…………………………………………………………20
Fig.7.1.11 insert user…………………………………………………………………21
Fig.7.1.12 View product……………………………………………………………21
Fig.7.1.13 Edit Profile …………………………………………………………….21

7
7.2 E-COMMERCE STORE (USER MODULE):
Fig.7.2.1 View product………………………………………………………..26
Fig.7.2.2 Register………………………………………………………………26
Fig.7.2.3 Login………………………………………………………………….27
Fig.7.2.4 My Account…………………………………………………………27
Fig.7.2.5 My Account…………………………………………………………28
Fig.7.2.6 Pay Offline…………………………………………………………..28
Fig.7.2.7 Edit Account………………………………………………………..29
Fig.7.2.8 Change Password…………………………………………………..29
Fig.7.2.9 Delete Account………………………………………………………30
Fig.7.2.10 Shopping Cart……………………………………………………..30
Fig.7.2.11 Checkout…………………………………………………………..31
Fig.7.2.12 Shopping Cart…………………………………………………….31
Fig.7.2.12 Contact us………………………………………………………..32

8
 1. INTRODUCTION

1.1 OVERVIEW:

The central concept of the application is to allow the customer to shop virtually using the Internet
and allow customers to buy the items and articles of their desire from the store. The information
pertaining to the products are stores on an MYSQL at the server side (store). The Server process
the customers and the items are shipped to the address submitted by them. The application was
designed into two modules first Os for the customers who wish to buy the articles.Second is for
the storekeepers who maintains and updates the information pertaining to the articles and those
of the customers? The end user of this product is a departmental store where the application is
hosted on the web and the administrator maintains the database. The application which is
deployed at the customer database, the details of the items are brought forward from the database
for the customer view based on the selection through the menu and the database of all the
products are updated at the end of each transaction. Data entry into the application can be done
through various screens designed for various levels of users. Once the authorized personnel feed
the relevant data into the system, several reports could be generated as per the security.

1.2 SCOPE OF PROJECT:

Purchasing and selling products and services over the internet without the need of going
physically to the market is what online shopping all about. Online shopping is just like a retail
store shopping that we do by going to the market, but it is done through the internet. Online
shopping has made shopping painless and added more fun. Online stores offer product
description, pictures, comparisons, price and much more. Few examples of these are
Amazon.com, ebay.com, framt.com and the benefits of online shopping is that by having direct
access to consumer ,the online stores can offer products that cater to the needs of consumer
,cookies can be used for tracking the customer selection over the internet or what is of their
interest when they visit the site again . Online shopping makes use of digital technology for
managing the flow of information, products, and payment between consumer, site owners and
suppliers. Online shopping can be either B2B (business to business) or B2C (business to
consumer)

Shopping cart is one of the important facility provided in online shopping, this lets customer to
browse different goods and services and once they select an item to purchase they can place the
item in shopping cart, and continue browsing till the final selection. Customers can even remove
the items from shopping cart that were selected earlier before they place the final order. It
reminds us of shopping basket that we carry in departmental store

9
1.3 PURPOSE OF PROJECT:

The purpose of online shopping is to save time, save money. Through online
shopping one can save his valuable time. One can watch and select things he
wanna to buy. Through online shopping we can save our money because prices
are less than market prices and we receive our bought things at our home. No
need to go anywhere and do shopping. We can get different varieties of things
online and we can choose which one we want.

1) To achieve target turnover and gross profit

2) To offer a quality experience for customers that matches the aspirations of a customer.

Online shoppingis a form of electronic commerce where the buyer is directly online to the
seller's computer usually via the internet. There is no intermediary service. The sale and
purchase transaction is completed electronically and interactively in real-time such as
Amazon.com for new books. If an intermediary is present, then the sale and purchase
transaction is called electronic commerce such as eBay.com.

1.4 Proposed System:

The development of this new system contains the following activities, which try to develop on-
line application by keeping the entire process in the view of database integration approach.
 Secure registration and profile management facilities for Customers.

 Browsing through the e-Mall to see the items that are there in each category of products
like Apparel, Kitchen accessories, Bath accessories, Food items etc.

 Creating a Shopping cart so that customer can Shoppe ‘n’ no. of items and checkout
finally with the entire shopping cart

 Customers should be able to mail the Shop about the items they would like to see in the
Shop

 Secured mechanism for checking out from the Shop( Credit card verification mechanism)

 Updates to customers about the Recent Items in the Shop.

 Uploading ‘Most Purchased’ Items in each category of products in the Shop like Apparel,
Kitchen accessories, Bath accessories, Food items etc

10
 2. FEASIBILITY ANALYSIS

Feasibility study is the process of determination of whether or not a project is worthdoing.

Feasibility studies are undertaken within tight time constraints and normally
culminate in awritten and oral feasibility report. I have taken two weeks in feasibility study
with my co-developer.The contents and recommendations of this feasibility study
helped us as a sound basis for decidinghow to proceed the project. It helped in
taking decisions such as which software to use, hardware combinations, etc.

1)Technical Feasibility
2)Economical Feasibility
3)Operational Feasibility

2.1 TECHNICAL FEASIBILITY:

Technical feasibility determines whether the work for the project can be done with theexisting
equipment, software technology and available personnel. Technical feasibility is
concernedwith specifying equipment and software that will satisfy the user requirement.

This project is feasible on technical remarks also, as the proposed system

i s m o r e beneficiary in terms of having a sound proof system with new technical components
installed on thesystem. The proposed system can run on any machines supporting Windows and
Internet services andworks on the best software and hardware that had been used while designing
the system so it would befeasible in all technical terms of feasibility

2.2 ECONOMICAL FEASIBIBLITY:

Economical feasibility determines whether there are sufficient benefits in creating tomake the
cost acceptable, or is the cost of the system too high. As this signifies cost-benefit analysisa n d
savings. On the behalf of the cost-benefit analysis, the proposed system is
f e a s i b l e a n d i s economical regarding its pre-assumed cost for making a system.

We classified the costs of eSHOP according to the phase in which they occur. As weknow that
the system development costs are usually one-time costs that will not recur after the projecthas
been completed. For calculating the Development costs we evaluated certain cost categories viz.

1.Personal costs
2.Computer usage
3.Supply and equipments costs
4.Cost of any new computer equipments and software

2.3 OPERATIONAL FEASIBILITY:

It is mainly related to human organization and political aspects. The points to be considered are:

•What changes will be brought with the system?

11
 3. SOFTWARE & HARDWARE REQUIREMENT

3.1 Software Requirements :

Operating System : Windows XP/7 or Linux

User Interface : HTML, CSS
Front End : PHP 5.2 &Wampserver 2.0
Back End : PHP MYSQL 2.1
Programming Language : PHP
Browser : Internet Explorer 8.0

3.2 Hardware Requirements:

Processor : Intel Pentium IV

Hard Disk : 1.44 MB FDD
RAM : 512MB or more
Monitor : 1 5”Colour monitor
Proccessor Speed : 1.7 GHZ
CD Drive : 52-X CD ROM
Keyboard : Mercury 1 10 keys
Mouse : Logtech mouse

12
 4. SYSTEM STUDY

4.1 DEFINITION OF THE SYSTEM

A system is an orderly grouping of independent components linked together according to a plan
to achieve a specific objective. Its main characteristics are organization, interaction, independent,
integration and central objective a system does not necessarily mean to a computer system. It
may be a manual system or any other names.

4.2 NEEDS OF THE SYSTEM

Social and economic factor: a wave of social and economic changes often follows in the wake of
the new technology. New opportunities may arise to improve on a production process or to do
something that was not previously possible. Changes in the ways individuals are organized into
groups may then be necessary, and the new groups may complete for economic resources with
established units.
Technological factor: people have never before in a time when the scope of scientific inquiry was
so broad, so when the speed of applying the new technology accounts for many changes in the
organization.
High level decisions and operating processes: in response to technological, socio-economical
factors, top level managers may decide to recognize operations and introduce new products. To
deal with these needs, people commonly seek new modified information to support the decision.
When that happens, then they obtain turn to a computer system for help the information users
and data processing specialist then work together to complete a series of steps in a system study
to produce output results to satisfy information needs.

4.3 System analysis

System Analysis is a process by which we attribute process or goals to a human activity,
determine how well those purpose are being achieved and specify the requirements of the various
tools and techniques that are to be used within the system if the system performances are to be
achieved.

13
 5. PROJECT PLANNING

Planning for information systems has a time horizon and a focus dimension. The time horizon
dimension specifies the time range of the plan, where as the focus dimension relates whether the
primary concern is strategic, managerial, or operational. The system i.e. The Project that we were
assigned was required to complete within 20 weeks. What we had planned is as follows:
Requirements analysis, Preliminary Investigation & Information Gathering should be covered
within the 1st and 2nd week. Since I was not aware of MYSQL with PHP it require 1 week for me
to adjust with that. 12 Weeks for the design of the system under development. 1 week for
Testing & Implementation. And rest 2 reserve weeks.

5.1 PRELIMINARY INVESTIGATION

The initial investigation has the objective of determining the validity of the user’s request for a
candidate system and whether a feasibility study should be conducted.
The objectives of the problem posed by the user must be understood within the framework of
the organization’s MIS plan. Ihad investigated from the concerned authority about the project.

5.2 INFORMATION GATHERING

A key part of feasibility analysis is gathering information about the present system. The analyst
must know what information to gather, where to find it, how to collect it, and what to make of it.
The proper use of tools for gathering information is the key to successful analysis. The tools are
the traditional interview, questionnaires, and on-site observation.

5.3 STRUCTURED ANALYSIS

The traditional tools of data gathering have limitations. An English narrative description is often
vague and difficult for the user to grasp. System flowcharts focus more on physical than on
logical implementation of the candidate system. Because of these drawbacks, structured tools
were introduced for analysis. Structured analysis is a set of techniques and graphical tools (DFD)
that allow the analyst to develop a new kind of system specifications that are easily
understandable to the use
14
 6. SYSTEM DESIGN
6.1 USE CASE DIAGRAM:

Fig.6.1.USE CASE DIAGRAM

6.2 DATAFLOW DIARAM:

Fig.6.2.DATA FLOW DIAGRAM

6.3 CLASS DIAGRAM:

15
 Fig.6.3.CLASS DIAGRAM
6.4 E-R DIAGRAM:
CUSTOMER ENTITY:

Fig.6.4.1.CUSTOMER ENTITY

16
PRODUCT ENTITY:

FiG.6.4.2.PRODUCT ENTITY

17
 7. SCREENSHOTS
7.1 ADMIN PANEL:

Login:

Fig.7.1.1 Admin Panel

Dashboard:

Fig.7.1.2 Dashboard

18
Dashboard/view products:

Fig.7.1.3 view products

Dash board/view customers:

Fig.7.1.4 view customers

19
Dashboard/view product catagories:

Fig.7.1.5 view product catagories

Dashboard/view orders:

Fig.7.1.6 view Order

20
Insert product:

Fig.7.1.7 insert product

Insert product category:

Fig.7.1.8 insert product category

21
View catagories:

Fig.7.1.7 View Categories

Insert slide:

Fig.7.1.8 insert slide

22
View slide:

Fig.7.1.8 View Slides

View payment:

Fig.7.1.10 View payment

23
Insert user:

Fig.7.1.11 insert user

View user:

Fig.7.1.12 View product

24
Edit profile:

Fig.7.1.12 Edit Profile

25
7.2 E-COMMERCE STORE (USER MODULE):

Homepage:

Fig.7.2.1 View product

Register:

Fig.7.2.2 Register
26
Login:

Fig.7.2.3 Login
My account:

Fig.7.2.4 My Account

27
Shop:

Fig.7.2.5 My Account

Pay offline:

Fig.7.2.6 Pay Offline

28
Edit account:

Fig.7.2.7 Edit Account

Change password:

Fig.7.2.8 Change Password

29
Delete account:

Fig.7.2.9 Delete Account

Shopping cart:

Fig.7.2.10 Shopping Cart

30
Proceed to chrckout:pay offline / pay online by paypal:

Fig.7.2.11 Checkout

Update cart:

31
 Fig.7.2.12 Shopping Cart

Contact us:

Fig.7.2.1 Contact us

32
 8. DATA DICTIONARY

TABLE: ADMINS
FIELD NAME TYPE LENGTH KEY
admin_id int 10 Primary
admin_name varchar 255 -
admin_email varchar 255 -
admin_pass varchar 255 -
admin_image text - -
admin_contact varchar 255 -
admin_country text - -
admin_job varchar 255 -
admin_about text - -
Table.8.1.ADMINS

TABLE: CART
FIELD NAME TYPE LENGTH KEY
p_id int 10 primary
ip_add varchar 255 -
qty int 10 -
Size text - -
Table.8.2.CART

TABLE: CATAGORIES
FIELD NAME TYPE LENGTH KEY
cat_id int 10 primary
cat_titlt text - -
cat_desc text - -
Table.8.3.CATAGORIES

TABLE: CUSTOMERS
33
 FIELD NAME TYPE LENGTH KEY
customer_id int 10 primary
customer_name varchar 255 -
customer_email varchar 255 -
customer_pass varchar 255 -
customer_country text - -
customer_city text - -
customer_contact varchar 255 -
customer_address text - -
customer_image text - -
customer_ip varchar 255 -
Table.8.4.CUSTOMER

TABLE: CUSTOMER_ORDERS
FIELD NAME TYPE LENGTH KEY
order_id int 10 primary
customer_id int 10 -
due_amount int 10 -
invoice_no int 10 -
qty int 10 -
size text - -
order_date timestamp - -
order_status text - -
Table.8.5.CUSTOMER_ORDER

TABLE: PENDING_ORDERS

FIELD NAME TYPE LENGTH KEY

order_id int 10 primary

34
 customer_id int 10 -
due_amount int 10 -
invoice_no int 10 -
qty int 10 -
size text - -
product_id text - -
order_status text - -
Table.8.6.PENDING ORDERS

TABLE: PRODUCTS
FIELD NAME TYPE LENGTH KEY
product_id int 10 primary
p_cat_id int 10 -
cat_id int 10 -
date timestamp - -
product_title text - -
product_img1 text - -
product_img2 text - -
product_img3 text - -
product_price int 10
product_desc text -
product_keywords text -
Table.8.7.PRODUCTS

TABLE: PRODUCT_CATAGORIES
FIELD NAME TYPE LENGTH KEY
p_cat_id int 10 primary
p_cat_titlt text - -
35
 p_cat_desc text - -
Table.8.8.PRODUCT_CATAGORIES

TABLE: SLIDER
FIELD NAME TYPE LENGTH KEY
slide_id int 10 primary
slide_name varchar 255 -
slide_image text - -
Table.8.9.SLIDER

9. INTERPRETETION OF PROJECT

The system has been implemented and tested successfully. It meets the information requirements
specified to the great extent. although the system has been designed keeping the present and
future requirements in mind and made very flexible.
There are limitations of the system. proper consideration has been given for a wide range of new
enhancements.The system is developed user friendly.In future , if it is required to generate

36
reports other than provided by the system it can be simply achieved by a separate module to the
main menu without affecting the design of the system.

9.1 ADVANTAGES:

(1)it simplifies the operation.

(2)it avoids a lot of manual work.
(3)every transaction is obtained and processed immediately.
(4)avoids errors by avoiding the manual work.
(5)user friendly screen to enter the data and enquire the database tables.
(6)online help messages available to the operating system.
(7)user can easily access the system without much experience.
(8)provide hardware and software securities.
(9)portable and flexible for further extensions.

10. Conclusion

The central concept of the application is to allow the customer to shop virtually using the Internet
and allow customers to buy the items and articles of their desire from the store.
The information pertaining to the products are stores on an RDBMS at the server side (store).The
Server process the customers and the items are shipped to the address submitted by them.

37
 The application was designed into two modules first Os for the customers who wish to buy the
articles. Second is for the storekeepers who maintains and updates the information pertaining to
the articles and those of the customers.
The end user of this product is a departmental store where the application is hosted on the web
and the administrator maintains the database. The application which is deployed at the customer
database, the details of the items are brought forward from the database for the customer view
based on the selection through the menu and the database of all the products are updated at the
end of each transaction.

11. REFRNCES & BIBLIOGRAPHY

1. www.goshopmatic.com
2. www.researchgate.net
3. www.wikipedia.org
4. www.hostgator.com
38
 12. ABOUT TOOLS & TECHNOLOGY

12.1 Why We Use SQL

1.Security Management:
SQL Server provides a controlled access to data to users by providing
a c o m b i n a t i o n o f privileges.
39
2.Backup and Recovery:
SQL Server provided sophisticated security backup and recovery routines.

3.Open connectivity:
SQL Server provides open connectivity to and from other vendor’s software such as
Microsoft.Also SQL Server database can be access by various front-end software’s
such as MicrosoftVisual Basic ®, Power Builder etc.

4.Space Management:
In SQL Server once can flexibly allocate disk spaces for data storage and can control
themsubsequently. SQL Server 8 is designed with special feature of data warehousing

12.2 Why We Use PHP

1.Rich Class Framework

2.Compiled execution

3.Rich output caching

4.Web-Farm Session State

5.Enhanced Reliability

6.Easy Deployment

7.Dynamic update of running application

40