Ticket/Call Center PHP/mySQL with full permissions & reports

Closed Posted Mar 4, 2010 Paid on delivery
Closed Paid on delivery

We need a support center with multiple levels as follows:

1. An Administration where everything is accessible:

Add Retailers, change membership levels for retailers

Membership levels are based on permissions and time limits (how many months before expiring)

Add Customers to retailer accounts

Change permissions between basic, silver, and premium retailer accounts

Add Manufacturer accounts that can view only reports that pertain to their products

Add sales reps

View all tickets, reports, followups etc

2. A login for retailers and retailer sales reps:

Retailers are broken into sales reps and management, with different access for each

Add a customer account, including name, address, phone, email, sales rep, and details.

Customer details would be information about their purchase from the retailer. make, model, serial etc

Retailers can view tickets submitted by their own customers, but cannot reply or edit them in any way

Retailer sales reps get an email if their customer opens a ticket. The retailer management also gets a copy

Retailers can view stats according to their account level

A sals rep can only view their own customers and customer tickets. A manager can view all for their retailer company

If a retailer membership expires, the retailer cannot log in or receive email alerts, but their customers can still create tickets and data is still stored for the future

3. A login for Support Personnel:

Support can create a ticket for the customer, or reply to tickets made by a customer

Support can view any tickets, but only update their own

Support can pick up any ticket, but once assigned...it is theirs.

Tickets must be picked up within a time limit. Once picked up, they must be updated with a callback and a follow-up time must be set to contact the customer again.

Once a customer is entered in, five followups are automatically scheduled for a support rep.

One rep will do all five followups, so if they pick up a "sales followup", they are picking up five over the course of a year.

The support rep will be reminded of the five followups via email, and they will log in to update the followup

The five followups will be canned questions for the customer regarding their purchase.

Each followup response will be emailed to the sales rep that entered the customer in, as well as their manager

4. Customer Login

A sales rep will enter in the customer after a sale is made

The customer will receive a card (at the store) that gives their log in info as created by the sales rep

A customer can log in on the site and create a ticket, update one, or view old tickets

5. Manufacturer Login

Manufacturers can view limited information reports based on customer problems and followup data

Information can only pertain to their brand of item

For instance, top 10 likes and dislikes...top ten products and bottom 10 products

Information will be based on questions reps have asked customers

6. Sign up for Retailers

All members of the site have to be set up by admin, except retailers and customers.

Customers are signed up by retailers, but retailers can sign up via the web through a web form

Credit card payment via paypal or phone, with 4 levels of membership: trial, basic, silver, and premium

7. Hierarchy:

-Admin

-Retailers (ie: mycompany)

->Managers

--->Sales Reps

------>Customers

-Manufacturers

-Support Personnel

8. Each type of user has a different login page, although data is all pulled from the same source:

[url removed, login to view] (admin)

[url removed, login to view] (customers)

[url removed, login to view] (managers and sales reps)

[url removed, login to view] (support reps)

[url removed, login to view] (manufacturers)

9. We must be able to put this on our linux server ourselves, we will not open it up for anyone else

10. PHP & mySQL are to be used, but javascript and ajax are welcome...as well as any suggestions

CRM Customer Support MySQL Phone Support PHP

Project ID: #627056

About the project

27 proposals Remote project Active Apr 13, 2010

27 freelancers are bidding on average $2180 for this job

shore10

Hello, This looks like something we can definitely do. We have extensive experience with several Web application projects and have completed many similar projects before. We are an US-based software company wi More

$3000 USD in 30 days
(1 Review)
5.2
freddyho

Please see your PM

$1500 USD in 21 days
(3 Reviews)
3.7
group009

Hi, Please do view PMB!!!!

$2700 USD in 30 days
(1 Review)
3.0
hoaitan

Thank for your detail of project. Please view my message :)

$1600 USD in 20 days
(1 Review)
2.0
smithjohnson2503

hi,please check pm

$2250 USD in 12 days
(1 Review)
0.0
muhammadmudesir

i bid 1800$ for this project.i will complete this project in limited time of month.

$1800 USD in 30 days
(0 Reviews)
0.0
ardabulama

i'm interested in this job...

$1500 USD in 30 days
(0 Reviews)
0.0
Mulkhan

Dear sir, My past project was developing Integrated Voice Logger using VB.Net, MySQL and TAPIEx. I can demonstrated to you about my Voice Logger Project. I think it's similar to your project using PHP script. Thank More

$2050 USD in 45 days
(0 Reviews)
0.0
FaroukMohamed

Hi sir, I'm web developer since 2 years and i can do this project in phases to make sure that your work go to right way. I'm waiting you sir. Good Luck, Farouk

$2200 USD in 30 days
(0 Reviews)
0.0
akalchev

We are a team of Eastern Europe. Include AJAX and Javascript.

$1500 USD in 14 days
(0 Reviews)
0.0
toachal

Hi There, So, Lets discuss how its going to work. java will be our preferance. We need to discuss. So as you can decide the provider. Skype: agrahariachal gmail: write2achal

$2500 USD in 30 days
(0 Reviews)
0.0
ventacall

Hi. This is Joan Rivera from Ventacall. We are a full service sales and marketing company from Manila, Philippines providing businesses total market access via direct marketing, online marketing, sales and support tool More

$1500 USD in 22 days
(0 Reviews)
0.0
vicky1985

We have group of highly qualified Developers, Analyst ,Tester for the project development, they are always ready to give their 100% at lowest cost and always ready to take challenges. Why Select Us 1. We n More

$1600 USD in 40 days
(0 Reviews)
0.0
ImprosesITechn

Improses provides custom corporate solutions that improves business by delivering the objectives and goals efficiently which fit both your needs and needs of your customer. Business Intelligence * Customer Relation More

$2500 USD in 30 days
(0 Reviews)
0.0
VIVEKYM1

Please contact us to check our demo software.

$2000 USD in 45 days
(0 Reviews)
0.0
Sshram

I bid for the project. Sshram

$2800 USD in 40 days
(1 Review)
0.0
sankalp700

Please let us know when we have to start working for yr project asap

$1500 USD in 30 days
(0 Reviews)
0.0
shahharshk

Hello, I came across your requirement and found that my service will exact match your requirement. I am a PHP developer and have a good experience and also have a team of well experience PHP/Mysql developers. We tog More

$3500 USD in 60 days
(0 Reviews)
0.0
egbsystems123456

Dear Sir, We deliver efficient global operations that are tailored to meet customer's priorities. We are uniquely positioned to deliver a set of diverse set of service offerings that are customized and quality deli More

$1600 USD in 30 days
(0 Reviews)
0.0
congruent

Hi, We are a Web Design and Web Development Company. We have excellent skill in Web 2.0 Web layout design, Logo design, CI Design, Banner Design, Brochure Design and more. We have excellent skill in work on HTML, XHTML More

$2250 USD in 30 days
(2 Reviews)
5.5