PRODUCTS PRICE COMPARISON

AMONG E-COMMERCE SITES

Synopsis

ABHISHEK KUMAR
194708894
MCSP-060

Under Guidance of

Mr. Jayesh Solanki Associate Professor and Head LD Arts College,

Gujarat University

Submitted to the School of Computer and Information Sciences, IGNOU

in partial fulfillment of the requirements for the award of the degree of

Master of Computer Applications

(MCA) Year of Submission

Indira Gandhi National Open University

Maidan Garhi
 PROFORMA OF PROJECT PROPOSAL

SCHOOL OF COMPUTER AND INFORMATION SCIENCES IGNOU,

MAIDAN GARHI, NEW DELHI-110068
PROFORMA FOR SUGGESTIONS OF MCSP-060 PROJECT PROPOSAL

Project Proposal No: Enrolment No : 194708894

Study Centre : 0901 (LD Arts College)
Regional Centre : Ahmedabad
(For Office use only) RC Code : 09
E mail : [email protected]
Telephone No : 9531898374

1. Name of Student: Abhishek Kumar

2. Address : N-84/3 Amar Market, Sourabh Vihar, Jaitpur, New Delhi-110044

3. Title of the Project: Products Price Comparision among E- Commerce Sites

4. Name of the Guide: Mr. Jayesh Solanki

5. Address of the Guide: IGNOU REGIONAL CENTRE-AHMEDABAD

SARKHEJ-GANDHINAGAR HIGHWAY
CHHARODI AHMEDABAD – 382481

6. Educational Qualification of the Guide: MCA, Ph.D (Persuing)

