Đang Thực Hiện

Customer and Leads Database Website Portal

We're a mobile phone sales company and we have an online customer and leads database created by someone else on freelancer but we need some amendments made to it. I think the database is in SQL and the actual website portal is PHP. Access can be given if needed, just request through PM. Images of the website portal are attached.

The database is fully functional, we just need some changes made, list below:

• Various Fields added to records

• Various Fields removed from records

• Real time search, i.e filtered results as you type

• Front/Renewals Page - Add Postcode column and quick selection box to add X amount of months to a contract, so for example if a lead is due for renewal today but they've already signed with someone else we can just pick 'Add 24 Months' to the contract end date and it'll change the contract end date, therefore removing it from the renewals page.

• Add ability to insert customers date of birth with an automatic email sent to us every Monday with a list of birthdays within the next 7 days. Other info on the email needs to be their name, age, phone, network and address.

• Need the ability to add/attach files while entering a new lead or customer, at the minute we have to add the customer and then hit save, then go back and find the record and add the attachment, we need this all to be on 1 page. Having the addons/bolt-ons, sharers, etc on the 1 page as well

• Customer and Leads Pages - Most recently added records to be sorted to the top, eg. Mr A was added yesterday, when I add Mr B today (the most recent record) it goes to the top of the list rather than alphabetical.

• Customer and Leads Pages - Add postcode column to view

• Need some sort of system so that we can archive old information, eg. Mr X got an iPhone last year on O2, this year he's changing to Orange and he's taking a Samsung Galaxy S2, but he's keeping his same number, we need to be able to see the information from the previous contract but also be able to input the new information. Any Ideas?

• Ability to move leads to customers and vice-versa, a simple tick box at the end of the record info or something similar would do the job I'm sure.

• Customer, Leads and Mobile Pages - Drop down box to choose how many records to show per page

• Customer and Lead Records - Remove upgrade dates, add Address Line 1, Address Line 2, Town, County, Postcode

• Email every week with a reminder who is due for renewal within the next 30 days and who's overdue for renewal

• Miscellaneous visual changes

• Ability to upload records via CSV or similar

• Ability to download individual records, renewal list, custom search list, etc as CSV or similar

• Change 'User' permissions to only be able to view necessary information, ie. no financial information

Other small changes may be needed as the portal/database is changed.

Kỹ năng: AJAX, HTML, MySQL, PHP, Thiết kế trang web

Xem thêm: database leads, visual age, upload website freelancer, top website freelancer, top town freelancer, sql database website design, simple website design contract, simple mobile number change, similar pages freelancer, search website leads sales, search freelancer name, samsung website, samsung online, remove request freelancer, quick sales system, portal name ideas, portal job, pick freelancer, orange contract renewal, online sql freelancer, online job portal system, online job freelancer website, online freelancer job real, old database, o2 freelancer

Về Bên Thuê:
( 10 nhận xét ) Cookstown, United Kingdom

Mã Dự Án: #1702783

Đã trao cho:

Mindon

check the PMB please,thanks .

£200 GBP trong 4 ngày
(70 Đánh Giá)
6.3

6 freelancer đang chào giá trung bình £173 cho công việc này

gslogics123

Hi Sir, WE can do this for you. we need more details. Please check the message box for details. Thanks

£150 GBP trong 2 ngày
(228 Đánh Giá)
7.3
daxesh20

please see pm.

£250 GBP trong 7 ngày
(0 Đánh Giá)
0.0
tengfung

Have been in web development for 5 years now. Work in .net, php and jsp language with different DB such as MSSQL, MySQL, access, and oracle. So you can said i know what it takes to chunk out expected work required. Thêm

£150 GBP trong 3 ngày
(0 Đánh Giá)
0.0
narendra20200

Dear Sir/Madam, We have a Service Center Management System for Mobile Centers where you can able to track your customer complaints.It contains Call Management ,Good Inventory and Defective Inventory maintanance wit Thêm

£120 GBP trong 10 ngày
(0 Đánh Giá)
0.0
dynamicweb2012

WE are a software and web development company offering web based online applications for our clients. Our expertise lies in delivering what the client requires from us .

£170 GBP trong 10 ngày
(0 Đánh Giá)
0.0