How to Manage Online Orders and In-Store Sales Together

Running an online store and a shop at the same time fails for one predictable reason: the same product ends up in two places, and the two records drift apart. Once they drift, you stop trusting both.

The fix is process, not software features. Here is the process.

One catalogue, two channels

Enter each product once. Mark whether it is available online, at the counter, or both. A single stock figure sits behind it.

When the shop sells the last piece, the online listing should stop selling it. When an online order comes in, the counter should not sell that piece to a walk-in customer. This only works if both channels draw from the same stock — which is why a separate billing machine and a separate website are a bad combination as soon as your range has any depth.

Keep payment status separate from delivery status

These two questions have different answers and different owners:

• Has the customer paid? Card, UPI or net banking paid online; cash on delivery still to be collected; a credit sale where the customer settles later.
• Where is the order? New, being prepared, dispatched, delivered.

When a system merges them into one "status" field, you lose the ability to answer either question properly. A paid order that has not shipped and a shipped order that has not been paid require completely different actions from you.

Cash on Delivery deserves its own track: the money is not yours when the order is placed, it is collected on delivery, and it can fail. Track it as its own state rather than marking the order paid at dispatch.

The daily rhythm

A simple routine keeps both channels honest:

1. Morning — check new orders and any orders stuck in the same status for more than a day. Chase those first; that is where customer complaints come from.
2. During the day — bill counter sales normally. Do not keep a separate notebook for "online stuff".
3. Evening — close the day: total sales, split by payment method, and any stock movement that surprises you. Investigate surprises the same day, not at month end.

Common mistakes and how to avoid them

Double entry. A product entered once for the website and again for billing. Both records drift. Fix: one catalogue, and delete the duplicate.

Stock adjusted by hand instead of by sales. If staff correct stock counts daily to make them look right, real shrinkage is hidden. Record purchases as they arrive and let sales reduce stock.

Discounts applied twice. A cart-level discount applied again at line level inflates the discount and understates the sale. Decide where discounts live — once.

No record of who billed. With more than one person at the counter, unattributed sales make it impossible to resolve mistakes. Attach the sale to the staff member.

Treating online as a separate business. Two sets of books, two stock counts, two opinions about what sold. One order list, one stock figure, one customer record per mobile number is the whole point.

What this looks like in StoreB

Products carry one stock figure and their channel availability. Counter sales from the Sales Counter and online orders appear in the same order list, each tagged with its channel. Payment status and fulfilment status are tracked separately, COD has its own collection states, and customers are grouped by mobile number so a repeat buyer has one history.