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

CLOSED
Bids
48
Avg Bid (USD)
$788
Project Budget (USD)
$250 - $750

Project Description:
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:

http://superbrightbulbs.com/bulb_list.htm

Example of backend:

http://webdesignerhoster.com/carinfo/admin/loginhistory.php

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:

http://www.carinfotech.com/admin.htm

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:

http://www.carinfotech.com/part_categories.htm

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:

http://www.carinfotech.com/makes.htm

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:

http://www.carinfotech.com/models.htm

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:

http://www.carinfotech.com/part_location_names.htm

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:

http://www.carinfotech.com/templates.htm

http://www.carinfotech.com/acura_light_bulb_template_1.htm

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:

http://www.carinfotech.com/master_parts_list.htm

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:

http://www.carinfotech.com/master_part_lists.htm

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:

http://www.carinfotech.com/banner_ads.htm

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:

http://www.carinfotech.com/configuration.htm

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.

Skills required:
Automotive, Data Entry, MySQL, PHP, Website Design
Additional Files: Scope+of+Work+1+28+2010.doc
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1850
in 30 days
$ 600
in 20 days
$ 3000
in 60 days
$ 2000
in 45 days
$ 750
in 12 days
$ 750
in 15 days
$ 700
in 15 days
$ 600
in 30 days
$ 750
in 21 days
Hire websoftinfo
$ 750
in 25 days