Skip to main content

Telephony Idea- Play order details over phone using KooKoo

Use Case:
Customers order items on websites. To know the status of their order, customers have to visit the website, login and select the order.

Provide order details over phone

Users need not be connected to the Internet to know the status of the order.

1.Ask the user to enter his phone number while placing the order.
2.Store the phone details along with the order.
3.When the customer calls the KooKoo number, KooKoo passes the caller id in the "cid" parameter.
4.Query your database for the order details based on the caller phone number.
5.Play the order details using <playtext> tag.



$link = mysql_connect('hostname','username','yourPassword');
mysql_select_db('database_name', $link);
$sql = "select * from orders where phone_number=$_REQUEST['cid']";
$result = mysql_query($sql, $link) or die(mysql_error());
$row = mysql_fetch_assoc($result); 
echo "<response><playtext>Your order status is, </playtext><playtext>$row['order_status']</playtext><hangup/></response>";

Who is it useful for:
Almost all eCommerce sites can use this solution to open up another channel of communication with their clients.

So you can have a simple Interactive Voice Response system for customer order details with just 10-20 lines of code for as little as Rs.500/month. This should take care of almost 80% of your customer calls.For any queries you can mail

Also see my post on how to setup a free help desk for your operations.

Popular posts from this blog

First Post

In this blog, I will be talking about my experiences in trying to build a cloud telephony platform , KooKoo . Along the way I will also be talking about different design choices I made, good programming practices and the IVR domain in general. For technoratti: NNFJW8EW86C3

Integrating Arborjs with Angular to create a live calls dashboard

Arborjs  is a cool graph visualization library. Angular  is one of the best JavaScript frameworks and we have been using Angular in a lot of our front end development. When you handle millions of calls, proper visualization becomes very important. Without proper visualization, you can get lost in the mountains of data. So we spend a lot of time to come up with good visualizations to represent the data. Since we loved the cool way in which Arbor represented graph data, we could not wait to hook it up with Angular. Because of Angular's two way data binding, when you hook up Angularjs with Arbor.js you can get a dynamically updated visualization of graph data with cool animations. To give back to the community, we have put up the code online at Github . Basically we have created an Angularjs directive for Arborjs. Please feel free to fork the code and add extensions and use it for your own visualizations. The code is self explanatory with comments inline. Best way to get s

Telecommunication Revolution & Cloud Telephony

Telecommunication Revolution & Cloud Telephony Every one talking that world power has shifted from west to east, next century belongs to India and China, as China is an aging country, everyone is betting very high on India. To find the reality, I have done a comparative study between India and western countries. The result was really depressing, in most of sectors/areas we are way behind the developed countries, except one sector i.e. “Telecommunication”. You can see in the above picture the call rate, which was at Rs 15.5/min has dropped to less than a Rupee/min. The telephone subscriber base has also increased a rate of 40% YoY (approx.). According to Mar’15 release by TRAI, India has 999.71 million telephone subscriber, now we are in Sep’15. We would have crossed 1 billion mark. This is the overall picture of telephone subscriber, but if we look internet and broadband subscriber base it is also very optimistic. Apart from that recently Airtel has launched 4G servic