Stop Counting Stock by Hand: Inventory Automation for Egyptian Retail Shops

By Sila · 6 September 2026 · 8 min read

Walk into most retail shops in Cairo at closing time and you will find the same scene: someone with a notebook or a phone camera counting shelves, another person checking the WhatsApp orders that came in during the day, and a spreadsheet on the office laptop that was last updated on Thursday. Nobody is lazy. The system is just manual, and manual inventory breaks in predictable ways: the popular size sells out on a Friday and nobody notices until Sunday, a slow product gets reordered because the sheet was wrong, and the numbers at the end of the month never quite match the shelves. This article explains what inventory automation actually means for a small or mid-sized Egyptian retailer, the four pieces you need, and how to pilot it in one category before touching the whole shop.

What manual stock control really costs

The cost of a manual system rarely shows up as one line in the accounts. It is spread across five places, and it is worth writing down where it hits you before you decide what to fix.

• Stock-outs on your best sellers. The item that sells every day is the one most likely to run out unnoticed, because it moves faster than anyone counts it. Every day it is missing is a sale you already had demand for.
• Dead stock. Money sitting on a shelf in the back room is money you cannot spend on the products that do move. Manual systems hide slow movers because nobody runs the report.
• Shrinkage you cannot locate. When counts and records disagree, you cannot tell whether the gap is a supplier short-delivery, a returns error, or theft. Without movement history, every discrepancy is a mystery.
• Staff hours. Add up the time spent counting, re-counting, and answering "do we have this in stock?" on WhatsApp. For a two-branch shop this is often a part-time job that nobody was hired for.
• Bad buying decisions. If you do not trust the numbers, you order by feel. Ordering by feel means over-buying what you remember selling and under-buying what quietly sells.

To put an EGP figure on this for your own shop, take your top twenty products, estimate how many days each was out of stock last month, and multiply by average daily sales and margin. Then add the purchase value of anything that has not sold in ninety days. That two-number estimate is usually enough to justify the project on its own.

What inventory automation means for a shop, not a factory

Inventory automation is often sold as a full ERP, and that is why many owners in Egypt put it off. For a retailer with one to five branches, the goal is much simpler: every stock movement is recorded once, at the moment it happens, by the system rather than by a person remembering to do it. Sales reduce stock automatically. Deliveries increase it when they are scanned in. Transfers between branches are logged, not texted. Once that single source of truth exists, alerts, reorder suggestions, and reports are straightforward to build on top of it.

The tools do not have to be expensive. A point-of-sale system or a well-structured database, a barcode scanner or a phone camera, a workflow tool like n8n or Make, and the WhatsApp Business API for alerts will cover the majority of Egyptian retail operations. The custom work is in connecting them to match how your shop actually runs.

The four layers of a working system

1. Capture: record every movement at the source

Give every product a barcode, printed locally if the supplier does not provide one, and scan at three moments: when goods arrive from the supplier, when they sell, and when they move between branches or come back as returns. Scanning at receipt is the step most shops skip, and it is the one that catches supplier short-deliveries. If you still take orders over WhatsApp or Instagram, the order should be entered into the same system before it is packed, so online and in-store sales draw from one count.

2. Sync: one stock figure across every channel

Most Cairo retailers now sell in at least three places: the physical shop, Instagram and WhatsApp direct messages, and possibly a marketplace or a simple online store. Each channel needs to see the same available quantity, minus anything reserved for unpaid cash-on-delivery orders. A workflow in n8n or Make can listen for new orders from each channel, deduct stock, and push the updated figure back out, so you stop selling the last unit twice.

3. Alerts: reorder points that message you

For each product, set a reorder point: the quantity at which you need to place a new order so that it arrives before you run out. A simple way to calculate it is average daily sales multiplied by supplier lead time in days, plus a safety buffer for busy periods. When stock crosses that line, the system sends a WhatsApp message to whoever does the buying with the product, current quantity, and suggested order size. Set a second alert for anything that has not sold in sixty or ninety days, so dead stock surfaces automatically instead of at the annual count.

4. Reporting: five numbers, weekly

You do not need a forty-page report. A weekly summary sent to your phone with sell-through by category, top ten and bottom ten products, stock-out days, current dead stock value in EGP, and the gap between recorded and counted stock at the last spot check is enough to run a retail business well. Put those five numbers in a small dashboard if you like, but the message on WhatsApp is what actually gets read.

A worked example with illustrative numbers

The figures below are illustrative, not a client case study. Use the method with your own numbers.

Imagine a clothing retailer with two branches in Cairo, one in Nasr City and one in Maadi, plus an Instagram page that generates daily orders shipped by courier on cash on delivery. Stock is counted by hand every two weeks and tracked in a shared spreadsheet.

Suppose the twenty best-selling items are each out of stock for an average of four days a month across the two branches, and each of those items sells around three units a day at an average margin of 150 EGP. That is 20 items multiplied by 4 days multiplied by 3 units multiplied by 150 EGP, or about 36,000 EGP in lost margin every month from stock-outs alone. Add a back room holding 120,000 EGP of items that have not sold in ninety days, and two-week manual counts costing perhaps 40 staff hours a month, and the picture is clear.

Automating capture and alerts will not eliminate stock-outs, but even halving them in this example recovers around 18,000 EGP a month, before counting the freed staff time and the cash released by clearing dead stock early. Set that against a one-time build cost and a monthly retainer for running the workflows and the payback is measured in months, not years. Your numbers will differ, so run this arithmetic with your own products before you commit.

How to pilot it in one category

1. Pick one category, not the whole shop. Choose the category with the most stock-out complaints or the highest value. Pilot there for four to six weeks.
2. Do one accurate count first. Automation starts from a baseline. Close the category for an hour, count it properly with two people, and load that as the opening stock.
3. Barcode everything in the category. Print labels for anything the supplier did not label. Train staff to scan every receipt, sale, and transfer in that category from day one.
4. Set reorder points for the top items. Use the daily sales times lead time formula. Round up ahead of Ramadan, back-to-school, and end-of-year seasons.
5. Turn on WhatsApp alerts to one named buyer. One person receives the messages and acts on them. Two owners is worse than one.
6. Spot-check weekly. Count ten random items in the category and compare against the system. The gap should shrink each week. If it does not, the capture step is being skipped somewhere.
7. Expand only when the gap is small. When your spot checks match the system consistently, add the next category. The habits are now proven.

Mistakes that sink retail inventory projects

• Skipping the receipt scan. If deliveries are added to stock from the supplier invoice instead of a physical scan, every short-delivery becomes a permanent error.
• Letting WhatsApp orders bypass the system. Staff pack an Instagram order from the shelf and forget to deduct it. Make entering the order the first step of packing, not the last.
• Choosing a system your staff will not use. A scanner that takes six taps per item will be abandoned by the second week. Test the real workflow with the real cashier before you commit.
• Automating a messy product list. If the same shirt exists under three names and two barcodes, fix the catalogue first. Automation is faithful to your data, including the bad parts.
• No owner for the workflow. Someone has to read the alerts, adjust reorder points, and report problems in the first months. Unowned workflows quietly rot.

Start with the shelf that hurts most

You do not need an ERP or a six-month project to stop counting stock by hand. You need one category with a clean count, barcodes on every item, a workflow that records movements as they happen, and a WhatsApp alert that tells the right person when to reorder. Prove it there, measure the stock-out days and the dead stock value in EGP, and then extend it across the shop. If you want help mapping your own stock flow, or you already know which category is leaking money and want the system built and run properly, talk to us at Sila. We build and maintain this kind of operational software for retailers across Cairo and Egypt, and the first conversation costs nothing.