Inventory forecasting and reorder planning for Shopify and Amazon brands

Know what to reorder, and when.

Every night, Kerno Forecast works through your Shopify and Amazon sales and gives you the buy list: how many of each SKU, from which supplier, by what date, with the reason on every line. Approve it, and the purchase orders are written.

Get early access

Built to run our own Shopify and Amazon brands first.

Upcoming reorders

Example data

Every line says why.Yellow is the date to order by.

One click: 3 purchase orders.One per supplier, totals added up. Nothing is sent until you check.

Ningbo Steelware

Insulated bottle, 750 ml840 units
- Order by 5 Dec
- Out of stock 27 of the last 90 days
- Real lead time 38 days
Spare bottle lid350 units
- Also sold inside 2 bundles
- Above the 300 minimum order
Steel straw pack500 units
- Steady sales
- Reliable supplier

Jingdezhen Ceramics

Cold brew jar420 units
- Order by 8 Dec
- Last 3 orders took 41 days, not 25
Travel mug, black200 units
- 400 already on order

Leeds Print & Pack

Gift box set650 units
- Order by 18 Nov
- December peak season
- Sales up 30% since September

3 draft purchase orders

Ningbo Steelware3 lines, arrives about 12 Jan$6,291Draft
Jingdezhen Ceramics2 lines, arrives about 18 Jan$3,130Draft
Leeds Print & Pack1 line, arrives about 9 Dec$7,150Draft

Review each draft, then send it to the supplier. Nothing is ordered until you do.

Your spreadsheet is always yesterday.

Watch one week. Kerno counts every sale and re-plans every night. The sheet stops at Monday’s export, so by Sunday it thinks your best seller has 34 days left. It has 14.

Sun 23:59

KernoCounts every sale, re-plans every night

Bottle on order, in time.14 days of stock left, and more on the way.

Product	Stock	Days left	Status
Insulated bottle	410	15	On order
Cold brew jar	336	29	On order
Gift box set	1200	49	Fine for 3 weeks

594 units sold this week, all counted

Your spreadsheetUpdated Mon 09:12

Sheet says 34 days left. Really 14.By the time it notices, the bottle has sold out.

Product	Stock	Days left	Status
Insulated bottle	615	34	OK
Cold brew jar	418	35	OK
Gift box set	1495	60	OK

582 units sold since the export, not in the sheet

An illustration of one week with example data: the same sales reach both sides.

Beat your spreadsheet. Here’s how.

New orders flow in on their own and the numbers are refreshed every night, while you sleep. See everything Kerno Forecast weighs.

The momentWhat Kerno doesWhat a spreadsheet does

The 2am order is already counted.Shopify orders come in as they’re placed.Missing until someone exports the sales again.

A sale spike isn’t a trend.Deeply discounted orders stay out of everyday demand, so a promotion doesn’t trigger an oversized order.The spike goes straight into the average.

Sold out isn’t unwanted.Days with no stock don’t count as days with no demand.Averages in the zeros, then orders too little.

Your supplier said 25 days. It took 41.Lead times come from your real deliveries, including how much they vary.The lead time on the quote.

Peak season is on the calendar.Each product’s own seasonal pattern from its history, plus the peak periods you mark, like Black Friday.Last month’s average.

Bundles sell components too.Units sold inside a bundle count toward each product in it.The bundle’s row moves; its components’ rows don’t.

Nothing is ordered without you.

Every quantity shows its reasons. Every purchase order waits for your check. If a cost or a stock count is missing, the line says so instead of guessing.

A founder smiling at her laptop in her stockroom office

Your best seller might be losing money

Kerno Insights puts product cost, fees, shipping and ad spend against every product, then tells you what to do about the ones that lose money. Watch it re-sort by profit.

See how Kerno Insights works

Last month, by productExample data

By revenue, the gift box set looks like a winner.It’s your second-best seller.

By profit, it loses $3,200 a month.Ads take 48% of what it sells.

Product	Revenue	Product cost	Fees and shipping	Ads	Profit
Insulated bottle, 750 ml	$48,200	$16,900	$9,100	$14,800	$7,400
Gift box set	$31,500	$13,200	$6,400	$15,100	−$3,200
Travel mug, black	$22,800	$7,100	$4,300	$3,900	$7,500
Cold brew jar	$15,400	$5,600	$2,900	$1,200	$5,700
Spare bottle lid	$6,900	$1,100	$1,500	$0	$4,300

Kerno gives you the next step.Check which of its ads bring orders that pay back, before you buy more stock for it.

Start with one part. Grow into the rest.

Nothing to rip out. Kerno connects alongside the tools you already run.

Pick a starting point
Kerno Forecast for buying, or Kerno Insights for profit. Connect Shopify or Amazon and see your own numbers.
Add the other
Both run on the same connections, so what sells, what earns and what to reorder sit in one place.
Run everything on Kerno
When you're ready, Kerno can run stock, orders, purchasing and fulfilment too. Your products, suppliers and history carry over.

Free calculators and templates

Order before you run out.

Kerno Forecast is in early access for Shopify and Amazon brands.