Simple Customer Database

En curso Publicado Jan 12, 2007 Pagado a la entrega
En curso Pagado a la entrega

I need a simple customer Database that can be accessed by the office staff. this is not for customers but for internal use only.

1. It will require a web front end with secure password

2. It will not require an admin area

3. Ideally mysql should be that database back end

4. It should be designed to hold up to 5,000 unique customers

While I will provide more detailed requirements to the winning bidder, the essential idea is to track existing customers and their past orders and allow for some staff comments on each.

Data Base Fields

First Name

Last Name

Home Phone Number

Business Phone Number

Address 1

Address 2

City

Postal Code

Country

Fax

Email

Other Email

Company

Order History

Notes

Diarize for follow up date

Date of last order

Usability

Database needs to be searchable by First name, last name or phone numbers.

Ability to add notes easily

easily add or edit existing customers

One time load of customer database

Ability to sort by any field ie diarize for follow up date

abiity to export, can be handled vis mysql dmin

Procesamiento de datos

Nº del proyecto: #118556

Sobre el proyecto

16 propuestas Proyecto remoto Activo Jan 14, 2007