Inventory forecasting for Egyptian online stores

Every stockout you have ever had was a decision you made weeks earlier without realising it, on the day you guessed how much to buy. Forecasting is simply the habit of making that guess on purpose, with numbers instead of gut feel, so your bestsellers are on the shelf the moment a buyer wants them and your cash is not frozen in slow stock you over-ordered. For an Egyptian store the stakes cut both ways: run out of a viral item during a campaign and you hand the sale to a competitor on Instagram, but over-buy ahead of a season that fizzles and you have tied up working capital you needed for ads, shipping fees, and the next restock.

This lesson is about predicting demand and timing your purchase orders, not about the alert that pings you when a shelf runs low. The two work together but answer different questions: an alert tells you that you are about to run out today, while a forecast tells you weeks in advance how much to order and when to place that order so you never reach the alert in the first place. Here we stay on the planning side, the part that protects margin before a single unit is reserved. If you want the day-to-day warning mechanics instead, this page links to that topic at the end.

What you are actually forecasting in the Egyptian market

A forecast is just an honest estimate of how many units of each product you will sell over a future window. Three forces move that number, and in Egypt they move it hard:

• Seasonality and the calendar. Ramadan and Eid are the obvious peaks, but back-to-school, mid-year and end-of-year paydays, White Friday, and even weather swings all reshape demand. A gift item that sells five a week can sell forty in the last ten days before Eid.
• Your own marketing. Demand is not weather you observe passively; you create it. A paid push on Meta or TikTok, an influencer story, or a homepage promo can triple a product's velocity for a week. Forecast the campaign, not just the baseline, or your winning ad will sell out the thing it was promoting.
• Supplier reality. Lead time, minimum order quantities, and reliability decide how early you must commit. A local Cairo supplier who delivers in three days lets you reorder late and lean; an imported line that takes six weeks plus customs forces you to forecast a whole season ahead and carry more buffer.

The three inputs every reorder decision needs

You do not need forecasting software to get this right. For each important product, write down three numbers and let them drive the decision:

1. Sales velocity — how many units you sell per day or per week on average. Pull your own order history per SKU from your Storix admin; do not trust memory, which always overweights your favourites.
2. Supplier lead time — the realistic number of days from placing a purchase order to having sellable stock in hand, including manufacturing, shipping, and any customs delay. Use the worst recent case, not the promise.
3. Safety buffer — extra units that cover a demand spike or a late delivery. Set it higher for bestsellers, imported goods, and unreliable suppliers; lower for slow, locally sourced items.

From those three you get a reorder point — the stock level at which you place the next order. The plain-language formula is: (average daily sales × lead-time days) + safety buffer. If a product sells 8 a day, your supplier takes 10 days, and you keep a 20-unit buffer, you reorder when stock hits 8 × 10 + 20 = 100 units, not when it hits zero. Crossing that line is your signal to buy, and it is exactly the threshold a low-stock alert should be set to watch.

A simple monthly buying rhythm

Forecasting fails when it is a one-off panic rather than a routine. Build a light monthly habit:

1. Review velocity per product for the last 30 and 90 days, and flag anything trending up or down sharply.
2. Overlay the calendar. Mark the next Ramadan, Eid, school, or payday window and any campaign you have planned, then lift the forecast for affected products accordingly.
3. Calculate days of cover — current stock divided by daily velocity. Anything with fewer days of cover than its supplier lead time is already late; order it now.
4. Place orders by lead time, not by panic. Long-lead and imported lines get committed first; fast local restocks can wait. Stagger spend so you are not draining cash on everything at once.
5. Write the forecast down and check it next month. Compare what you predicted to what actually sold, and your estimates sharpen fast.

Stop overselling before it costs you a refusal

Overselling is the twin failure of a stockout: you accept and confirm cash-on-delivery orders for stock you do not have, then cancel days later. In Egypt that broken promise is worse than a quiet out-of-stock label, because the buyer was already waiting at home for a parcel. Let your store hold real-time quantities and decrement them as orders come in, so a sold-out item stops accepting orders automatically. Watch this especially when the same stock feeds your website, Instagram, and WhatsApp at once during a peak — three channels selling one shared pool is how a single popular SKU gets oversold in an afternoon. A disciplined forecast keeps enough on hand that you rarely flirt with the edge in the first place.

Related lessons

• Set low-stock alerts so a shelf never quietly empties — the day-to-day warning that fires when stock crosses the reorder point you calculated here.
• Price products with VAT and margin — knowing your true margin tells you how much buffer stock you can afford to carry.
• Plan Ramadan and seasonal promotions — the seasonal demand spikes your forecast has to anticipate weeks ahead.

This Storix Academy lesson is published as "Inventory forecasting for Egyptian online stores". Every step below is written for merchants selling online in Egypt, so apply one change at a time and measure the result before moving on.