7. Working/ Teaching Experience of the Guide:18 years (Head of Computer

Department Cum Associate Professorof L.D Arts Collge and programme Co-
ordinator of IGNOU.

8. Software Used in the Project: Python, Django Framework

9. If already perused BCA/BIT rom IGNOU: NO

10. Project Title of Mini Project (MCS-044) and S/W used: Payroll Mgmt System, ASP.Net

Signature of Student Signature Of Counsellor

Date Date

Suggestion for improving the project:

 INDEX

SL TOPICS Remarks
NO
01 Title of the Project Products Price Comparision among E-
Commerce Sites.
02 Introduction Para 01

03 Objectives Para 1.2

04 Project Category Information extraction and fuzzy logic

05 Scope of the Solution Para 1.3

06 Problem Definition Para 3.1

07 Requirement Specification Para 3.2

08 Project Planning and Para 3.3

Scheduling
09 Use Cases Diagram Para 3.3.2

10 Sequence Diagram Para 3.3.3

11 Activity Diagram Para 3.3.4

12 Tools and Platform used Para 3.4

13 Conceptual models Para 3.5

14 Data Dictionary Para 3.6

15 Preliminary product Para 3.7

Description
16 References Para 4.0
 PROJECT OVERVIEW

1. INTRODUCTION.

1.1 Background. Price comparison websites are becoming

more popular since Ecommerce revolution. The data and values provide
by the price comparison sites helps consumers to save money while
shopping online. The ability to check the price of products brings
convenience and saves a lot of time. Price comparison is done when the
price of the same product is compared in different outlets. There are many
online shopping sites which are being used to shop various products
online. A particular product has different prices on every different
shopping site. We need to check manually the price of the product on
every site, which causes inconvenience and consumes a lot of time. There
are many price comparisons sites which provide products comparison, but
there is no site which compares the price of wish list products.

1.2 Objectives. We have proposed a project named Wish list

Products Price comparison website which compares the prices of only
interested products which user intents to buy. This price comparison
website for wish list products will help to compare the price from various
e-commerce websites. This system has an advance feature of sending
notification when the price changes of a particular product which has been
added in the wish list. This Price comparison site is extremely helpful for
frequent online shoppers to check prices on different online stores in one
place. This system will show you the product prices from different
retailers to show you where to buy the product at affordable price.
Whenever the price of the product changes it sends notification to the
user.

1.3. Purpose and Scope.

1.3.1 Purpose. Now people like doing online shopping. There

are many different shopping sites having different prices. Price
comparison is done when the price of the same product is
compared in different outlets. There are many online shopping
sites which are being used to shop various products online. This
system has an advance feature of sending notification when the
price changes of a particular product which has been added in the
wish list. This Price comparison site is extremely helpful for
frequent online shoppers to check prices on different online stores
in one place.
 1.3.2 Scope. This price comparison website for products will
help to compare the price from various e-commerce websites, This
Price comparison site is extremely helpful for frequent online
shoppers to check prices on different online stores in one place,
This system will show you the product prices from different
retailers to show you where to buy the product at affordable price,
Any two static websites classes are analyzed to get the pricing
details, To get the pricing details, the system visits the website
based on user’s search and downloads the html search page of that
specific website, Once prices from both the websites are retrieved,
it is displayed on our website in the form of price comparison.

2. SURVEY OF TECHNOLOGIES.

2.1 Project Implementation Technology.

The Project is designed and developed in Django

Framework. We used Django Framework for coding of the project.
Created and maintained all databases into MySQL Server, in that
we create tables, write query for store data or record of project.

2.2 Overview of Django.

Python is a powerful multi-purpose programming language

created by Guido van Rossum. It has simple easy-to-use syntax,
making it the perfect language for someone trying to learn
computer programming for the first time. This is a comprehensive
guide on how to get started in Python, why you should learn it and
how you can learn it. However, if your knowledge of other
programming languages and want to quickly get started with
Python. Python is a general-purpose language. It has wide range of
applications from Web development (like: Django and Bottle),
scientific and mathematical computing (Orange, SymPy, NumPy)
to desktop graphical user Interfaces (Pygame, Panda3D). The
syntax of the language is clean and length of the code is relatively
short. It's fun to work in Python because it allows you to think
about the problem rather than focusing on the syntax.

2.3 Features of Django.

o Rapid Development
o Secure
o Scalable
o Fully loaded
 o Versatile
o Open Source
o Vast and Supported Community

3. REQUIREMENTS AND ANALYSIS.

3.1 Problem Definition.

3.1.1 Problem with current scenario. In this day and age,

when in need of a product, the majority of buyers do some online
research before making a purchase. One of the major things they
consider is the price.There are many online shopping sites which
are being used to shop various products online and with different
prices. While purchasing any product people go and look for the
same product on different sites manually, then compare price and
purchase from cheap price site.

3.1.2 Drawbacks of the existing system. Maintenance of the

system is very difficult. There is a possibility for getting inaccurate
results. User friendliness is very less. It consumes more time for
processing the task.

3.1.3 Proposed System. Considering the anomalies in the

existing system computerization of the whole activity is being
suggested after initial analysis. Proposed system is accessed by
one entity namely, User.we have proposed a project named Wish
list Products Price comparison website which compares the prices
of only interested products which user intents to buy. This price
comparison website for wish list products will help to compare the
price from various e-commerce websites. This Price comparison
site is extremely helpful for frequent online shoppers to check
prices on different online stores in one place.

3.2 Requirement Specifications. This system will show you

the product prices from different retailers to show you where to buy the
product at affordable price. Any two static websites classes are analysed
to get the pricing details. To get the pricing details, the system visits the
website based on user’s search and downloads the html search page of that
specific website. Once prices from both the websites are retrieved, it is
displayed on our website in the form of price comparison.The system
comprises of 1 major Entity as follows:

User:
 User Login: User can login in using credentials.

Search Product: User can search for the respective product for
comparison. It will also auto correct the spelling mistake.

Price Comparison: User will get the price fetch from static 2 e-
commerce websites for comparison.

Add Wish list: User can add products to wish list.

3.3 Project Planning and Scheduling.

3.3.1 Project Life Cycle. The waterfall model is a classical

model used in system development life cycle to create a system
with a linear and sequential approach. It is termed as waterfall
because the model develops systematically from one phase to
another in downward fashion. The waterfall approach does not
define the process to go back to the previous phase to handle
changes in requirement. The waterfall approach is the earliest
approach that was used for software development Gantt Chart
3.3.2 Use Case Diagram.

3.3.3 Sequence Diagram.

3.3.4 Activity Diagram.

3.4 Hardware and Software Requirements.

3.4.1 Hardware Requirement.

(a) Laptop or PC
(b) I3 processor system or higher
(c) 4 GB RAM or higher
(d) 100 GB ROM or higher

3.4.2 Software Requirement.

(a) Laptop or PC
(b) Windows 7 or higher
(c) XAMP or WAMP Server
(d) Python
(e) Django Framework
(f) MySql Database
(g) Text Editor (Notepad++ / Sublime Text)

3.4.3 Interface Requirements.

(a) Easy to follow interface

(b) Limited Graphics
(c) Message notifications

3.5 Conceptual models

3.5.1 ER Diagram
3.5.2 DFD.

Query 0.0
Product
Price
Comparison Database
User Website
Project DB

DATABASE DETAIL

1.0
Query
User Process Check for user
Request Requirement

User need

Feedback For 1.1

User Database
Relevant
Data

33.5.3 System Architecture.

3.6 Data Dictionary. A data dictionary can be defined as a
collection of metadata such as object name, data type, size,
classification, and relationships with other data assets. A data
dictionary acts as a reference guide on a dataset. Sample data
dictionary for a price comparison website includes:

(a) Product Table.

ProductID (Primary Int Unique identifier for each

Key) product.
ProductName varchar Name of the product.
CategoryID (Foreign Int Category to which the
Key) product belongs.
BrandID (Foreign Int Relates to the brand of
Key) the product.
Rating Int Average user rating.
Description varChar Description of product.
ImageURL URL to the image.

(b) Category Table.

CategoryID (Primary Int Unique identifier for

Key) each product category.
CategoryName varchar Name of the category.

(c) Brand Table.

BrandID (Primary Int Unique identifier for

Key) each brand.
BrandName varchar Name of the brand.

(d) Retailer Table.

RetailerID (Primary Int Unique identifier for

Key) each retailer.
RetailerName varchar Name of the retailer.
WebsiteURL URL URL of the retailer's
website

(e) Price Table.

PriceID (Primary Int Unique identifier for

Key) each product’s price.
ProductID (Foreign Int Relates to the product
Key) for which the price is
listed..
RetailerID (Foreign Int Relates to the retailer to
Key) which the product
belongs.
Price Currency The currency in which
 the price is listed.
Currency Int Average user rating for
the product.
Availability varChar Indicates whether the
product is currently
available at the retailer.
LastUpdated Timestamp when the
price information was
last updated.

(f) User Table structure.

user_id (PK) int Id of the user

user_name varchar Enter the name of the user
user_password varchar Enter the password of the user
User_Gender varchar Enter the Gender of the user
User_Mobile varchar Enter the Mobile No of the user
User_Address varchar Enter the Address of the user

(g) Product Table Structure.

Product_id (PK) int Id of the product

Product_name varchar Enter the name of the product
Product_price int The price of the product
Product-Cat varchar Catgory of the product
Product_qty int The price of the product

(h) Validation Criteria.

1. In each form, no field which is not null able should be

left blank.
2. All numeric fields should be checked for non-numeric
values.
3. Text fields like names should not contain any numeric
characters.
4. All primary keys should be automatically generated to
prevent the user from entering any existing key.
5. Use of error handling for each Save, Edit, delete and
other important operations.
6. Whenever the user Tabs out or Enter from a text box, the
data should be validated and if it is invalid, focus should
again be sent to the text box with proper message.

(j) Functions Description.

Login () Ask for Credentials.

Validation () Validate credentials with database.
Search () Search for particular product.
Acknowledge () Acknowledge the matching of data with
 inputs during password validation and
product search.
Wish list () To add items for price comparison.
Logout () End of session and returning back to
homepage.

(k) Business Constraints.

ProductID Each product has unique ID.

ProductName Name of the products can be same..
CategoryID Category ID is unique however multiple products
may have similar categories.
BrandID Each Brand has a unique ID.
Rating Rating value will be in range 0 to 5.
Image Support JPG, JPEG and PNG.
Retailer Each Retailer will have a unique ID.
Currency Currency will be in Rupees only.

3.7 Preliminary Product Description (For representational purpose

only).

 This system will show you the product prices from

different retailers to show you where to buy the product at
affordable price.

 Any two static websites classes are analysed to get the

pricing details.

 To get the pricing details, the system visits the website

based on user’s search and downloads the html search page of that
specific website.

 Once prices from both the websites are retrieved, it is

displayed on our website in the form of price comparison.
4. References.

(a) Code with harry Python Course YouTube.

(b) Python Projects - Beginner to Advanced - GeeksforGeeks

(c) Core Python programming By Dr Nageswar Rao

(d) Elements of Project Development Reference Book by IGNOU.

(e) https ://www.academia.edu.