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.
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
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
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.