From WhatsApp Orders and a Spreadsheet to a Real Store

When manual order taking stops scaling, what actually breaks first, and how to move without losing the personal service customers came for.

From WhatsApp Orders and a Spreadsheet to a Real Store cover

A great many Indian businesses sell successfully through WhatsApp, Instagram and a phone number, with orders tracked in a spreadsheet. This is a real business model, not a deficient one, and it has genuine advantages — personal relationships, no platform commission, direct customer contact.

It also has a ceiling. Knowing where it is prevents both moving too early and staying too long.

What breaks first, in order

1. Stock accuracy

Almost always the first failure. Orders arrive across several channels, the spreadsheet is updated when someone gets to it, and you sell something you do not have. Apologising to a customer who has already paid is the point at which the informal system starts costing you.

2. Answering "where is my order"

Every customer asks. Each answer requires a person to look something up and reply. At low volume this is good service. At higher volume it is most of someone's day.

3. Payment reconciliation

Payments arriving by several methods, matched to orders by hand. As volume grows, mismatches accumulate and finding them becomes an end-of-month exercise.

4. Repeat customers as strangers

Someone who has ordered eight times is treated as new, because their history is spread across chat threads. The most valuable thing about direct selling — knowing your customers — is the thing the spreadsheet cannot preserve.

5. You become the bottleneck

Orders only get taken when someone is available. Nights and holidays are lost, and growth is limited by the hours of the person answering messages.

What not to lose in the move

The reason customers buy from you is often the personal contact. A store that replaces conversation with a checkout can lose the thing that was working.

The businesses that manage this keep both: the store handles catalogue, stock, payment and status, while the conversation continues for advice, customisation and relationship. Keep the WhatsApp number prominent. Let customers who prefer to ask, ask.

A staged move

  1. Catalogue online first. Products, prices, availability, shareable links. Even with orders still by message, this removes the most repetitive part of every conversation.
  2. Add checkout for customers who want it, while continuing to accept orders by message.
  3. Add order status customers can check themselves.
  4. Connect stock so availability updates automatically across channels.

Each stage is useful alone. Nothing is lost if you stop after two.

What to insist on in the platform

  • Stock that decrements on order and can be updated from a phone
  • Payment methods Indian customers actually use, including UPI and cash on delivery
  • Tax handling that determines rates by delivery address, not billing address
  • Order status visible to the customer without a support message
  • Export of everything, so you are not locked in
  • A backend usable on a phone — many small business owners will manage orders that way

How to know it is time

Count hours per week spent on: answering stock questions, answering status questions, and reconciling payments. Add the value of orders lost to stock errors or unanswered messages.

When that total exceeds what a store costs to run, the decision is made. Below that, the spreadsheet is fine and anyone telling you otherwise is selling something.


About the author. Kislay Chandan has worked with schools since 2014. Rather than gathering requirements from the outside, he worked inside a school to see what actually goes wrong day to day, and built what he found into the software. He still works with Shemrock Glitters in Patna — most changes to the product start with something that came up there.

Gallery

Gallery image 1
Gallery image 2
Gallery image 3
Gallery image 4
Ecommerce Site

The software behind this article

Ecommerce Site

Custom single or multi-vendor eCommerce platforms to launch your business online.

See Ecommerce Site

Have a question about this?

Ask us directly — no obligation, and we will not put you on a mailing list.

We call or WhatsApp you on this — please give a number that reaches you.

Keep reading

Related articles

More insights from Solaris Infotech on similar topics.

© 2026 Solaris Infotech Solution Pvt. Ltd. All Rights Reserved