Closed

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:

[url removed, login to view]

Example of backend:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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:

[url removed, login to view]

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: Automotive, Data Entry, MySQL, PHP, Website Design

See more: parts admin, car parts database example, bulb w5w cross reference, administration panel, car parts database, write templates, restrictions, start php programmer, web templates buy, websites templates free, websites template free, websites free templates, websites created free, website models templates, website buy programmer, web panel templates, web pages templates free, web pages templates buy, web page design models, web page data entry, web master develop, web html template free

About the Employer:
( 2 reviews ) Gilbert, United States

Project ID: #600511

48 freelancers are bidding on average $788 for this job

lightcresent

We are expert in doing this sort of stuff... No upfront needed, all payments through GAF escrow.. Online 16 Hours a day, Can start right away.. Thanks

$1850 USD in 30 days
(530 Reviews)
9.0
krishdts

please check PMB for details.

$600 USD in 20 days
(91 Reviews)
8.5
webexpertz

Dear Sir, I am interested in your project and can be done with your 100% satisfaction. I request you to check your PM for our quality work. Progress Report Weekly + Dedicated Team + You can reach team Via Email, Yahoo, More

$3000 USD in 60 days
(169 Reviews)
8.5
USAGraphicPR0

**************************************************************************.. YOUR SEARCH ENDS HERE .. **************************************************************************** GET IT DONE RIGHT THE FIRST TIME! Hello More

$2000 USD in 45 days
(122 Reviews)
8.1
buraqtech

Check your PMB for details!!!

$750 USD in 12 days
(74 Reviews)
7.8
websree

We have reviewed your project requirements and we are ready to do it. Please check pmb for more details.

$750 USD in 15 days
(195 Reviews)
7.7
WSTIBS

we can provide quality solution with time base completion. ******* Check PM ******** Thanks

$700 USD in 15 days
(100 Reviews)
7.3
aalogic

Please check PM for details. Thanks

$600 USD in 30 days
(84 Reviews)
6.8
mitrasubir

Hi, Please check PMB for details. Thanks KD

$750 USD in 21 days
(50 Reviews)
6.7
websoftinfo

Hi, we are very interested.we have gone through with the requirements you described in your detail. We can easily do it with our expertise.we will provide you regular updates during progress, if we get this.... And als More

$750 USD in 25 days
(75 Reviews)
6.6
shmai

have a glance at PM. Regards,

$750 USD in 15 days
(84 Reviews)
6.6
mayureshgoyal

Plz check details....in pmb..

$1000 USD in 45 days
(49 Reviews)
6.2
himanshusofttech

Hi, Ready to start. Thanks Himanshusofttech Team

$675 USD in 15 days
(76 Reviews)
6.2
PHPsoldier

Dear Sir, osCommerce expert here. Please take a look at my reviews. I'm available anytime. Thanks...

$250 USD in 15 days
(53 Reviews)
5.7
phpcluster

We are ready to execute your project as per your requirements within the given time frame. We have already completed several big (large-scale) projects for our clients & they are performing well. We believe in Quality More

$750 USD in 25 days
(17 Reviews)
5.6
lastguru

Greetings.. we have proven again and again our ability to develop quality products on-time and on-budget without sacrificing quality. there will not be any communication gap. Waiting excited to hear and interact wi More

$800 USD in 25 days
(12 Reviews)
5.5
mxicoders

Thank you very much for reading our proposal at GetaFreelancer.com If you are interested please write PM , We have demo or mockup for you We are specialized for web-design and development using HTML, XML, JavaScript, More

$600 USD in 21 days
(12 Reviews)
5.3
VirtualHorizon

Dear Project Owner, Please look at the PM for our bid details. Warm regards Team Virtual Horizon.

$600 USD in 20 days
(20 Reviews)
4.9
KrithVenkat

Hello Please see PM for details Thanks

$600 USD in 20 days
(9 Reviews)
4.7
exoticsolutions

Sir, We are willing to work on this project with you. We understood the requirements, accept the terms and willing to start immediately. Best Regards, Bryan Raymond

$3500 USD in 60 days
(5 Reviews)
4.6