Project Detail

Description

We are looking to make a supplier database online I think this can be done in PHP and SQL

The idea of the database is so we can add suppliers into it and then search for an item we need in the search and it will bring up that supplier.
We would also like to give suppliers a login via a registration form and a manual create account facility the site should auto email the register login details as well as handle lost passwords.

We would like the items added to the database to be able to be stored in category and sub category.

Example
BEDS./WOOD/WHITE
The database should then show something like this
CHINA WEB www.hang.net
ITEM TITLE

WHITE WOOD BED



Description

White bed painted

packing

One bed one cardbox




Supplier

A HANG
A ROAD
CHINA

CONTACT

PHONE 111
EMAIL 000
WEB www.hang.net


I want the database to have 3 levels of login

Admin this level can create add and remove products as well as make new accounts They can make categories and sub categories
USER this level can add and remove products They can make categories and sub categories
SUPPLIER this level can only login and add their own products, however cannot view other products. They can make categories and sub categories

Also I want to be able to make request list, this list. Whereby I can add a list of products needed and qty using a add to order button and it can be passed to someone on the user level. Also I want to be able to send purchase requests from the database to the stored email of the supplier and also print to PDF supplier info and purchase requests made.

I want an easy to use system for storing information on suppliers and then be able to search it and send order requests to our office abroad.

Someone who has done something like this should be able to help with layout and usability. The login page and other areas should show our company logo the system needs to be robust and look professional it must be possible also to back up all data.

The site will be installed on a VPS and run on a subdomain.



Additional information submitted:

01/04/2009 at 12:48 EST:
Product pics also need to be stored. As well as any PDF or similar the supplier wants to upload