Inventory forecasting and reorder points in Egypt

Three numbers per variant, one formula, and the Storix field that watches your reorder point for you.

Operations

Every stockout you have ever had was a decision you made weeks earlier: not to buy, or not to buy enough.

Inventory forecasting is not a spreadsheet you have to love. It is three numbers per product, one field in your admin, and a monthly buying rhythm.

Forecast the variant, not the shop

Nobody runs out of "shirts". You run out of the red one in size L while the store still shows plenty. So forecast per variant: that is how Storix counts stock, and how your customer shops.

Then mark your seasons. In Egypt they are predictable: Ramadan, the two weeks before each Eid, back to school in September, White Friday. Demand doubles then — and your supplier is busy in the same weeks.

The three numbers

Velocity — units sold per day. Count the last 28 days and divide by 28. Drop any day you were out of stock, or the number comes out too low.
Lead time — days from "I order" to "it is on my shelf": production, transport, customs if you import, and your receiving day.
Safety stock — the cushion for a late supplier and a surprise week.

Put them together:

Reorder point = (velocity × lead time) + safety stock

You sell 6 a day, your supplier needs 12 days, and you keep 30 units as a cushion. 6 × 12 = 72, plus 30, so your reorder point is 102. You order at 102, not at zero.

Put the numbers in Storix

Open Products → Inventory. Each row is one variant in one warehouse.

Add inventory creates a row: fill On hand, Safety stock and Reorder point.
Edit on a row changes those numbers and sets the Alert threshold.

Alert threshold fires the low-stock warning across all warehouses. Leave it empty and Storix uses that variant's highest Reorder point; set neither and it uses 5.

One trap costs real money: Add inventory replaces, it does not add. If a row exists, the numbers you type overwrite it, even a 0 — so a hurried restock can wipe the reorder point you calculated. Use Edit on the existing row.

Low-stock alerts are included on every Storix plan, so set the threshold and your team gets told.

Where the numbers come from

Storix has no per-variant sales-speed report, so count velocity yourself.

The Sold column shows units of that variant in paid orders.
Analytics → Analytics shows Top products by revenue for the period you pick.
Export CSV gives every row for your own sheet.

Count monthly: ten minutes on your top 20 beats a perfect model on all 400.

A monthly rhythm

Day 1: export inventory, update velocity for your top 20.
Day 2: recalculate reorder points, then order anything near one.
Mid-month: recheck those rows; anything falling fast gets an early order.
Four weeks before a season: double the velocity for season items, recalculate, order before your supplier gets busy.

Stop overselling

A customer who orders what you cannot send is worse than a lost sale: they wait, then hear bad news.

Two settings protect you. First, turn on Enable cart stock reservations under Store settings → Cart stock hold and set a Reservation timeout in minutes, so stock in an active cart is held, not sold twice. It is off by default.

Second, know how stock comes back. A cancelled or returned order releases what it held. A returned parcel goes back on the shelf only when someone records it Resellable on the Returns page. Pre-order items never return to stock.

Set your reorder point as the variant's Alert threshold under Products → Inventory — open a free store.