2-Minute System Fix

Your customer list lives in one person's phone

If customer details only exist in a WhatsApp history on somebody's handset, you do not have a customer list. Here is the five-column version that fixes it this week.

Ask where a customer's phone number, what they last bought and when they bought it actually live. In a lot of small businesses the honest answer is a WhatsApp conversation, on a handset that goes home in somebody's pocket every evening.

That holds up until the phone is lost, or the person leaves, or the chat gets cleared to free up storage. None of those are unlikely, and all three take the customer list with them. The business carries on looking fine for about a month, which is roughly how long it takes to notice that nobody can remember who bought the last batch.

Five columns, starting today

Name, phone number, what they bought, the date, and one free column for anything worth remembering. That is the whole thing. A spreadsheet is enough and a shared one is better.

Fill it forwards rather than backwards. Trying to reconstruct three years of WhatsApp history is how this ends on Wednesday with nothing usable: add customers as they arrive from today, and add an old one whenever you happen to speak to them anyway. Six weeks of that covers most of the people who buy from you regularly, because most of them come back.

Put it somewhere the business owns. A shared sheet living inside somebody's personal account is the same problem with an extra step, and it is the version that feels solved, which makes it the more expensive one.

What this is not

It is not a CRM, and it should not become one until the spreadsheet is genuinely too small. The two signs are real: more than two people editing it at the same time, or needing to know who followed somebody up and when. Before that, a CRM adds fields nobody fills in.

It is also not a marketing list. Having somebody's number because they bought from you is not the same as having their agreement to be messaged, and treating one as the other is how a useful list turns into a blocked number.

Where we can help

The list itself needs nothing from us. When it outgrows a spreadsheet, connecting it to where the conversations already happen is AI and business systems work, and whether that is worth paying for in your case is exactly what the AI Opportunity Check is for. Four of its six possible answers are reasons not to build anything.

WebsitesSEOAI Systems
A sensible first step

Where do you want to start?

A website that brings in no enquiries. A business nobody finds on Google. The same job done by hand every week. Tell us which one it is.

Have a project in mind? Send an enquiry.

  • Free 30-minute call
  • No obligation
  • Talk to a person, not a bot
  • We publish our prices
Chat on WhatsApp