# A Simple CRM for an Online Store: From Spreadsheet to Custom System

**Are your customers scattered across DMs, Telegram and a spreadsheet? Soon nobody knows who asked for what or who is still waiting.**

> A small online store is fine with a tidy sheet at first: customer name, contact, last order, follow-up status and next contact date. When follow-ups get forgotten, several people work on one sheet, or messengers and accounting must be connected, it is time for a simple or custom CRM.

Author: Saman Ghahreman · Published: 2026-10-10 · Updated: 2026-10-10 · Canonical page: https://solocodelab.com/en/blog/simple-crm-for-online-store/

Most small online stores keep customers in Instagram DMs, Telegram, WhatsApp and a spreadsheet. After a while nobody knows who asked for what and where follow-up stalled. A [custom or ready-made CRM](https://solocodelab.com/en/blog/crm-custom-vs-ready/) is the final answer, but most stores first need a simpler step.

## When is a spreadsheet enough?

If orders are few and one person follows up with customers, a tidy sheet is enough. What matters is that each customer has one row and the columns always stay the same.

| Column | Why you need it |
| --- | --- |
| Name and contact | So you can find them again |
| Customer source (DM, Telegram, website) | To see where your advertising works |
| Last order and its date | So you don’t forget old customers |
| Status (lead, ordered, repeat buyer) | To know what to do with each person |
| Next contact date | So follow-up doesn’t slip |

## When does a spreadsheet stop working?

- Follow-ups get forgotten, or two people follow up the same customer separately.
- Messages are spread over several messengers and the sheet falls behind.
- You want automatic reminders or a weekly sales report.
- Orders must connect to accounting, SMS or a payment gateway.

## What should a simple CRM have?

1. A card for each customer with their order and chat history.
2. Sales stages (lead, offer, purchase, follow-up) that change when you move the card.
3. Automatic reminders for the next contact.
4. Automatic saving of Telegram messages or website forms, with [simple automation such as n8n](https://solocodelab.com/en/blog/what-is-n8n-business-automation/).
5. A weekly report: how many leads came, how many bought, who has not been followed up.

## Where does AI help in a CRM?

AI can write chat summaries, suggest follow-up messages and put hot customers first. These work best when built on the store’s own data. For practical examples, see [increasing sales with AI](https://solocodelab.com/en/blog/ai-sales-growth-guide/).

## What should you do with customer data?

- Record only what you really need (name, contact, order).
- Don’t keep card numbers, passwords or ID documents. The NIST Privacy Framework is in this article’s sources.
- Give access only to people who need it and keep the file encrypted or on your own server.

## When should you move to a custom CRM?

A custom CRM pays off when your sales process doesn’t fit ready-made templates, the per-user monthly fee has grown, or you must connect SMS, Telegram and an Iranian payment gateway. Your earlier data is moved over from the spreadsheet. Before building, you can [see a live sample and pay afterwards](https://solocodelab.com/en/blog/show-live-sample-before-you-pay/).

> Not sure whether a spreadsheet or a CRM is enough? [Send your project brief](https://solocodelab.com/en/contact/?service=custom-crm) and we will tell you honestly what is enough. To build one, see [custom CRM development](https://solocodelab.com/en/services/custom-crm/).

## Frequently asked questions

### Does a small online store need a CRM?

Not always. If orders are few, a tidy sheet is enough. When follow-ups get forgotten or several people work together, it is time for a CRM.

### Can our old spreadsheet data be moved into the CRM?

Yes. Existing customers and history are imported from the spreadsheet or your previous software.

### How long does a simple CRM take?

A first version with the core features usually takes a few weeks, then improves step by step. The exact time depends on the sales stages and connections.

### Can a CRM record Telegram messages?

Yes. With automation, messages and forms can be saved into the CRM automatically.

## Sources

- [NIST Privacy Framework](https://www.nist.gov/privacy-framework) — NIST
