web based ticket system

I have had a very busy year selling spare parts from our website but the every day issue is calls and emails of "hello ive got a yellow machine do you sell the wheel, hose, pump etc)

I need a browser based ticket system and so had a look online and most are geared for IT support

ie :

Web Help Desk

Powerful Service Management Software - by unipress

function :

[url removed, login to view]

screenshot :

[url removed, login to view]

none of them fully do what I need so I am thinking about bespoke….

my idea is :

1- web form to database with ajax fields for MAKE, MODEL (from our existing tables) and partcode, serial number and year then contact data - name, company, land line , mobile, email and postcode

2 the form will create a line in a table with a unique ticket ID - the same table can be updated from a secure login USER webpage for telesales operators.

3 our staff / users will login and view tickets and assign them to themselves for sales processing they should be able to reply to the ticket from the webpage by webmail and log the emails and calls related to the ticket in the interface.

4 a searchable knowledge-base will be created from the communications based on the MAKE _ MODEL data fields

5 a table stores customer data and another stores machine data - more than one machine can be related to a customer.

the next bit im not sure about……………

6 if the customer wants to buy then we don’t want to have to request all the contact data again - one idea is a SQL trigger that creates a record in our accounts-sales-order table if you press a "create account" button in our secure part of the web interface !

we also need a remote call center to use this web interface. the call centre will be briefed to sell specific fast moving parts and nothing elese. any techinical calls will be entered into the webinterface for our staff to work on and convert to sales.

7 I need some way of reporting the % of tickets converted into sale - maybe by tracking email address both in ticketing and in accounts ?

I don’t need frilly graphs just a clear structure to the data so a simple QUERY SQL will extract the data


we have a hosted dedicated web server running windows server 2003 - full SQL 2000

Skills: .NET, AJAX, ASP, SQL

See more: web based ticket system, asp based ticketing system, html based ticketing system, ticket system net, yellow software, www graphs, what to buy and sell on the web, what support will i need from management, what is record in data structure, what is graphs, what is data in data structure, what are graphs for, what are graphs, web press login, want to create buy and selling website, uk email address database, telesales staff, telesales data, telesales company, telesales call

About the Employer:
( 2 reviews ) preston, United Kingdom

Project ID: #584085

51 freelancers are bidding on average $1366 for this job


Hello, please check the PM for more details on the Web based ticket system project. Thanks.

$1250 USD in 45 days
(1 Review)

Hello, we have 9+ Yrs experienced team with 50 [login to view URL] done 200+ desktop/Windows [login to view URL] Raj

$1200 USD in 30 days
(4 Reviews)

Hi, We are a group of specialized, c#, sql server, xml, ajax, webservices,php,joomla, wordpress,mysql developer. Please check the PMB. Thanks Udal Kumar Bharti

$2000 USD in 30 days
(12 Reviews)

Hi, We are quite comfortable to work on your Project with our excellent team of Programmers & Designers. Please see PMB for our company Work & Experience. Thanks

$1600 USD in 30 days
(11 Reviews)

Hi, Pls chk the PM. Thanks.

$800 USD in 30 days
(2 Reviews)

hi Please check PMB

$1500 USD in 45 days
(3 Reviews)

I am working with 2.0/3.5, AJAX, JavaScript, VB Script, DHTML, XML, SQL Server 200/2005, ORACLE, Ms-access. I have more than 6 years of experience in this field. I am MCTS(Microsoft Certified Technology Special More

$800 USD in 30 days
(9 Reviews)

Hi, Please refer to my PM for details

$750 USD in 30 days
(1 Review)

Hi, please check the pmb for more details. thanks

$1050 USD in 20 days
(2 Reviews)

Hello Sir, I am Mihir Khatri and have understood d project requirements. I am an expert with ASP.NET, VB.NET, SQL SERVER, AJAX, XML, FACEBOOK + GOOGLE APPLICATIONS. Please check PMB for the demos. I guarantee you of th More

$750 USD in 25 days
(1 Review)

We are group of talented developers with more than 5+ yrs exp in Microsoft technologies. Please contact us for a small model of your project and decide :)

$1500 USD in 60 days
(0 Reviews)

i am ready to [login to view URL] wishes.

$1500 USD in 30 days
(0 Reviews)


$1500 USD in 60 days
(0 Reviews)

• Content Pages (wysiwyg editor) • News with teaser feed on home page • Calendar/events • Forum • Blog (with teaser feed) • Photo gallery (with auto image optimizer and sizer – we can use aspjpeg or More

$750 USD in 3 days
(0 Reviews)

Dear Sir, Thanks for your job post. My name is Nikunj and I would like to introduce my company Kairee Systems. We are a team of very talented .NET, JAVA, Flash & PHP developers situated at Pune, India. We are provi More

$1500 USD in 30 days
(0 Reviews)

I can make this.

$1100 USD in 21 days
(0 Reviews)

Hi, Please check your PM for more. Thanks

$1200 USD in 15 days
(0 Reviews)

Hi I'm from Philippines. 3 years plus in web development using vb. I created and deployed a customized online ticketing system that absolutely fits your need. It handles complaints and refund request and escala More

$1200 USD in 20 days
(0 Reviews)

Hello, I have built several systems very similar to this, tickets, sales, e-mails and legacy systems integration. I would like to know more about the project, although you seem to have defined it well. If you choose me More

$1250 USD in 25 days
(0 Reviews)

Hi, For kind information We have lots of similar work experience of this type solutions. Please see PMB for similar prior work experience. We will provide you this solution within lowest price and best quality of wor More

$2000 USD in 50 days
(0 Reviews)