Cancelado

Back Office Database System

I need a database designing and building. The database will store about 100,000 records, each record will have the following data:

Date

Invoice No

Invoice Name

Invoice Company

Address 1

Address 2

Town

Country

Post Code

Telephone

Email

Shipping Name

Shipping Address 1

Shipping Address 2

Shipping Town

Shipping Country

Shipping Post Code

Shipping Telephone

Amount

Discount

Shipping Cost

Total

Payment Method

Payment Notes

IP Address

Order Status

Voucher Code

Notes

Qty*

Product*

Price*

Amount*

The final four items marked * could have around of 30 items (although this is unlikely with the normal amount being about 5)

I need the ability to insert new records via a spreadsheet which I wish to upload via a web browser.

I need a frontend building for this which will give me the ability to be able to:

1) allow multi user log in

2) search the database based on any of these fields: Invoice No, Invoice Name, Post Code, Amount

3) list records by date range

3) list records by Invoice No

4) update/modify the fields from a web browser

5) send customer an email from a pre defined email template

I hope I have explained myself, but if you have any further questions please let me know.

Many Thanks

James

Habilidades: CMS, MySQL, Perl, PHP

Ver mais: web designing price list, voucher discount, update email template, thanks you notes, questions on web designing, office wish list, new template for web designing, log for shipping company, log designing, james list, customer email template, designing a database, web designing notes, notes on web designing, cost spreadsheet template, upload database, post office, office building, insert date, database system, database designing, database building 2, customer spreadsheet, back building, spreadsheet price list

Acerca do Empregador:
( 7 comentários ) Birkenhead, United Kingdom

ID do Projeto: #597951