On this page
35.13Retail Insights: cash customers by mobile number
A retail counter sells mostly for cash. Those customers have no account, so Outstanding, Who To Call Today and Customer Lapse never see them. If the cashier types the customer's mobile number on the bill, Retail Insights turns those numbers into a list of your regular walk-in customers and tells you who has not come back.
- At the counter, type the customer's number in Customer's Mobile No. on the POS screen. With Prompt to Input Customer Details like Name, City, Remarks etc. switched on in General Settings → POS, a panel asks for the name and city too. Next time, the number and Enter bring back the name and city from the last bill.
- Open Sale Reports → Retail Insights Report. The RETAIL INSIGHTS screen opens. Press OK.
- Each mobile number saved on a sale bill is one row: Mobile, Customer and City (from the latest bill with that number), Last Sale (date of that bill) and Days (days from that date to today).
- Press Excel, sort by Days, and you have a call list. Print prints the list.
Read every step in the guide: Insights Reports & Owner Controls, section 35.13
Questions and answers
My shop is mostly cash sale. How do I know which regular customers stopped coming?
Type the customer's mobile number on every POS bill, then open Sale Reports → Retail Insights Report and sort by Days (35.13). Customer Lapse covers only customers with accounts.
Retail Insights shows a number but no name.
The latest bill with that number had no name typed. Switch on Prompt to Input Customer Details like Name, City, Remarks etc. in General Settings → POS so the cashier is asked for it.