Mobilephone comparison website ;PHP ; Datafeeds

Dear, Project Description - Database structure/clean/filter PHP script - Webpage to display the data Part of SmartID is marketing based on COMPARISON sites/modules. This project is based on the Telecom branch. For our website audience we want to have a comparison website, this will help the user to select a phone(for the best price), select the contract he/she wants to have, and at the end order this phone+contract combination at the store which will be linked via our site(affiliate marketing.) For this project we’ve selected a couple of suppliers/stores whom give us the needed information (XML/CSV) with their phones, contract bundles etc. The selected suppliers (affiliates) are: - [login to view URL] - Belsimpel - Bestelmaar - Debitel - GSM Warenhuis - [login to view URL] - GSM Easy - HI - Phonehouse - Ritel - Studentmobiel - Telfort - Typhone - Vodafone Some of the data they’re delivering is consistent with the others, but some of the fields need to be cleaned, filtered, ordered etc. and at the end transported to a clear database format which will be the input for the front-end website. The filtered data must be displayed in the webpage on the required pages. All extracts of the CSV files are included as part of this design, this could be used as reference, and the raw data which is required for development is already inserted in the database. - Database structure (product database based on ID’s etc.) > brand, telephone type, color of phone, phone description, images etc. - A global solution in case we want to add more telephone suppliers in the future then described above - User must be able to select a phone type based on the selected brand - User must be able to select a contract bundle which is available for the selected phone type - User must be able to see in which store(merchant_name) the mobile phone is available - At the end of his/her, brand, type, contract bundle selection the user must be able to click on a link to order the phone at the related store. - The related telephone descriptions (for example the description field within the csv file from [login to view URL], this field contains most of the telephone descriptions which are needed for this project) must be showed in relation to the selected phone type( See image 1.2 how this description will be used. - The user must be able to sort the displayed data, bases on costs, call minutes, etc. - User must be able to see the best offer for his selected phone in the corner of the screen( Netto price, see Netto price chapter for the calculation of the netto phone/contracto price per month) - ALL phones/types which are available in the datafeeds need to be showed in the front-end _ SEO friendly build!( Meta tags, URL, etc.) SQL database extracts are made and are available for the programmer(FTP details will be given later) CSV files are available for the programmer(FTP details will be given later) We want a high quality php script, website and the communication must be in English! Further details are available in the Functional design document which could be send later(filesize to big to post) Regards, Arend Fekkes