Comparison
Does automated demand forecasting work with no history?
Automated demand forecasting is solved for a SKU with sales history. For a SKU with none, you have four stand-ins, and none earns the same trust.
By the Foxnut team · Updated
Does automated demand forecasting work for a SKU with no history?
Automated demand forecasting is a solved statistical problem when the SKU has history, and a different problem when it has none. With history, you take a time series of past sales, fit a curve to it, project it forward, and correct for trend and season as more weeks arrive. That part of the category is mature and cheap, and it is not where a project succeeds or fails.
This guide comes from Foxnut AI, a senior-only practice in Bengaluru and Paris that builds AI systems and hands them over. There’s a link to reach us at the end of the page. Let’s sort out your forecast first.
Ask a vendor whether its product does demand forecasting and the answer is almost always yes. The part worth comparing is the SKU the curve has nothing to fit against: a new product, a limited drop, a private-label refresh, a range that turns over faster than any item on it builds up a season’s worth of sales. For that SKU, automating the forecast means answering a different question: what does an item do when there is no record of what it has done.
One documented cloud forecasting product states this boundary in its own configuration. Of the algorithms it ships, only two can produce a prediction for an item with no direct sales history, and only when a separate file of item characteristics already ties the new item to items that do have history. Every other algorithm in the product has nothing to compute against and does not attempt it.
That is the product’s own admission that a no-history forecast is a different operation, run through a different mechanism, on different data, with a different and lower ceiling on accuracy, because it borrows an answer from a neighbour and does not read one off the item’s own record.
Anyone evaluating automation here is really evaluating two products with one name. The case for building and not buying either one is how this studio transfers a forecasting system once it is running well enough that a business does not need the studio to keep it that way.
What are the ways to forecast a SKU with no history?
There are four, and the choice is about what stands in for the history that does not exist and what happens when the stand-in is wrong. It is not a choice between forecasting and not forecasting.
| A person estimates it | Borrow from a like item | Wait, then switch to statistics | A general ML platform, configured for it | |
|---|---|---|---|---|
| What stands in for history | Judgment: a buyer’s read on how a similar launch went last time | A chosen analogue item’s own sales curve, scaled by hand or by rule | Nothing, deliberately - the order is placed on a manual estimate until real sales accumulate | A metadata file describing the new item’s attributes, matched by the system against items with real history |
| What it needs to work | A person who has seen enough launches to have a real prior | An honestly chosen analogue and the discipline to admit when none exists | Patience, and a tolerance for early stockouts or early overstock while data accumulates | A maintained metadata file, matched against a catalogue large enough to contain real analogues |
| Where it breaks | A launch unlike anything the estimator has seen before | An analogue chosen because it was convenient, not because it was similar | A launch cycle short enough that the item sells out or is discontinued before it ever crosses into “has history” | An attribute set too thin to distinguish a genuine analogue from a superficial one |
| What it costs to keep running | Nothing beyond the person’s time, and it does not scale past what one person can review | Almost nothing in tooling, and a real cost in the discipline of choosing analogues honestly | Nothing extra, and it is the default any business already has before it buys anything | A maintained metadata schema, a matching step nobody sees, and a system that needs the rest of the catalogue to already carry good data |
The third row is where most disappointment shows up. A borrowed answer, whether from a person’s memory or a matched analogue, is only as good as the analogue, and none of the four arrangements can verify the analogue before the sales come in to prove or disprove it.
Automating the choice of analogue does not remove that risk. It moves the judgment from a buyer’s memory into a metadata schema someone still has to design and maintain honestly.
What decides whether to automate demand forecasting?
Six structural dimensions decide whether a process is worth automating. Demand forecasting for a SKU with no history reads differently from the rest of this library on nearly all of them, because the thing being produced is a number about an event that has not happened, made without the one input, the item’s own past, that every other forecasting method assumes exists.
| Dimension | What it reads on demand forecasting | Source |
|---|---|---|
| Exception variance | The title's own case is close to the modal one in a catalogue with real turnover, not a tail case. Of the algorithms one documented cloud forecasting product ships, only two are qualified to produce a prediction for an item with no direct history, and they work only when a separate item metadata file already exists connecting the new item to items with real sales - every other algorithm the same product offers has no history to fit and does not attempt a no-history forecast at all. That is a vendor drawing its own line between two different jobs inside one product, not a business choosing to treat new items as special. | AWS, Amazon Forecast Developer Guide, coldstart forecasting and dataset documentation |
| Volume | Not the size of the catalogue, and not units sold. What the documented product actually requires is data points per item: its own guidance recommends the majority of series carry more than 300 data points for its statistical algorithms, wants each series above 300 and ideally at least 1,000 for its deep-learning algorithms, and warns that testing against only 1 to 10 time series will often produce poor results outright. Below 5 data points a new item is silently dropped from coldstart processing unless the business explicitly tells the system not to drop it. A catalogue can be large and still fail this floor everywhere it matters, if most of what is on it is new. | AWS Samples, ForecastCheatSheet.md, amazon-forecast-samples repository |
| Cost of an error | Asymmetric by construction, and the two directions are absorbed by different parts of the business. The classical formalisation of this exact trade-off defines the per-unit cost of ordering one too many as the unit cost less what can be recovered in salvage, and the per-unit cost of ordering one too few as the margin foregone - sometimes inflated further to account for the ill-will of a customer who could not be served. A merchandising or inventory function absorbs the first kind of miss as a write-down; a sales or customer-facing function absorbs the second as a lost margin and, on the ill-will reading, a customer who may not come back. A SKU with no history makes both directions worse for the same reason: the formal trade-off assumes a demand distribution to solve against, and a new item has none of its own to supply one. | Gallego, 'The Newsvendor Problem', IEOR 4000 course notes, Columbia University |
| Reversibility | The forecast itself is free to revise at any time; nothing is committed by changing a number. What is not freely reversible is what the forecast triggers. In one major planning system's own documentation, converting a planned order into an actual purchase, transfer or production order is called firming, and a firmed order is also described as a released or open order - the language of something that has left the plan and become a real commitment. Reversing it afterward is not editing the plan back; it is cancelling the resulting order through its own separate, tracked workflow, and in some configurations the same system will not permit a confirmed order line to be deleted outright at all, only cancelled with a status record left behind. The window for a free correction closes at the firming step, not at the forecast. | Microsoft, Dynamics 365 Supply Chain Management, order-firming and purchase-order-deletion documentation |
| Regulatory exposure | Close to nil on the forecast itself, and the applicable standard says so by what it declines to cover. The operative auditing standard on inventory directs the auditor to be present and test the effectiveness of the physical count and the reliance placed on the client's representations about quantities and condition - a fact about what is actually on the shelf at the balance-sheet date. The same standard states plainly that it relates only to observation of inventories and does not address other auditing procedures. Nothing in it confirms, tests or attests to the number that decided how much would be on the shelf in the first place. A forecast is a probabilistic estimate about the future; what eventually gets checked by an outside party is a fact about the past. | PCAOB AS 2510, 'Auditing Inventories', paragraphs .01, .02 and .09 |
| Vendor market maturity | Consolidating toward general tooling rather than maturing as a dedicated category. One major cloud forecasting product closed to new customers on 29 July 2024; its own transition notice states that the vendor will keep investing in security, availability and performance but does not plan to introduce new features, and directs customers instead to a general low-code machine-learning tool whose capabilities happen to include time series forecasting rather than a product built around it. Combined with the fact that the same discontinued product's coldstart capability worked through only two of its several algorithms and only with a maintained metadata file as a workaround, the honest reading is that no-history forecasting was never the vendor's core strength - it was a documented accommodation bolted onto a statistical engine designed for a different case. | AWS Machine Learning Blog, Amazon Forecast to Amazon SageMaker Canvas transition notice |
Two of those rows carry the argument. The exception row says the no-history case is not a tail a system can shrug off, because a real, shipped forecasting product draws an internal line between items it can fit a curve to and items it cannot, and routes the second group through a different, weaker mechanism.
The reversibility row says the forecast is the cheap part of this process and the order it produces is the expensive part. The expense arrives the moment that order is firmed, not while it is still a number in a spreadsheet.
The vendor-maturity row is the quiet one, and it should temper expectations first. A category where a major vendor closes its dedicated product to new customers and points people toward a general tool does not have a settled, off-the-shelf answer for the hard version of the problem. It has a settled answer for the SKU with real history, and an admittedly weaker, metadata-dependent workaround for the SKU this page is about.
Has Foxnut AI done demand forecasting work?
Yes, on one client engagement, and this claim needs more careful reading than the rest of the page. It traces to one source only, the founder’s own account of that engagement: an operating record, not a cited market statistic.
Named directly
We have built a second, more complete supply-chain system, for a different client than the one behind this pillar's other supply-chain pages. The engagement's own account of scope confirms demand forecasting as work it actually did, alongside supplier onboarding and order fulfilment
| Number | What it measures | Period | Source |
|---|---|---|---|
| Named directly | We have built a second, more complete supply-chain system, for a different client than the one behind this pillar's other supply-chain pages. The engagement's own account of scope confirms demand forecasting as work it actually did, alongside supplier onboarding and order fulfilment | As of August 2026 | Foxnut AI engagement records (not externally retrievable) |
The record states which processes this second engagement reached, and nothing more. It does not say how the forecasting performed, how it handled the no-history case this page is about, or what it cost. Everything else stays unstated, because the founder did not supply it and we do not infer it.
What do demand forecasting comparisons usually get wrong?
The first error is treating the whole catalogue as one forecasting problem. A catalogue is really two populations, items with enough history to fit a curve to and items without, and they need different arrangements, different accuracy expectations and different review discipline. A pilot run against the easy population and then extended to the whole catalogue will look excellent in the demo and fail exactly where the business needed help most.
The second error is measuring accuracy the same way on both populations. A forecast for an item with three years of seasonal history and a forecast for an item three weeks old are not comparable numbers. Blending them into one accuracy metric hides the population that is actually driving stockouts and write-downs.
The third error is automating the order along with the forecast for new items. The newsvendor cost, the classic trade-off between ordering too many and too few, is already asymmetric, and it is worse for a SKU with no history to estimate demand from. An automatic, unreviewed purchase order on top of an estimate with no track record turns a modelling weakness into a live commitment before anyone has seen whether the estimate was any good.
The fourth error is expecting a metadata-based workaround to close the gap to a real forecast, when it only narrows it. Borrowing an analogue’s demand curve is a documented, shipped technique, but it is still an assumption that the analogue is actually similar, made before any sales exist to confirm or deny it. Treating a coldstart prediction, a forecast for an item with no sales history, as equal in confidence to a statistical forecast built on the item’s own history is the most common way this category oversells itself.
Should you automate demand forecasting?
Automate the easy population, and put a person and not a rule on the order that follows a no-history forecast. Where a SKU carries enough of its own sales history to clear a forecasting product’s stated floor, statistical forecasting is mature and largely solved, and the honest first move is configuring what an existing planning system already includes.
Where it does not, the choice narrows to which stand-in for history you are willing to trust. None of the four (a person’s judgment, a chosen analogue, a wait-and-switch policy, or a metadata-matched coldstart prediction) deserves the same confidence as a curve fit to the item’s own record.
The reason is structural and is not a comment on how good any particular product is. The exception row says the no-history case is common enough, in a catalogue with real turnover, that a shipped product routes it through a separate and weaker mechanism. The cost-of-error row says the two ways this goes wrong land on different parts of the business, and both get worse without a real demand distribution to estimate against.
The reversibility row says the expensive step is the order the forecast triggers once it is firmed, which is why a no-history forecast belongs in front of a person before it belongs in front of a vendor.
For a team weighing this, the useful first count is not an accuracy percentage. Split the catalogue into items with a full season of sales and items without one, and count what share of revenue, not what share of SKUs, sits in the second group. A business where that share is small has a configuration decision to make on an existing system. A business where it is large is being asked to buy confidence in a number that, by the documented mechanics of every product that makes one, is borrowed and not earned.
The next question is whether the analogue it would be borrowed from is one anyone would actually stand behind. That is a question for someone who has launched real products, and our founders made and launched physical ones before advising anyone, among them a watercolour brand and a card game. Everyone on your brief is senior, and we will tell you if the answer is to configure what you already own.
A free audit call comes first, with no pitch deck, and our consulting work is described here. Share that new-SKU split and we will tell you plainly whether you have a forecasting problem or a merchandising one.
The part most pages leave out
When not to choose Foxnut AI
Situations where another option is the better call, and where we say so in the first conversation rather than the fourth.
- The catalogue, or the part of it under discussion, does not clear even the vendor's own stated floor for a working forecast: most items carry a thin run of sales, a new range turns over before any item accumulates a season's worth of data, or the count of items with real history is a handful against a catalogue of hundreds. The person already doing it, unchanged. One documented forecasting product states its own recommended floor as the majority of series carrying more than 300 data points for its statistical algorithms, warns that testing against only 1 to 10 series will often produce poor results, and drops any item with fewer than 5 data points from coldstart processing unless it is explicitly told not to. Below that floor, a person's judgment call is the correctly scoped answer, not a stopgap for a system that is not ready yet.
- New items are not the exception in the catalogue, they are most of it: a private-label refresh, a limited drop, a fast-fashion range, or any assortment where the modal SKU has been on sale for weeks rather than years. A redesigned process, not an automated one. A system built to fit curves against historical demand solves the wrong problem for a catalogue where most items never build up the history a curve needs. The design question becomes which existing items are close enough analogues to borrow from, which is a merchandising judgment before it is a modelling one.
- The intended use of the forecast is to fire a purchase order automatically once a threshold is crossed, with no review step before the order reaches a vendor. A human control point, or a rule that only ever proposes and never commits. In at least one major planning system's own documentation, converting a plan into an actual order is a one-way step: a firmed order becomes a real purchase order, and reversing it means cancelling that order through its own tracked workflow, not editing a number back to what it was. A wrong forecast costs nothing by itself. A wrong forecast already converted into a live order costs the cancellation process, and in some configurations that same system will not let a confirmed line be deleted at all, only cancelled with a record left behind.
- The business already runs an ERP or planning system with a built-in statistical forecasting module, has never turned it on, or runs it against a catalogue narrow and stable enough that the module's own stated limits do not bind. That module, and we say so. Statistical demand forecasting is a solved, shipped capability wherever a catalogue has the history to feed it. A business is more often on the wrong side of a configuration decision than in need of a built system, so the honest first move is to check what the licence already includes.
Sources
- Amazon Web Services, 'Importing Datasets', Amazon Forecast Developer Guide - the three dataset types (target time series, related time series, item metadata), the statement that Forecast only considers item metadata when the CNN-QR or DeepAR+ algorithm is used, and the description of coldstart forecasting as creating a forecast from the demand characteristics of similar items when direct history is missingRetrieved
- Amazon Web Services, 'Generating Forecasts' (Coldstart Forecasts section), Amazon Forecast Developer Guide - the definition of coldstart forecasting as generating a forecast for an item with no historical data, the requirement that coldstart forecasting needs both an item metadata dataset and an AutoPredictor, and the rule for how a coldstart item is identified (present in item metadata, absent from the target time series)Retrieved
- AWS Samples, 'ForecastCheatSheet.md', amazon-forecast-samples GitHub repository - the guidance that statistical algorithms (Prophet, ETS, ARIMA) expect the majority of time series to carry more than 300 data points, that deep-learning algorithms want each series above 300 and ideally at least 1,000, the warning that testing with only 1 to 10 time series will often produce poor results, the rule that forecast length cannot exceed one third of the training data, and the note that a new item with fewer than 5 data points must have missing values explicitly filled or it is silently dropped from coldstart processingRetrieved
- Amazon Web Services, 'Transition your Amazon Forecast usage to Amazon SageMaker Canvas', AWS Machine Learning Blog - the closure of Amazon Forecast to new customers effective 29 July 2024, the statement that AWS will keep investing in security, availability and performance but does not plan to introduce new features, and the direction of customers to Amazon SageMaker Canvas, a low-code tool whose capabilities include but are not limited to time series forecastingRetrieved
- Guillermo Gallego, 'The Newsvendor Problem', IEOR 4000: Production Management course notes, Columbia University, 6 April 1995 - the formal definitions of the per-unit overage cost (unit cost less salvage value) and the per-unit underage cost (selling price less unit cost), and the note that the underage cost is sometimes inflated to account for the ill-will cost of unsatisfied demandRetrieved
- Microsoft, 'Firm planned orders', Dynamics 365 Supply Chain Management product documentation - the definition of firming as the step that converts a planned order into an actual purchase, transfer or production order, the three firming methods (manual, automatic within a firming time fence, query-based), and the note that firmed orders are also called released or open ordersRetrieved
- Microsoft, 'Purchase Order Line Deletion Restriction', Dynamics 365 Supply Chain Management support documentation - the design change, introduced in the May 2023 release, that blocks deletion of a purchase order line that is or was confirmed under budget control or encumbrance accounting, and the documented workaround of cancelling the line's remaining quantity rather than deleting itRetrieved
- Public Company Accounting Oversight Board, AS 2510 'Auditing Inventories' - paragraph .01 on inventory observation as a generally accepted auditing procedure, paragraph .02's statement that the section relates only to observation of inventories and does not deal with other auditing procedures, and paragraph .09's direction that the auditor be present to test the effectiveness of the inventory-taking methods and the reliance placed on the client's representations about quantities and physical conditionRetrieved
Foxnut AI takes on work like this from Bengaluru and Paris. If you want to see how we do it before you talk to anyone, here is what an AI engagement covers and what you keep.