Car Parts Admin. Panel, Database & Data Entry (Phase I)

Scope of Work- Auto Bulb Parts Selection Site Date: 1/28/2010 Revision: - Summary of overall Goals: Develop a new website that incorporates vehicle parts reference data for each model year, model and make. 1. This website will allow users to look up a list of parts for their vehicle by selecting as follows: 1. Part Category 2. Make and Model Year 3. Model The parts categories will be selectable. 2. After these selections are made, a list of the correct parts for that combination of Part Category, Make, Model Year and Model will be displayed using a graphic image. 3. Each page will display frames to allow the administrator to display links to other pages and banner advertisements. The main data frame showing the search results will be static, but the administrator can change and update the frames by changing a single file. Other frames will be dynamic and display up to 10 banner advertisements that appear randomly from a master list that is controlled by the administrator. 4. IMPORTANT: ** All webpages pages must appear in HTML format so that they can be crawled by the search engines for content. 5. The initial phases (Phase I, II and III) of the project will only set up the Automotive Light Bulbs Data. This scope shall set up the framework to look up other part categories, but it will not populate the data for other part categories, such as Automotive Oil Filters, etc… The initial bid (Phase I) shall only include work on the back-end. This includes the MYSQL data base, the Administration Panel (AP) interface for data entry and populating all of the data for model year 2007. Phase II and III shall be separate projects and may be bid on after the completion of phase I. Phase II shall be to complete the front end. The front end will allow visitors to the site to enter their vehicle Part Category, Make, Model Year and Model. A page will then be displayed to show all of the parts for their vehicle. Phase III shall be to lookup and enter all data for the remaining light bulbs used in all models and makes for 1950-2006 and 2008-2010 model years. 6. Phase I of the project shall require an elegant use of various forms of data entry to make the entry, editing and display of data easy and quick 7. Data accuracy for this phase III of this project is extremely important. Extra emphasis must be placed to assure that the data that is looked up accurately and translated into the new website thoroughly and precisely. Overview: Administration Panel (AP) The back-end shall consist of an Administration Panel (AP) that will serve as the interface to enter, edit and view all of the data. The data entered from the AP shall be stored in an SQL database. Phase I of the project shall be to develop the AP interface, SQL database and enter all data for the 2007 model year (to prove functionality). ***IMPORTANT: This posting is for PHASE I (The Backend) only of the project, so bid accordingly. Example of the front-end: [login to view URL] Example of backend: [login to view URL] Phase I Scope of Work Phase I shall create the AP and database where the administrator can create and edit the database and data. i. LOGIN The initial AP page shall be a login page. The login page shall be username and password protected and allow for standard username and password retrieval. Example: [login to view URL] ii. Part Categories. The Part Category page will allow the administrator to add, edit or delete any number of Part Categories as follows: A. Automotive Light Bulbs B. Automotive Oil Filters C. Automotive Air Filters D. Etc… Example: [login to view URL] This list of Part Categories shall be a simple page that can be updated easily from the administration panel. Any number of Part Categories can be created, edited, or deleted from the administration panel. iii. Makes. Example: [login to view URL] The Makes page shall allow the administrator to create, edit or delete any number of vehicle Makes. It shall also allow the administrator to load and associate a graphic image (Logo) for each Make. iv. Models. Example: [login to view URL] The models page shall prompt the administrator to select a Make. After a Make is selected, a new page shall display to allow the administrator to add, edit or delete any number of vehicle Models for the selected Make. For each Model, the administrator shall be able to select or edit a range of Model Years for that Model. The model years shall be selectable from a drop down list using the control/shift keys. The model year shall be selectable from 1950 thru 2050: Example: The page shall be dynamic so that when the Make is changed the lower display shall dynamically change to show the current list of Models for the Make selected. v. Part Location Names Example: [login to view URL] The Part Location Names page shall prompt the administrator to select a Part Category. After a Part Category is selected, the administrator shall be able to add, edit or delete any number of Part Location Names for that Part Category. These Part Location Names shall be always be displayed in alphabetical order. The page shall be dynamic so that when the part category is changed the lower display shall dynamically change to show the current list of part location names for the category selected. vi. Templates Example: [login to view URL] [login to view URL] The Templates page shall prompt the administrator to select a Part Category. After a Part Category is selected, the page shall display all of the Part Location Names for that Part Category as defined above. The administrator shall be able to add, edit or delete a Part Number for each Part Location Name. This grouping of Part Locations Names and Part Numbers shall be stored as a template to aid data entry later. vii. Master Parts List Example: [login to view URL] The Master Parts List page shall prompt the administrator to select a Part Category. After a Part Category is selected, the page shall display the Master Parts List. The Master Parts List shall consist of the entire population of Part Numbers and associated fields for each Part Category. Each Part Number in the Master Parts List shall consist of 9 fields of information. The 9 fields shall be as follows: Part No. Image 1 (Click on Image to Zoom) Part Image 1 (Alt Tag) Image 2 (Click on Image to Zoom) Part Image 2 1 (Alt Tag) Common Part Number & Description Cross Reference Part Numbers Spec. Link Buy Link 168 alt= "168 W5W Light Bulb" alt= "168 W5W Light Bulb" From the Master Parts List page, the administrator shall be able to add, edit or delete any number of Part Numbers and the associated data for each field. In order to aid data entry and improve graphic display, the text boxes shall be dynamic to allow the text box to open for editing and then appear as text for display on the same page. This shall be done either using a mouse click or by hovering the mouse over the data. viii. Master Part Lists (Not to be confused with Master Parts List) Example: [login to view URL] The Master Part List page shall prompt the administrator to select a Part Category, Make, Model and Model Year. After these are selected, the page shall display the Master Part List for that Part Category, Make, Model and Model Year. The Master Part List shall be used to associate a specific Part Number for each Part Location Name based on Part Category, Make, Model and Model Year selected. From the Master Part Lists page, the administrator shall be able to add, edit or delete any number of Part Numbers for the Part Category, Make, Model and Model Year selected. Alternatively, the administrator shall be able to automatically populate the part number fields with the part number from any of the Templates (as defined earlier), by simply selecting the desired template from a drop down menu and clinking on the Pre-Populate Now button. After each Part Number is displayed and entered next to the associated Part Location Name, the administer can save or overwrite the existing data by clicking the Update Button. IMPORTANT: The page shall be dynamic so that the page will update automatically as the user enters the Category, Make, Model and Year. Both the drop down boxes and the lower display shall update dynamically as each selection is made. ix. Manage Banner Ads Example: [login to view URL] A page shall be created to allow the administrator to manage banner advertisement that shall be displayed in the front end when the website is completed in Phase III. x. Configuration A configuration page shall be set up to configure the back end and front end with basic information. Example: [login to view URL] Additional requirements: The Service SP (SP) shall be responsible to provide the CL (CL) the following: Software to accomplish the following tasks: 1. Code for each of the web pages as defined in the Overview section. 2. Software for the AP as described in the Overview section. 3. Populate the automotive bulb sections with data using the data source provided by the CL site as a reference. The software will be provided so that it is easily transferable to any hosting service and can be transferred anytime with no restrictions. Confidentiality Agreement: The software and all data be provided to the CL and become the sole property of the CL. In order to complete the project the CL must give the SP certain data The SP must assure that CL that the software and data provided and generated shall not be sold of offered to any other CL. The data to be provided is considered proprietary, and is the sole possession of the CL. The CCES will not require any licensing agreements, monthly fees or copy write protections applied. The SP shall provide any consulting service required to assure that the CCES is functioning on the SP’s hosting service. The SP shall identify all files and directories required to be transferred so that the CL is able to transfer, backup, restore or propagate the required CCES and all customer and order data to allow any hosted server to function using this software. The SP shall provide support and training to the CL on how to propagate, backup and transfer the CCES and all customer and order data to each of the CL’s hosted servers for use on each of the CL’s websites. The SP agrees to provide free technical support for one year after completion of the project. This project shall consist of phase I only: Phase I: Complete software and AP including full data population for all light bulbs used in all models and makes for 2007 model year only. Payment terms and milestones for Phase I: 50% escrow to GAF to start project. 50% payment released upon demonstration of all software, and functionality of the administration panel on the SP’s server. 25% payment released upon demonstration of all, data entry for model year 2007 accuracy verification and functionality on the SP’s server. 25% payment released upon demonstration of all software and functionality on the CL’s server. Note: I reserve the right to and will cancel the project and start over with a new programmer if it is not completed per the above scope of work within 60 days from start. Please do not bid if you are unable to, or do not intend to complete the project in a timely manner. All payment milestones are non-negotiable, so please do not bid of you do not agree to the payment schedule. I dedicate myself 100% to be available as much as needed to provide timely feedback, and answer all questions within 12 hours. Please return this courtesy.