Low-stock alerts for Egyptian online stores

Understand why low-stock alerts appear and how to find affected products without confusion.

Operations

A low-stock alert is your store quietly watching the shelf for you and tapping you on the shoulder the moment a product drops to a level you decided was too thin to ignore. It exists to buy you time: time to reorder from your Cairo wholesaler or importer before the item hits zero, and time to avoid the most painful moment in Egyptian online retail, telling a WhatsApp or Instagram buyer who is ready to pay cash on delivery that the thing they wanted just sold out. The alert does not guess how much to buy or when demand will spike. It does one job well, which is to make sure a falling stock count never surprises you.

This lesson explains why these alerts fire, how to choose a sensible threshold so they fire at the right moment rather than too early or too late, and how to move from an alert to the exact affected products without getting lost in your catalogue. Deciding the precise reorder number for each product is a forecasting question that lives in its own playbook, so here we stay strictly on the alert itself: the trigger, the threshold, and the triage that turns a notification into a confident restock decision.

Why a low-stock alert appears

An alert is not random. It fires for a concrete, traceable reason, and naming the reason tells you whether to act or relax.

  • A product crossed the threshold you set. This is the normal case. The available quantity fell to or below the line you chose, so the store flagged it before it reached zero.
  • A burst of orders drained it fast. A promotion, a viral Instagram reel, or a Ramadan and Eid demand spike can burn through weeks of stock in a day, and the alert is the first thing telling you the item is suddenly hot.
  • Stock was committed but not yet replenished. Open orders reserve units against your available count. A run of pending cash-on-delivery orders can pull a product under the threshold even before any parcel has shipped.
  • A variant ran low while the product looks fine. A T-shirt can read "in stock" overall while the Large or the most popular colour sits at zero. Alerts work at the level you actually sell, so the warning often points at one variant, not the whole product.
  • A manual count correction. A stocktake, damaged-goods write-off, or supplier shortfall lowered the number, and the new figure tripped the alert honestly.

Setting a threshold that fires at the right time

The threshold is the single number that decides when you get warned. Set it too low and the alert arrives after you have already sold out; set it too high and you drown in warnings for products that are nowhere near trouble.

  1. Start from your restock wait, not a round number. Pick a starting threshold that comfortably covers how long it takes to get more of that item onto your shelf, including the days a Cairo wholesaler or an importer makes you wait. If a refill reliably takes a week, the line should sit high enough that a week of normal selling will not empty you.
  2. Set it per product, never one size for all. A fast-moving hero product and a slow seasonal item should not share the same trigger. Working out the exact right figure from sales speed and lead time is forecasting work, covered in the linked lesson below; the alert simply enforces whatever line you land on.
  3. Raise it before known demand peaks. Ahead of Ramadan, Eid, Black Friday, or a planned campaign, lift thresholds on the products you expect to move so the warning comes early enough to reorder in time.
  4. Revisit it after every surprise. If an item sold out before its alert felt useful, the threshold was too low for its real velocity. Nudge it up and move on.

From alert to the affected products, without confusion

An alert is only useful if it leads you straight to action. The goal is to go from "something is low" to "this exact variant needs forty more units" in under a minute.

  • Sort your catalogue by stock, lowest first. This pulls every at-risk item to the top in one view so you triage the whole list, not just the one product that pinged you.
  • Drill into the variant, not just the product. Open the item and check quantities per size, colour, or option. The fix is almost always one or two variants, and ordering blindly at the product level wastes cash on stock you do not need.
  • Separate "low because selling" from "low because slow." A fast mover near zero needs an urgent reorder; a slow mover near zero may be fine to let run out and discontinue. Treat them differently.
  • Account for stock in motion. Remember that pending cash-on-delivery orders are holding units, and a refused COD parcel re-enters your available stock days later when it returns. The live number reflects reservations, so do not double-order against units that are simply committed.
  • Watch for off-store sales drift. If you also sell through Instagram or WhatsApp direct messages and forget to deduct those units, your count drifts above reality and the alert fires late. Keep every channel feeding the same stock figure.

Related lessons