Database Developer for Wordpress site

CANCELLED
Bids
16
Avg Bid (USD)
$238
Project Budget (USD)
$30 - $250

Project Description:
We are looking for a programmer to create an add-on to our WordPress installation. We have an existing theme and just want to add the following front-end pages to it.

The add-on is a product review tool, where we manage companies, products, and reviews.

The set-up should be optimized for a large amount of reviews. Please describe how you are going to accomplish this.

Database Table Requirements:

- Companies (Name, description, website, address, etc.)
- Products (Category, Name, Description, etc.)
- Reviews (User (or anonymous), Company, Product, Feedback, Rating (0-5), etc.)
- User (Name, Email, etc.)

PLEASE NOTE: Later a pricing table will be added to store the pricing algorithm for each product. This is NOT part of this project but needs to be considered when setting up this database. Ideally, we will ask the contractor who created the initial database to add the pricing extension.

Front-end:

Company overview page:
List of all companies with company details (Name, website, etc.) and list of products, ranked by average ranking of all products a company has (no rating is collected on company level)

Product overview page (1 for each product):
List of all companies offering a product with company details, ranked by average review of particular product

Product detail page (1 for each company product):
Description of product for company with aggregate ranking and individual reviews listed below

Company detail page (1 for each company):
Description of company with company details and aggregate reviews, listing of all products of company

Review page:
Allows users to provide feedback, either as registered user (with confirmed email address) or by just providing name, email, etc.
Steps are: Select Company – Select Product – Enter Feedback (Captcha verification) – Submit


Back-end:
Access to database using plug-in like Custom-Tables is sufficient


Please apply with similar projects and a description of how you are going to accomplish this, especially in terms of large amount/high volume of reviews.

Any questions, please ask before submitting an offer.

Skills required:
MySQL, Wordpress
Hire internetjobs2011
Project posted by:
internetjobs2011 United States
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.