VILLACRUSIS LABS.

Writing · Custom systems

How do I keep track of stock and orders that come in on Viber?

By Harold Villacrusis · 16 November 2026

An order comes in on Viber, someone checks the stock count in Excel, and by the time the truck leaves, nobody is sure what is left in the warehouse. You can fix most of this for free today with one shared stock sheet, one order format your team and customers use, and a stock count at the same time every day.

If those stop being enough, a simple stock and order system is the next step. Further down you will see what it costs and how to tell when you need it.

Why do my stock numbers never match?

Usually it is because your stock lives in more than one place. Your salespeople take orders in Viber chats. Someone types those orders into Excel later, sometimes that night. Meanwhile your warehouse ships from what is on the shelf. Each of those counts is a few hours behind the others.

You feel it when you promise a customer 50 cases and then find out there are only 30. You are the one who has to call them back and explain. A growing distributor shouldn't depend on one person remembering which orders are already promised.

Free fix 1: Keep one shared stock sheet

Put your stock in one Excel file that everyone opens online, and stop sending copies around in Viber. A copy in a chat is out of date the moment someone takes the next order.

Give each item one row with four columns:

  • Item
  • Stock on hand
  • Reserved for orders
  • Available (stock on hand minus reserved)

When your salesperson takes an order, they add it to the reserved column right away. The next person who checks sees the lower available number before promising the same stock to someone else.

Free fix 2: Ask for every order in the same format

Pin one order format in your Viber group and ask your team and your regular customers to use it every time:

  • Customer name
  • Item and quantity
  • Delivery date and address
  • Payment: paid, GCash or cash on delivery

When every order looks the same, whoever types them into the sheet works faster and misses fewer. You also stop scrolling up through a long chat to find what a customer actually ordered.

Free fix 3: Count your stock at the same time every day

Pick one time, for example right after the last delivery goes out. One person counts your fast-moving items and corrects the sheet. Count your slow-moving items once a week.

Write down who counted and when. When a number turns out wrong, you will know since when it was wrong and which orders to check.

When is a spreadsheet no longer enough?

The free fixes work as long as everyone follows them. Watch for these signs:

  • Stock still gets promised twice because someone forgot to fill in the reserved column.
  • You have more than one warehouse or more than one truck, and each keeps its own count.
  • Your salespeople call the office to ask what is available before they can answer a customer.
  • Someone spends hours every week matching Viber chats to the Excel file.
  • At month end you cannot say which customers still have unpaid deliveries.

If two or more of these sound like your week, read the signs your business has outgrown spreadsheets for the full picture.

What does a simple stock and order system cost?

If you have been searching for an inventory system, this is what it means here. Your team enters each order once, the stock goes down for everyone at the same moment, and your salespeople see what is available from their phones. A system built for the way your business works starts at ₱150,000 to build in the Philippines.

Before any work starts, you get a written plan with a fixed price, so the number you see is the number you pay. If the free fixes are still working for you, keep them. I will tell you that on the call, even if it means no project.

How to start

  1. Tell me how your work runs today (a free 30-minute call).
  2. You get a clear plan and a fixed price before any work starts.
  3. I build it in small steps, and you see progress every week.

You can see what a stock and order system looks like on the orders and records page, or send me a message and I reply within one business day.

Questions

Questions people also ask

How do I keep track of stock and orders that come in on Viber?

Keep one shared stock sheet with a reserved column, ask everyone to send orders in the same format, and count fast-moving stock at the same time every day. When that stops working, a simple stock and order system lets your team enter each order once and see the same stock number.

How much does a stock and order system cost in the Philippines?

A system built for your business starts at ₱150,000, with a written plan and a fixed price before any work starts.
Harold Villacrusis

Harold Villacrusis

Senior engineer in Makati and the only person behind Villacrusis Labs. Nine years of production software; founder of NudgeNow. More about Harold

Want to talk it through?

Tell me how your work runs today. I reply within one business day to set up a free 30-minute call, and you get a fixed price before any work starts.