Database PHP SQL or Similar for product suppliers internal use !

En curso Publicado Jan 4, 2009 Pagado a la entrega
En curso Pagado a la entrega

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 [login to view URL]

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 [login to view URL]

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

JavaScript Linux Perl PHP Python

Nº del proyecto: #365338

Sobre el proyecto

16 propuestas Proyecto remoto Activo Jan 5, 2009