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.
The database should then show something like this
CHINA WEB [url removed, login to view]
WHITE WOOD BED
White bed painted
One bed one cardbox
WEB [url removed, login to view]
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.
Product pics also need to be stored. As well as any PDF or similar the supplier wants to upload