North South University
Department of Electrical & Computer Engineering
Project Report
Group No: 09
Fall 2020
Project Name: E-Commerce Website (Easy-Shopify)
Course No: CSE 299 Sec: 02
Faculty: Shaikh Shawon Arefin Shimon (Sas3)
Prepared by:
Name: Mohammmad Arshadul Alam Rakib
ID: 1731487042
Email: arshadul.rakib@northsouth.edu
Git Repository: https://github.com/NSU-FA20-CSE299-2/Group09
Date Prepared: 18/01/2021
INTRODUCTION
This era is called the era of science and technology. In the last couple of years, this earth changes incredibly fast. Our country is also improving itself rapidly. E- commerce business is flourishing in Bangladesh recently. A new horizon has been opened up for business, to be specific electronic commerce (E-commerce) by the Internet. In Bangladesh, a population of 165 million with 33% mobile internet user, the E-commerce market is, by all means considerably potential in upcoming days. A bulk portion of the business at present is working under the e-commerce criteria over digital networks.
The E-commerce web application Easy-Shopify is intended to provide complete solutions for the vendor as well as customers through a single gateway using the Internet.
Easy-Shopify is a web-based e-commerce application where buyer and seller can connect with each other, and buy or sell their desired products. It will be a market place which will operate in markets of Bangladesh. Easy-Shopify will create an Internet-based marketplace where seller can lay bare their products and buyers can choose and buy their required or things which they need. It will be an excellent platform for both buyer and sellers. Easy-Shopify will introduce with a business model of selling products to customers from third-party retailers to sell their products through the site. We will add a 2-day guaranteed delivery service all around Bangladesh, will also maintain the hygiene and will make sure the product will be received totally as it is. Entrepreneurs also can use this platform. Sellers or those warehouse who use my platform for lay bare their products, have to give some percentage for using this platform. We will charge sellers or warehouses a minimum percentage on their profit.
Why Use This Website?
In the Easy-Shopify website, we will try to solve some problems of existing e-commerce website of our country like Evaly, Daraz etc.
Problem 1: Fake Products
A lot of the e-commerce websites that are present today contain many fake products and are full of scammers. Hence, buyers have a hard time distinguishing between fake products and original products.
Solution
In our website, we will make a rule for the seller to avoid this. When a seller uploads a product s/he will have to upload original photos and an unboxing video of the product.
Problem 2: Delivery Time
Delivery time is too long for most of the e-commerce sites in our country.
Solution
Most of the e-commerce sites use third party delivery system. We will control the delivery system. After getting the order, we will collect products from the seller and deliver it to the customer. We can build warehouses in the city area and can store most of the common items to reduce delivery time.
Problem 3: Return and Refund
A survey showed that 63% of American consumers check the return policy before making a purchase, the same in our country. Here return, and refund policy is not clear. Even, most of the e-commerce sites do not give refund properly.
Problem 4: Customer Loyalty
It can cost up to 5 times more to acquire a new customer than retaining an existing one. The success rate of selling to a current customer is 60-70% compared to only 5-20% Success rate of selling to a new customer, but most of the sites cannot hold up their exciting customer.
FEATURES
- Login and Registration
- Shopping Cart and Checkout Process.
- Wishlist.
- Search bar.
- Payment system.
- Category wise products showcase.
- Shipping form.
- A Review section.
- Dashboard and customer management.
FEATURE DETAILS
1. Customer
- Customer can view/search products without login.
- Customer can also add /remove a product to cart without login (if customer try to add the same product in the cart. It will add only one)
- When a customer tries to purchase a product, then he/she must log in to the system.
- After creating an account and login to the system, he/she can place an order.
- There is a payment page also.
- If the customer clicks on the pay button, then after their payment is successful, and their order will be placed.
- Customer can check their order details by clicking on orders button.
- Customer can see the order status (Pending, Confirmed, Delivered) for each order.
- Customer can download their order invoice for each order.
- Customer can send feedback to admin (without login).
2. Admin
- First admin will log in giving the username, email and password.
- After login, there is a dashboard where admin can see how many customers are registered, how many products are there for sale, how many orders placed.
- Admin can add/delete /view/edit the products.
- Admin can view/edit/delete customer details.
- Admin can view/delete orders.
- Admin can change the status of an order (order is pending, confirmed, out for delivery, delivered)
- Admin can view the feedbacks sent by customers.
3. Other Features
- Customer places order and admin deleted that user (fraud detection), then their orders will automatically be deleted.
- If the user clicks on purchase button without having products in their cart, then the website will ask to add product in the cart first.
SYSTEM DESIGN
1. Design
The system is divided into some parts like Registration system, Login system, Search system, Order system, add prouct system, view product system, order received system, sent feedback system and received feedback system with database represent the server using MYSQL, APACHE with XAMPP server.
Figure 1
2. User Characteristics
Admin The administrator has all the rights to access the system. He is the one who has all rights to view the users and product details and also modify those details. He can add products, remove products. He can also set the product price. Admin can change the customer details. He can see the order details and feedback sent by the customers. He also have the rights to delete a customer.
Users The user can log in to the system by using his specific username and password. User can view the products available and order the products according to their own needs. User can view his profile and if he want, he also can update his details by logging to the system. User can find various products by simply type the product name in the search bar and click the search option.
3. System Information
This is an E-Commerece website system through which the user can buy products, order products, search products in the quick time. It has the following advantages:
- User friendly interface
- Fast access to database
- Search facility
TECHNOLOGY
We decided to go with latest technologies for developing this application in order to give users a better experience.
HARDWARE AND SOFTWARE REQUIREMENT
1. Hardware Required
- Processor : Pentium IV or Above.
- Ram : 2GB or above.
- Hard Disk : 50GB or Above
- Input Device : Keyboard, Mouse, Touchpad
- Output Device : Monitor
2. Software Required
- Operating System : Linux, Mac, Windows XP, 7, 8, 8.1, 10
- Frontend : HTML, CSS, Bootstrap, JavaScript
- Backend : Python, MySQL
- Local host : XAMPP
FRAMEWORK
- Django
PROJECT DATABASE AND TABLE
1. Database
In the project I used the MySQL database. It is the database system used on the web. It runs on a server. It is ideal for both small and large applications. Therefore it is very fast, reliable, and easy to use. It uses the standard SQL. It compiles on a number of platforms and moreover it is free to download and use. It was developed, distributed, and supported by Oracle Corporation. In Figure 2, It shows how MySQL database works with Django framework
2. Database Design
Database is critical for all types of website. A good database doesnot allow any form of inconsistency and stores only relevant information in an ordered manner. If a database has inconsistency, it will affect the efficiency and data integrity. For example, If delete anomaly arise upon the deletion of a rown which also forces other usefull data to be lost. As such, the tables need to be normalized. This fulfils the last objective of ensuring data are accurate and retrievd correctly.
Database files are the key source of information into the system. It is the process of designing database files, which are the key source of information to the system. The files should be properly designed and planned for collection, accumulation, editing and retrieving the required information.
The organization of data in databse aims to achive three major objectives:
- Data integration
- Data integrity
- Data independence
Figure 2
3. Database Table
3.1 All Table List
Figure 3.1
3.2. Customer Table
Figure 3.2
3.3 User Table
Figure 3.3
3.4 Product Table
Figure 3.4
3.5 Feedback Table
Figure 3.5
PROJECT MODEL VIEW
1. Home Page
Figure 1.1
2. Admin Login Page
Figure 2.1
3. Admin Dashboard Page
Figure 3.1
4. Admin View Customer Page
Figure 4.1
5. Admin View Product List
Figure 5.1
6. Admin View Feedback
Figure 6.1
7. Customer Sign Up Page
Figure 7.1
8. Customer Login Page
Figure 8.1
9. Customer Home Page
Figure 9.1
10. Cart Page
Figure 10.1
11. Customer Sent Feedback Page
Figure 11.1
12. Logout Page
Figure 12.1
MONETIZATION
- We will ask the seller to pay a commission of 5% for product sold more than 100 BDT.
- Companies can place add in the website, which will cost 100 BDT per day.
- Google Adsense
QUALITY
- The UI of the application will be user friendly so that anyone can use it.
- Each and every product will be arranged in their category wise.
SOCIAL IMPACT
As we are giving opportunities to the entrepreneurs to use the platform, they are attracted to advanced technologies, and will help to reduce the unemployment problems from our society, which will lead a better economy for the country. People can use online payment easily, which is hassle-free. People can order what they need through our website while staying at home by just a few clicks. Due to Covid'19 pandemic, people cannot go outside often as it is risky so they can use the platform to buy what they need. As we will maintain hygiene while delivering a product, it will be risk-free.
FUTURE ASPECT
This project has a very vast scope in future. The project can be implement in future. It can be updated in near future and when requirement for the same arises, as it is very flexible in terms of expansion. Though I couldn't be able to complete all the proposed functionalities. But I will add the functionalities in future scope. The following are the future scope for the project.
- Category wise products showcase.
- Adding the Wishlist.
- Adding Payment system & gateway
- Finishing the Checkout Process
- Adding the Shipping form
- Adding the Third party(seller) functionalities