Simple CRM for Small Businesses: Who Bought What, and When
CRM doesn't mean expensive, complicated software. Start by recording who bought what and when, then act on it — a realistic guide for small businesses.
The corner-store owner of the old days was a walking CRM. She knew the neighborhood by heart: which kid drank which brand of chocolate milk, which family stocked up right after payday, which regular settled his tab every Friday. No software. All in her head.
The trouble starts when the business outgrows one head. Suddenly there are 300 customers, cashiers rotating across three shifts, and nobody in the shop knows that the woman who just walked out used to buy weekly — and has not shown up in two months.
CRM — customer relationship management — is just a fancy name for putting that shopkeeper’s memory back into a system. It is not about sophisticated software. It is about three questions: who is the customer, what did they buy and when, and what do we do with that information.
The minimum data worth recording
The first temptation of the newly CRM-enthusiastic: build a long form. Name, address, birthday, occupation, hobbies. Customers hate filling it in, cashiers hate asking, and the program dies within a month.
Start with the smallest thing that is still useful: name and WhatsApp number. That is it. Those two fields are enough to greet someone properly and reach them again. The rest — purchase history, transaction dates — should ideally be captured automatically by your POS, not typed by hand.
This is the single biggest difference between a CRM that lives and one that dies. A CRM that depends on manual entry will always have holes, because no cashier has time to type during the rush. A CRM embedded in the transaction flow — the cashier just picks the customer’s name at checkout — fills itself every day, and nobody feels like they took on extra work.
From records to action
Data that only gets collected is a liability. It becomes valuable the moment it triggers action. Three actions, easiest first:
Greet with context. When a customer messages you, you can see what they last bought. “Hi Sarah, how’s the washing machine holding up?” beats “how can I help you?” every time. That small context is what makes a small business feel personal — a weapon the big marketplaces do not have.
Offer what is relevant. A garage that knows a customer’s last oil change was four months ago has a legitimate reason to send one reminder. A pet store that knows someone buys a 5 kg bag of cat food monthly can reach out as the cycle comes around. That is not spam; it is service that happens to produce revenue.
Catch the ones drifting away. This is the most valuable move and the least practiced. Regulars who stop coming rarely say goodbye — they quietly switch. Without records, you notice a year later. With records, you can pull up “customers who used to come monthly but have been silent for 60 days” and reach out before they forget you entirely. The full tactic is in win-back campaigns.
Where to start: a spreadsheet is fine
Honestly: for a business with under a hundred customers, a spreadsheet is enough. One row per customer; columns for name, WhatsApp number, last purchase date, total spend, and free-form notes. Updating it once a week already makes you sharper than most of your competitors.
Signs the spreadsheet is starting to crack:
- More than one person serves customers, and the notes are drifting into different versions.
- Answering “who hasn’t been back in 3 months?” takes half an hour of manual filtering.
- Interaction history is scattered: some in chats, some in a notebook, some in someone’s head.
At that point, a system that unifies the register, chat history, and customer data into one profile starts to earn its keep. Tenavora, for instance, shows a cross-channel customer timeline — POS transactions, WhatsApp chats, redeemed vouchers — on a single screen, so whoever is on shift gets the context instantly. But again: the tool follows the habit, never the other way around.
Small habits that keep a CRM alive
Any system dies without a ritual around it. Three light ones that actually stick:
First, ask for the name on the second purchase. Let the first transaction be fast. When the same person returns, that is the signal they are worth recording — “can I get your name and WhatsApp number? We’ll let you know about member promos.” If you run a loyalty program, this offer is almost never refused.
Second, spend 15 minutes every Monday on two lists: last week’s new customers (greet them, say thanks) and regulars who have gone quiet (send one personal message). Fifteen minutes. Not a big project.
Third, note the non-transactional things that matter. “Kid has a peanut allergy.” “Always deliver before 3 p.m.” “Complained about packaging last month — resolved.” One-line notes like these save you from repeating mistakes and make customers feel remembered.
Small businesses rarely win on price — everyone’s margins are equally thin. What you can win on is the feeling of being known. And that feeling is not a talent; it is a simple recording system run consistently. Start this week: one spreadsheet, name and WhatsApp number as the first two columns, and the 15-minute Monday ritual. The rest grows on its own.