Database Commerce Website
We require assistance in the development of a database-driven website similar in scope (though not at all related) to [url removed, login to view] This is not a commercial venture – this will be a free site for users and we are hoping it will provide a valuable and worthwhile service.
We’ll continue to use [url removed, login to view] as an example, but to re-iterate, our project has nothing to do with yachtworld or boats specifically.
At the core of the site will be a database of categories (similar to the categories page on ebay) allowing users to create “products” by selecting a number of options from these categories (i.e. new/used, sail/motor) Other users can then refine searches down a number of child-parent trees to find these “products” – adding and removing criteria to shrink/expand the results that match their search.
Location: North America > USA > Washington > Seattle.
Category: Boat > Sail > Racer >
Manufacturer: Hunter > Sloop >
Size: 40 – 50 > 44
There are two main database tables – one is the CATEGORIES or criteria that define the PRODUCTS which will be entered by the ADMIN, the other will be the PRODUCTS themselves, which are entered by users.
PRODUCTS may fit in multiple CATEGORIES – for example a boat may be both a “racer” and “cruiser”. Children within the CATEGORIES database may have more than one parent.
The database contents will eventually be significant, but data entry into the CATEGORIES will be a separate contract. Although the database contents will be very large, the database structure will remain one of simple child-parents. To that end it may ultimately contain only a few columns: ID – NAME – PARENTS – DESCRIPTION - DATE - etc
Development will need to include an optimized back-end interface for entering and editing all of this CATEGORY data. Although the database may be simple, the parent-child trees may be quite deep and contain a large number of entries, so we’ll need tools to make the data easy to manage. We will refine our requirements and provide thorough mockups of the required interface. It should be relatively simple in scope since the main data editing will ultimately revolve around grouping children and parent category data.
The site will need a typical user account management solution – including sign-up with email confirmation, etc – tools for automated password recovery, some basic tracking of user activity, etc.
In the front-end will be the functions to allow users to create/manage PRODUCTS and search tools similar to yachtworld allowing users to refine searches, save searches, etc. Some additional functions will include email notification when items are added that match a user’s saved searches – and a messaging system between users.
Although it is for a non-commercial site, we will require high quality work and a very high attention to detail. We will provide mockups of the main pages – but we need a critical thinker who will not deliver barely functioning features unless every detail is explicitly described. For example, it should go without saying that if the site uses email confirmation for the user account sign-up that the email address needs to be validated upon entry – that the password field should be duplicated to avoid typos – that the phone number field should filter out non-numeric characters, that the account should not be created until the critical fields are all filled with acceptable data, etc. We will provide the high level direction but want to work with a developer capable of insuring the fine details are not overlooked.
Once again, high level functions will include:
User Account Tools (sigh up, email confirm, password recover, account update)
Product Create/Edit Tools
Search Tools (refine by adding/removing criteria/categories, save searches)
Communication tools (ability to send messages between users, flag products for violations)
Admin tools (tools for creating/editing categories/product criteria, tools for managing user products – i.e. deleting)
Obviously we need to provide significantly more detail before work could begin, but we hope this is sufficient detail for estimates. We want to work with an experienced develop, and hope that an experienced develop can anticipate some of the smaller details in this bigger picture.
We’ll review bids and questions and may update this with more detailed requirements. If scope of the project is too large we may break it down into phases, outlining core functions as the initial contract.
To better understand the scope, please look around the aforementioned example site. Explore the search functions that allow you to shrink/expand searches for boats with a number of criteria. Consider the functions required to manage those criteria, as well as to enter the actual boats.
Thanks for your interest.
61 freelancers are bidding on average $2281 for this job
Hello, we are professional web app developer team, I have read your requirements carefully, and view the yatchworld site too, i am sure we can do a good job for you. thanks!
Hello! I can do it for You for only $2500. It will take me no longer than 7-14 days. If You choose me I will do my best to do it as soon as possible. regards Birdwatcher
Hi, we are very [url removed, login to view] have gone through with the requirements you described in your detail. We can easily do it with our [url removed, login to view] will provide you regular updates during progress, if we get this.... And als Lagi