E-commerce website

E-commerce tissuesiteIntroductionThis document consists of a despatch designed to construct an E-Commerce website for a mobile phone introduce. victimization different mannerologies this report lead let off in depth how the website was constructed and whether this project was a conquest. The website completelyows drug users give a r divulgee online for mobile phones and mobile phone accessories. The website consists of m any features, which aid the users in locating their desired item i.e. powerful analyzem engine, language translator and easy to use guided navigation menu. These features facilitate users in pin pointing the consume mathematical product they argon looking for.The website is based near a mobile phone store laid in Victoria Greater London. The store is c all in alled E prison cell Mobile and is a small PLC, which sells mobile phones and accessories. This website has been constructed for the sole purpose of helping the company expand their business t o a vast range of guests and to summation company revenue. In secern to achieve this goal there were a couple meetings that were held amid the developer (me) and the storeproprietor. During these meetings it was decided that one of the most economical ways to progress to this goal, was to create a website to reach aside to customers. This should help increase company revenue as well as, being cost businesslike given that it is non very costly to run a website, if compargond to undecideding a nonher store.An administrator account has been created, which is to be use by the storeowner. This account was created to allow simple and efficient maintenance of the website. With the use of this account the administrator has access to the whole website and faecal matter easily edit data with use of a simple GUI, no PHP experience is needed. This would be a great proceeds to the storeowner since he can very easily maintain the site. This account allows the admin to furnish more p roducts use the CSV Import Function, subjoin/edit/delete customers and/or product data and a good deal more.The payment aspect of the website is dealt by PayPal. at once a user selects an item they beseech to vitiate they atomic number 18 redirected to PayPals SSL page. It is made clear to the user that they do not need a PayPal account in order to purchase an item on the website. at a time the user is redirected to PayPals secure payment page, they can select the option to pay by direct de pip or credit card. If there are any discrepancies with payment then E electric cell cannot be held responsible and the case shall go to PayPals accounts department. psychoanalysisDuring the stage at which the PID was constructed there were a about aspects, which were overlooked. Throughout the analysis phase of this report there volition be a few stages from the PID that testament be extended, re rated and added.This project is based around a mobile phone company that does not have an online agreement. All transactions, customer enlarge and product education are stored on a database that is located on the shop floor. The constitution that is use to interact with day-to-day customers is pretty dull and lags most of the time. The dodging that is before long being used is called Metasys. This particular software package is a database formation, which stores customer and product learning. When the store gets a naked as a jaybird customer, a supply member stimulants the customers exposit manually into the database. All products are added to the database finished a Point of Sale System (POS).Now after doing a bit of research it was discovered that this company (Metasys) was no longer in business and as a result no upgrades are available for this software. To get an idea of how bad the current musical arrangement was, a few surveys were designed and given out to staff members on the shop floor (these can be seen in Appendix B). Judging by the results received from this assessment it was clear to see that a cutting system needed to be put in place. Below is a list that has been devised to show the problems with the current systemSystem often freezes when pickings down customer informationThe database can be very slow at times when accessing large amounts of dataDoes not have the latest earnest updates due to the company no longer being in businessOpening and closing the database sometimes leads to corruption of data.The system can be slow to respond to common tasks such as View Customer InfoA secondary issue that needs to be discussed is that this particular company (E Cell Mobile) would like to expand their business and reach out to a larger customer base and consequently increasing the businesses revenue. The company does not wish to open a juvenile store since this would require a large sum of money, which the organization cannot afford.This project proposes to replace this old system with a new a modern way of doing bu siness. The new system needs to be faster, easy to maintain and a lot more tried. Although the current database running on the shop floor has a lot of disadvantages there is one positive aspect that allows new mobile phones that arrive for delivery to be added to the database quickly and easily. This is the POS (Point of Sale) system currently used by the employees at E Cell.When a bunch of mobile phones arrive for delivery, a staff member uses an electronic laser to scan the measuring rod codes these are displayed on the packaging of all the mobile phones. After a particular product has been scanned it forget automatically be added to the companys database. E Cell as well receives an electronic spreadsheet from their supplier, which consists of all the items that have been delivered to them on that specific date.The point of sale system is a great method for populating information into database. It is fast, simple and requires minimal effort. In order for this project to be a s uccess it is important that this particular method for adding information to the companys database is either improved upon or unploughed the same. If for any header the POS system is removed and another system is put into place, then this new system must be able to perform tasks, which are faster and much simpler then the point of sale system.Aims ObjectivesEvery project consists of a number of goals, which need to be achieved. These goals decipher whether the project exiting be a success or a failure. A successful project would have met and accomplished each target. The main aim of this project is to create a product, which resolves the problems that are encountered by the current system.Below is a list of aims and objectives for this particular project. Some of these aims and objectives that were looked at during the project initiation stage have been changed and modified. There has been an addition of some new goals to the list. The list below has been based around, how ap palling the current system is and if a new system was to be created what would it need in order to be successful.AimsThe system should be easy to navigate aroundBuying an item should be fast and efficientThe system must be user friendlyThe system must be faster and more reliable than the old systemThe admin should be able to add/delete/edit customer and product informationObjectivesTo provide a mobile system that allows users to purchase mobile phones and accessories.Allow users to create their own customer account online.To provide an interface usable by less literate computer users.Allow users to save any transactions that have been madeProvide users with wipeing info so they can track their purchaseAs mentioned in the project initiation document this project leave take the DSDM approach. DSDM states that in order to achieve maximum business bene fit in and a fully working system that is fit for purpose one must outline the user/business requirements and aim to accomplish them a ll. DSDM uses an excellent prioritisation method called capital of the Russian Federation. This prioritisation method outlines the crucial requirements that need to be achieved in order to get a system fit for purpose. All requirements shown in the Must apply department below have to be completed in order for this project to be successful.MoSCoW PrioritizationMust Have drug users must be able to secure a mobile phone online (M1)System must contain search parameters to allow ease of use (M2)Site should be user friendly (M3)Admin should be able to add/delete/edit product and customer information (M4)POS system needs to be improved upon or left as it is (M5)Should HaveThe user is contacted via email once they have made a purchase (S1)The user can email a staff member if they have a question (S2)Could HaveGoogle Maps to display location of shop (C1)An online chat client to answer user queries (C2)Wont HaveSelling mobile tariffs (All mobile phones will be pay-as-you-go and not on cont ract) (W1)All of the requirements of the Moscow prioritization have been tagged e.g. M1, M2, S1, W1 etc. The reason they have been tagged is because they will be referred to as M1, M2, S1 etc during the executing phase of this report.RequirementsThere are certain sets of requirements that need to be achieved when creating this new system. These requirements are split into two sections, Functional and Non-Functional. These are outlined below.Functional requirements duplex transactions can be made at the same timeCustomers can add items to a shopping basketCustomers can view, edit and remove items from shopping basketCustomer is notified via email when purchase is completeNon-FunctionalGuided navigation menu makes browsing easy for the userTransactions can be completed using multiply currenciesAvailability System will be up 24/7 with minimum down timeAccessibility The system can be viewed in other languages other than EnglishRequirements TableA central list of requirements was con structed by the client, these have been listed below. Each of these requirements need to be met otherwise this project will be a failure since the final product will not be fit for purpose. The client gave a larger list of requirements (shown in Appendix D) however the requirements listed in table below is what the client has said to be mandatory prerequisites and indeed need to be completed. feasibility StudyIn the feasibility study the following areas will be looked at, project venture analysis, cost benefit analysis and stakeholder analysis.Project Risk AnalysisCost Benefit AnalysisSince this is a student project there wont be a huge budget. The software that will be used to create this product will either be freeware or already available to the developer. As a result cost will be kept to a minimal. In terms of hardware, a pc/laptop is already available since the University provides this and electrical fees/bills will also be covered by the University. If the system is to be ho sted online then these fees will be paid by E Cell Mobile although a free hosting provider will be the offshoot priority.Stakeholder AnalysisManaging stakeholders is an important factor in order for this project to be successful. Below is a list of all the stakeholders involved in this project i.e. mess that are busheled by the work that is through, who influence or have power over it or have an interest in its successful or unsuccessful conclusion.Vishal Verma (Project Manager/Developer)The developers role will be to manage the project, make sure all milestones are met and that the final product is produced within the set deadline.Jim Johnston (Client/ frequent Manager)Jim will be the first point of contact. He manages most of the staff and deals with all sales related aspects.Dean Forster (Store Manager/Company Owner)Dean is the owner of the store and will be the second point of contact.Project Method ApproachThere is one main objective, which needs to be fulfilled in order fo r this project to be a success. The new E Cell Mobile system needs to be fit for purpose. A system that is fit for purpose will ideally meet all user/business requirements of this project. Below is a quote from Harvey and Green (1993) that explains what fit for purpose actually is. step is thus judged in terms of the extent to which the product or service fits its purpose. This notion is quite remote from the idea of quality as something special, distinctive, elitist, conferring status, or onerous to attain. It is a functional definition of quality rather than an exceptional one. If something does the job it is designed for then it is a quality product or service. (p.16)Every product and service has the potential to fit its purpose and thus be a quality product or service. Fitness for purpose has emerged as the fashionable way to harness the drive for perfection. The ultimate measure of perfection, zero defects, may be excellent as a definition of quality but runs the fatal risk of being perfectly useless. If the product does not fit its purpose then its perfection is irrelevant. (p.17)This specific project will be using the DSDM approach, this is because by using the DSDM approach the project itself will be carefully planned e.g. MoSCoW, time street cornering, facilitated workshops etc. At times it can be very easy for a project manager to become unorganized especially if the project has not been planned and as result, the final results may be below satisfactory.Due to this reason MoSCoW prioritisation has been discussed earlier on in this report so that the project manager/developer and the client know what exactly the final product will contain.In meeting of minds to the management of this project, DSDM Atern will be the main forefront. This technique mainly focuses on Time, Cost and Quality.Figure 1 below (Atern Approach) states that Time, Cost, Quality is fixed and will not be changed throughout the projects life cycle, whereas features can be manipula ted since it is a variable. The traditional approach to this is the complete opposite and will be avoided since quality should never be compromised.Facilitated WorkshopsFacilitated workshops are part of the DSDM Atern development approach. Since this project uses the Atern management method it was live to incorporate the facilitated workshop technique into this project.By using an interactive environment, effective congregation dynamics and visual aids, facilitated workshops are designed to extract high quality of information in a compressed time frame in order to meet the predetermined set of deliverables.By constructing these workshops it will make it easier to achieve the targets that have been set from the beginning. The project manager will act as the facilitator and arrange these meetings. Information that maybe be discussed in the workshops is as followsWho is the target audience?How can the business reach out to customers?AdvertisingSponsorshipThe list is just a small numb er of topics that maybe be discussed during the workshops. It is vital that all the project stakeholders attend these meetings. Facilitated workshops will give the project manager an overview of what needs to be done and the time everything needs to be completed in.DesignDuring the design phase of this project there were a number of solutions that came to mind. The new system that is to be created must overcome the problems faced by the old outdated/system. Below is a list of solutions that could be apply to solve the problems discussed during the analysis phase.Rebuild the system on the shop floor. Install new database software and get faster and more reliable hardware to cater for the new database.Build a website to cater for customers, this will also have an online databaseOpen a new branch in order expand the businessTwo of the solutions shown above (Rebuilding the system and opening a new branch) just do not seem feasibly. Opening a new branch would just to be too costly and w ould require a lot more man power, effort and time which the company does not have. In terms of rebuilding the new system, the cost of installing a new database and installing new hardware was just too high and above the companys budget. The completely measurable idea was to create a website this would be cost efficient and require minimal effort.The final solution was to create an E-Commerce website. This website will be online 24/7, and as a result can be accessed by staff members anytime of the day/night. Employees will no longer need to go to the shop floor to access the database. The website will contain an administrator account that will precisely be able to be accessed by staff members. This account will give access to the companys database, which will include access to product details, customer information and any transactions that have taken place.Users will be able to go onto this website buy a mobile phone (or any mobile accessories), add the item to a basket and then p ay for it. PayPal will handle the payment system so the business will have the peace of mind that their money is safe and secure and so will the customers.The way the payment system will work is once the user has added an item to their shopping basket they will have the option to checkout. The checkout page will give the user a sketch rendering (preliminary invoice) of the transaction, this will include item description and intact price. On this page it will be made clear to the user that they will be paying via PayPal and that a PayPal account is not inevitable need in order to make a payment. Once the user accepts these conditions they will be redirected to PayPals payment page, this is where account details such as cant account number, sort code are entered. PayPal will verify this information and send out two emails. The first email will be direct to the customer verifying payment and the second email will be sent to the administrator of the site which will contain an invo ice of that particular transaction. Once payment has been confirmed by PayPal the administrator can deliver the item to the customers address.Tracking of all delivered items will be provided to all customers. There will be a Tracking section on the website which will give a detailed explanation on how customers can track their purchased products. The way the tracking system will work is once the payment has been confirmed by PayPal the administrator will post the item via Royal Mail/DHL to the customers address. Royal Mail/DHL will then provide the administrator with a tracking number. This particular number will be posted to the customer via email. The customer can then palaver Royal Mails/DHLs website (the link for this is provided in the email) and enter the transaction number to get a rough idea of when their purchased item will be arriving.Organisational BenefitsBy creating an E-Commerce website it will tackle all the problems the company is currently facing and also, it will be very cheap to run and maintain. Below is a list outlining the benefits of opening an E-Commerce store for E Cell Mobile.Expand businessInteract with a larger customer baseIncrease company revenueFaster and more reliable systemEasy to maintainSecureSoftware ToolsTo develop the website the following languages/tools/software will be usedPHP/PHP EditorThis will be used as the server side code. PHP will be used to communicate with the MySQL database.AJAXAJAX will be helpful since you can update part of a webpage without pleasing the whole content. So in this case the user can enter a search query and instead of refreshing the whole page the results for the search are shown instantlyJscript/jQueryGuided navigation menuMySQLAll customer/product data will be stored on a MySQL database.Adobe flare pass Flash player will be used on the home page in order attract the audience to the website.Swish This program will be used to create a flash video. Although this program is not freeware it i s still possible to use the 30 day trial period.phpMyAdmin By using the easy to use GUI provided by phpMyAdmin it will make it a lot easier to manage the MySQL database.CSS/HTML/XML Designing the website (Aesthetics)Adobe Photoshop Constructing the company logo immobile n Easy FTP Uploading files to the serverApache v2.5 To enable local host a web server needs to be initialised ergo Apache will be utilised.PrototypingSince this project will use an agile approach it was important to build a horizontal prototype. This allows the developer to construct the product in an iterative cycle and therefore achieving better functionality. The horizontal prototype is the man-machine interface (MMI). At first a quick sketch is drawn on a piece of paper in order to get an idea of what is to be done. To make a prototype for the E Cell Mobile system, the website www.gomockingbird.com was utilised. These prototype models can be seen on page 15 (Figure 4, 4.1, 4.2 etc)During the horizontal prototypin g surface interface software functionalities were not working but by creating a sketch (using the go mockingbird website) it allowed the developer to achieve a perception test. This helped to evaluate how easily other users could understand the interface. During the perception test users were just shown a bunch of windows and buttons, on a piece of paper. The users were then asked to explain what they understand from the information displayed before them. The results for the perceptions test can be seen in Appendix CHorizontal prototyping allows the developer to check the behavior of the interface and decipher the vital points, where usability inconsistencies are likely to appear.After completing the horizontal prototype, and in order to get a full analysis of the user interface, another set of tests was done. These tests are known as Vertical Prototyping. This helped to implement a consistent set of functionalities in order to allow the user to achieve a typical scenario of usabili ty. These tests were precisely done after the GUI was 90% complete. At this stage the prototyping consisted of a series of user tests during, which the vital points raised throughout the horizontal prototyping phase are evaluated.Usability TestThis specific test allows identifying of usability problems and analysing their cause with the users. The user is given the system and allowed to beta test it in any way they like. Solutions are elaborated and implemented during this stage of the prototype and as a result may change the final look and feel of the system. The results for this particular test can be seen in Appendix E.This test was constructed after the website was completed. If any discrepancies were found during these tests then website was modified accordingly.GUI DesignBefore the implementation phase a few cover charge designs were constructed. This gave a rough idea of how the website should be built. These screen designs were shown to a random bunch of users in order to assess the usability of the interface (Perception testing Appendix C)The customer must enter their user name password into these fields in order to login.By using the Forgot Password? link the user can input their email address which they used to register with the website, and a new password will be sent to this email address.By checking the Remember Me? check box a cookie will be added to the users internet explorer folder. This means the user will no longer need to type in their user name and password every time they visit this page.Product DetailsThese are images of the productBreadcrumb trail the user can use these links to go back and forth.This section of the page displays information regarding the product.The user can use this link to tell a friend about a product listed on this page.Necessary information such as friends name, email etc must be filled outThe information in the Captcha must be entered to verify that you are human and not a bot.A message can be written regardi ng the contents of this email.A short description of the company such as when it started and who is involved in the organisation. Contact information will also be shown in this section e.g. address, email telephone etc.Using the Google Maps API, E Cell Mobiles location will be shown on this interactive map.UML Case DiagramBelow is a case diagram for the system that is to be built. It displays two Actors, the User and the Administrator. In the middle is the system where all calculations and processes are made. The user (customer) is able to perform a number of functions, such as searching for an item they wish to buy, adding that specific item to a basket, emailing the site owner etc. The Administrator is able to perform high priority decisions such as viewing all customer transactions, removing or adding customer and product information etc.The ERM diagram shown in figure 6 displays the different types of tables that will be used in order to create the database. Each table has a dif ferent number of attributes and each attribute has its own data type. Each table has its own primal key this is a unique identifier for every table and is not repeated. Some tables include foreign keys this is a referential constraint between two tables. The entity relationships between each table can clearly be seen by the bold and dotted lines. Certain tables have a one to one relationship whereas some may have a one to zero relationship.This ERM model was constructed using MySQL Workbench. This is a freeware program provided by MySQL. Information is taken from a phpMyAdmin database and then reborn into an ERM model automatically.Below is a brief description of each table in the database.Admin UsersThis table holds details for all the administrators. Administrators are split into two categories passing User and User. An administrator classed as a super user will have full control over the website and an administrator classed as user will be able to control certain aspects of th e website.SearchThis table holds details for all search related queries posed by the user. If a user searches for orchard apple tree iPhone then this particular search request will be recorded in to this table. This is mainly for the administrator to view and analyse what the most popular search requests are. As a result the admin can cater for the users needs. For example, a large number of users search for the same mobile phone however, there is no such phone is listed in the database. The administrator can view this particular search query and cater for the users needs by adding that specific handset model to the database and thus increasing sales.BrandsThis table will hold details for all the different types of brands of mobile phones and their related images.Order SummaryOnce the user has bought a product, the details of that particular transaction will accumulate in this table. This table will hold information such as customer details, product details and the total price of th at particular sale. Towards the finalization of a transaction the customer is shown a summary page, this consists of details regarding their purchase. This information is taken from the Oder Summary table.InventoryThis table holds details of all the products in the database this will include attributes such as price, description, name etc.Order InventoryAll transactions that are made will be stored in this table.CustomerThis table holds customer details such address, phone number, postcode etc.Activity DiagramThe Activity diagram (Figure 7), displays how the new system will work. The current system works in a similar way however orders are not shipped to the customer, since the customer is already in store when making the purchase. The new system will be online and therefore when a customer makes a purchase their item will be delivered to their qualify destination. An invoice will also be sent to the customer via email.The invoice will be sent to the users registered email address. Once payment has been made through PayPal, they administrator will be notified by PayPal, via an email outlining the transaction details and confirmation of payment.Dataflow Diagram (New/Improved User Interface)The dataflow diagram below shows a brief outline of how the user interface will look like for the new E Cell Mobile system. The diagram explains some user interactions such as, the user can search or browse for a product, items can be added to a shopping basket etc. From the flowchart we can clearly see that it is not obligatory for the user to login in order to search or browse the site however, in order to purchase an item it is mandatory that all users register and login.HostingWhen building a website it is crucial to setup a web server. This can either be hosted on your own personal computer or hosting can be bought. There are a number of advantages/disadvantages for hosting online and from your pc.As the developer of this project it is important to choose the correct ho sting method so that it does not affect the development of the system. Below is a list of two hosting methods that can be used, each method has its pros and cons.LocalhostLocalhost means this computer and is donated by an IP address of 127.0.0.1. It can be used to host content to the World Wide Web. There is no charge for this since content is hosted from you own computer. In order for localhost to wor,k a web server needs to be installed. Since this website will be using a large database, MySQL and PHP also need to be installed.The two main web servers out there today are Apache and IIS. As the developer of this project it is important to decipher which one of these is the best web server to use for this project. After doing a bit of research the following results were obtained.IIS and Apache operate very differently and thus have a variety of advantages of disadvantages. IIS is designed and available to work only within the Windows environment. With IIS 6.0, the only platform curr ently supported is Windows Server 2003. Although this limits the deployment platf