THE DESIGN AND IMPLEMENTATION OF ANE-COMMERCE SITE AMaster’s ProjectPresentedtoDepartmentof Computer and Information SciencesSUNYPolytechnic InstituteUtica,New YorkInPartial Fulfilment of the requirements for the Master of Science DegreeByNarendharReddy Malgireddy(U00290594)December2017 THE DESIGN AND IMPLEMENTATION OF ANE-COMMERCE SITEMaster of Science project in Computerand Information SciencesDepartment of Computer SciencesSUNY Polytechnic Institute Approved and recommended for acceptance asa project in partial fulfillment of the requirements for the degree of Masterof Science in Computer and Information Sciences Date Chen-Fu Chiang,Ph. D. (Adviser) Jorge Novillo, Ph. D. THE DESIGN AND IMPLEMENTATION OF ANE-COMMERCE SITE DeclarationIdeclare that this project is my own work and has not been submitted in any formfor another degree or diploma at any university or other institute of tertiaryeducation. Information derived from the published and unpublished work ofothers has been acknowledged in the text and a list of references is given.
NarendharReddy Malgireddy Abstract The Main goal of the ecommerce website is to sell goodsand services online. There are a lot advantages for taking conventionalbusiness online, this involves eliminating the geographical limitation, gainingnew customers to your business with use of digital marketing, low cost maintenance.Converting a retail stone online need a proper plan and involves basic understatingin a lot of technologies.
Themain idea of this project is to create a ecommerce website and creating an easyinterface for retailer to take his business online. creating a ecommercerequire understanding and studying a lot of technologies. These includefrontend coding language like html, ROR, database query language like SQL andbackend or server-side scripting language like php, java script. The basicobjective of the ecommerce website is to run a full-fledged website wherecustomer can buy the items or services by making the payments online. In thisreport I will go through the working of the ecom website and thee technologiesused in implementing it Contents Introduction. 5 Technologies involved: 6 Html 6 PHP: 7 My SQL.
7 Project design. 8 Functional Decomposition Diagram.. 8 Database. 10 User interface: 12 Integrating website and database: 18 Functional Features.
19 Features of a good ecommerce website. 19 Features included in this website and their functionality. 19 PHP Impact Nominal Index configuration for mail 20 References: 21 IntroductionE-commerce is fastgaining widely used business model for taking conventional stores online. Moreand more business around the world are moving their business online. It isreasonable to say that the process of shopping on the web is becomingcommonplace. The basic objective of the ecommerce website is to run afull-fledged website where customer can buy the items or services by making thepayments online without physical interaction between the vendor and thecustomer.
The customer can make a purchase over the internet without losing thecomfort of home. An online store is a virtual store on the Internet wherecustomers can browse the products they are interested in and the customer canbuy thy those products by adding them to cart. At checkout time, customer canbuy those products by making the payment online. Once the payment is successfulthey vendor will then ship those brought products to customer at the addressprovided by customer during checkout, the customer needs to fill or select abilling address, a shipping address, a shipping option, and payment informationsuch as credit card number. A notification will be sent to customer and the vendorabout the order details after the successful checkout. Technologies involved:For the development ofthis website mainly four technologies are used. HtmlHtml is the markuplanguage for creating websites.HTML is thestandard markup language for creating Web pages.
HTML stands for Hyper Text Markup Language. HTML describes the structure of Web pages using markup. HTML elements are the buildingblocks of HTML pages. HTML elements are represented bytags.HTML is basically known as interface between internet and web browser. Theweb browser reads the markup tags and present as website, most browser allowusers to view the HTML code for the page we are viewing. All websites will havecertain markup tags that are used to pass information to web browser. Themarkup tags are surrounded by angled brackets.
Html acts as Skelton forall the website we see. It gives structure to the websites.PHP:PHP (recursiveacronym for PHP: HypertextPreprocessor) is a widely-used open source general-purpose scriptinglanguage that is especially suited for web development and can be embedded intoHTML.PHP can be used with html to process the post and get query’s. PHP code isexecuted on server to get the results or to post the data on database. Afterexecuting the php code on server, results will be returned to client withoutclient knowing the underlying code of phpPHP is widely usedserver-side language which is used to create shell applications through commandlines. It is used in this project as interface between database and website.
PHP takes the value from HTML and dynamically either stores the data to tablesor change the content of the page accordingly. PHP can also be used toauthenticate the data entered on the webpage like forms, email id’s. My SQL In this project, MySQL isused as the database query language. MySQL is an opensource database managementsystem. Th features of MySQL are MySQL is a relationaldatabase management system. In relational database data is stored in tables andeach table consists of distinct keys which are used to access the data calledprimary keys, primary keys with foreign keys are used to access data across allthe tables.
During the creating or specifying the tables primary keys andforeign keys should be specified. It is fast, reliable and easy to use. Toimprove the performance, MySQL is multithreaded database engine. Amultithreaded application performs many tasks parallelly using multiplethreads, each thread performing different tasks Project design Functional Decomposition DiagramFunctional decompositionis a process of starting at higher level and diving into smaller and smallerentities like top down approach.
It is a business analysis technique used forbreaking down the business operations into functions. The Functional Decomposingdiagram of e-commerce website is shown below. Database Admins SNO NAME TYPE DESCRIPTION 1 User_id int Primary key for Admin table 2 User_email varchar 3 User_pass varchar Brands SNO NAME TYPE DESCRIPTION 1 brand_id int Primary key and AI 2 Brand_title text Cart SNO NAME TYPE DESCRIPTION 1 P_id Int Prmary key and AI 2 Ip_add Varchar Used in identifying and authenticating user 3 Qty int Categories SNO NAME TYPE DESCRIPTION 1 Cat_id Int Primary key and AI 2 Cat_titile text Customers SNO NAME TYPE DESCRIPTION 1 Customer_id Int Primary key and AI 2 Customer_ip Varchar 3 Customer_name Text 4 Customer_email Varchar 5 Customer_pass Varchar 6 Customer_country Text 7 Customer_city Text 8 Customer_contact Varchar 9 Customer_address Text 10 Customer_image Text Orders SNO NAME TYPE DESCRIPTION 1 Order_id Int Primay key and AI 2 P_id Int 3 C_id Int 4 Qty Int 5 Invoice_no Int 6 Order_date Timestamp Current timestamp 7 Status Text Processing on default Payments SNO NAME TYPE DESCIPTION 1 Payment_id Int Primary key and AI 2 Amount Int 3 Customer_id Int 4 Product_id Int 5 Trx_id Int 6 Currency Text Products SNO NAME TYPE DESCRIPTION 1 Product_id Int Primary key and AI 2 Product_cat Int 3 Product_brand Int 4 Product_title Varchar 5 Product_price Int 6 Product_desc Text 7 Product_image Text 8 Product_keywords Text User interface: HomePage On the home page products are displayedrandomly using the rand function.
Customers can easily add the productsdisplayed on hoe page to the crat using add to cart bottom provided below theproduct. If the customer is logged in, his email and cart stored for thatcustomer ill be displayed at the top right corner. Customer can directly login/logout and canjump to the shopping cart directly from the home page. RegisterUsing this register page customers canregister a new account. Customer won’t be able to access cart without beinglogged in. After the completion of registration an email notification will besent to the email provided with his/her login details.
LoginWebsite prompts for login details once thecustomer try to access the cart. If customer doesn’t have login details he/shecan register for one using the register hyper link provided below. If thecustomer forgot his/her login details they can use the forgot password link toretrieve their login details. An email will be sent to customer with his/herlogin details. AdminPanelAdmin panel is the area where the vendorcan edit or access his inventory. Vendor can easily access his inventory andcan edit the without any prior knowledge on sql database.
It provides simpleinterface for vendor to add / delete new products, categories and can updatethe order status for the customer. Using the admin panel vendor can access theorders and payment details. To access the admin panel, vendor needs to loginusing the admin login details provided. Customerhome page After logged in customer can access hisorders page and can view the status of his past orders. On the customer homepage his email and image will be displayed. Customer can edit or delete hisprofile using the edit account link provided at the right side of the page. Customercan change his password using the change password link. Myorders Using my orders page customer can trackthe status of his past orders, in future new column with tracking details canbe added to this table where customer can track them directly from the orders page.
AddProductsVendor can access the admin content afterlogged in as admin. From here vendor can add new products using the form below,he/she should specify the category and brand for the product. Using the admincontent, vendor can edit all the available brands, categories and can add newones. The admin menu acts as aninterface between database and the vendor. User can manage the ecom websitewithout any prior knowledge in any of the languages used. PaymentFor now, payments are processed only usingthe PayPal sandbox test accounts.
We can test the working by making paymentsusing the PayPal gateway. After the completion of the transaction paymentsuccess or payment failure page will be redirected. If payment is successful,the order details and the transaction details will be stored in databases whereuser and vendor can access them using their accounts menu .
Integrating website and database:The use of integrating adatabase to a dynamic webpage is to allow customers to get information andproducts available from the vendor dynamically. Customer enquiries and paymentinfo will b stored n database and the vendor can track them with the help ofintegrated database. It lets the vendor to edit or update all the information andproducts/services available according to the availability. A well-organizeddatabase will help in maintaining the ecommerce website, in a static Webpage,content will be same as specified during crating the static webpages.
Thecontent won’t change unless the static webpage is programmed and edited again. whereas in a dynamic Web page, content is displayed from the data stored in database,the vendor can add or remove data dynamically and the webpage displays the dataaccordingly. We use the term “data-based Web pages” to refer to dynamic Webpages. The data displays varying from the requests the user makes or thebuttons clicked like submit button or category button.
If the user wants to viewthe product inventory, user needs to click that specific input button. Once therequest is made the php script will request the inventory query from thedatabase and the data is listed accordingly. All the requests are transformedinto data base query’s in dynamic websites If the user clicks the form submitbutton a specific query is created for storing that data or returning thespecific value user requested like true, false or 1,0. For example, IF the usermakes a purchase and completes the transaction the order will be sent to thedata base in query form and stored in tables for future use. Whenever a queryis made data is sent to the client browser with html tags.Functional FeaturesFeatures of a good ecommerce website A good e-commerce siteshould have the following features for better navigation: ·notifying when anitem was saved to the shopping cart. ·Returning to the previous page afteradding an item to the shopping cart. ·Easy scanning and selecting items in alist.
·Effective categorical organization of products. ·Simple navigation fromhome page to information and order links for specific products. ·Obviousshopping links or buttons. ·Minimal and effective security notifications ormessages. ·Consistent layout of product information.
Features included in this website and theirfunctionality· Provides simple interface for the retailerto easily scan the products he wants to add to his inventory.· Once the customer signup or make apurchase email notification will be sent to both retailer and the customer.· Customer can add second layer ofauthentication for secure browsing.· Basic web layout with easily visible add tocart button and details. provides ack or feedback on how many products are in thecart and the total price.· Only authenticated customer can post thereview. After making a purchase an email with order details and review formwill be sent to customer to post the review. This decrease the possibility ofposting fake reviews by the vendor to boost his product sales, but it is onlygood for e-commerce that sells the third-party products.
PHPImpact Nominal Index configuration for mail For using the mailfeatures available on the website php.ini file needs to be configures properly.For mail configuration go to the section mail function under this configurethe smtp server and port numbers according to the hosting server or private domain.For example, to configure the mail function for Gmail, the smtp server issmtp.gmsil.com and default port will be 25.
After specifying the smtp serverand port number, user authentication details need to be specified.Samplemail function smtp_server= mail.example.comsmtp_port = 25auth_username= [email protected]_password= example_password ReviewSystem Review system plays mainrole in an e-commerce website development. According to various surveyconducted by Advances in Economics and Business more than 85.57 % believe the reviewsand ratings of the products posed under the product and 83.65 read and comparegood and bad reviews before making a purchase.
But unfortunately, most vendorshire some advertising companies to post good reviews and ratings to the productspresenting as customers they are selling. Most E-commerce website adminsimplemented different strategies to prevent from posting the fake reviews. Forthis E-commerce website the only way to post the product is to fill the formthat was sent to the customer after making the purchase. The customers can fillout the email form that is sent with the delivered mail and when the product isreturned the reason for return will be added to review system that are postedunder negative’s.
References:1. Larry Ullman.(2003) PHP andMySQL for Dynamic Web Sites: Visual QuickPro Guide2. Kevin Yank.(2012) PHP &MySQL: Novice to Ninja3.
Wiley, Y. M. J.
& Sons.(1997) Creating the Virtual Store: Taking Your Web Site from Browsing to Buying4. Kevin Yank.(2012) PHP &MySQL: Novice to Ninja5. Lynn Beighley and Morrison(1999) Head First & MySQL6. https://www.
w3schools.com/php/7. https://stackoverflow.com8. https://www.x-cart.