C.O.D. Verification

what is c o d verification? cash on delivery (cod) has been a major growth driver for the e commerce industry however, it also introduces operational risks such as cancellations, fake orders, and failed deliveries reducing cod related losses is therefore a key focus area for most e commerce businesses with exotel’s automated cod verification , you can confirm the legitimacy of cod orders before dispatch — reducing failed deliveries and optimizing operational costs advantages reduce no shows an automated call is triggered to the customer before delivery to confirm their availability and willingness to receive the order avoid first attempt failures on the day of delivery, an automated ivr call checks whether the customer is available customers can confirm or reschedule deliveries via keypad input the input is relayed to your crm or backend system in real time implementation steps 1\ automated call trigger on cod order when a cod order is placed, your system can trigger an automated verification call to confirm the order and customer number 2\ send details to exotel your server sends the customer number and call flow details to exotel via api 3\ exotel initiates the call exotel automatically calls the customer with a pre defined ivr flow to confirm the order 4\ capture customer input based on customer input (e g , press 1 to confirm , press 2 to cancel ), your crm can mark the order status as verified, canceled, or pending api implementation exotel api to connect a call to a flow https //\<your api key> \<your api token>@\<subdomain>/v1/accounts/\<your sid>/calls/connect this api first calls the from number, and once the recipient answers, connects them to the call flow (applet) you’ve created in the system — for example, a landing app with ivr or greeting logic an http post request is made to the above endpoint api credentials navigate to api settings in your exotel dashboard and retrieve account sid api token api key for details, see how to find my api key, api token, account sid, and subdomain? mandatory parameters detailed documentation for all parameters is available here https //developer exotel com/api#call customer the call flow referenced in the api must be created in your exotel dashboard https //my exotel com https //my exotel com sample call flow go to app bazaar → create flow → enter flow name use the following applets in sequence applets to use gather — captures customer keypad input passthru — sends input data to your server via webhook hangup — ends the call gracefully steps drag and drop the gather applet – digits entered will be recorded and stored drag and drop the passthru applet – link it to your webhook url add the hangup applet at the end of the flow save the flow assign an exophone to the newly created flow implementing cod verification with google sheets to simplify data collection, you can integrate exotel with google sheets using a simple apps script steps open a new google sheet in script editor , paste the following code deploy the script as a web app and copy the web app url use this url as the passthru webhook in your exotel flow sample javascript code // spreadsheet configuration var id = "1m2 mshdx8pivjlwtpwtvdcpndstqw ofnui6fodiyik"; // sheet id var sheet name = "sheet1"; // append data to sheet function doget(e) { var params = json stringify(e parameters); var jsonmapping = json parse(params); var sheet = spreadsheetapp openbyid(id) getsheetbyname(sheet name); sheet appendrow(\[jsonmapping\["from"]\[0], jsonmapping\["digits"]\[0]]); return contentservice createtextoutput(e parameters); } replace id → the sheet id from the google sheets url sheet name → the name of the sheet where you want to store data deploy the script when deploying project version enter a version name execute as me (your email) who has access anyone, even anonymous click deploy to get your web app url use this webhook url in the passthru applet in your exotel call flow