How Cela decides what to reorder
The simple rules behind Cela's stock warnings and drafted purchase orders, and how to tune them for your shop.
· The Cela team · 2 min read
Running out of a best seller costs you twice: the sale you lose today, and the customer who tries somewhere else next time. Cela's job is to spot that before it happens. Here is exactly how it works, so you know when to trust it and when to adjust it.
It starts with your own sales
For every product, Cela adds up what you sold in the last 30 days and works out an average per day. No industry benchmarks, no guesses: just your shop.
From that it gets the number that matters most, days of cover: how many days your current stock will last at today's pace. 40 cartons of oat milk selling 10 a day is 4 days of cover.
Every product gets a status
- Out of stock: nothing left.
- A few days left: 4 days of cover or less.
- Below reorder point: stock is at or under the reorder point you set for the product (or 5, if you haven't set one).
- Overstock: 45 days of cover or more. That is cash sitting on a shelf.
- In stock: everything else.
Orders are drafted, never sent
On the purchase orders page, Cela looks for products that will run out before a new delivery could arrive. It compares each product's days of cover with how long its supplier takes to deliver (7 days if you haven't set a lead time).
For each of those products it suggests a quantity that covers two weeks of sales, plus your reorder point, minus what you already have. If the product comes in cases, it rounds up to full cases. The drafts are grouped by supplier, with a reason on every line.
Nothing is ordered until you open the draft, check it and send it.
How to make the suggestions better
- Set a lead time on each supplier. Cela uses it to decide when an order is urgent.
- Set a reorder point on your important products. It is the minimum you never want to drop below.
- Set a case size for anything you buy by the box, so drafts come in quantities your supplier accepts.
- Ring up every sale in Cela. The forecast is only as good as the sales history behind it.
A product with no sales in the last 30 days has nothing to forecast, so Cela leaves it to you.