Journal / Kirill Naumov

AI in retail demand forecasting: what the Cainz case actually teaches

An independent look at Cainz’s AI demand forecasting case in Japan: why data preparation, replenishment decisions and human exceptions matter more than a neat prediction chart.

Illustration: a customer and a colleague in a store

By Kirill Naumov ·

“Let’s add AI to forecasting” sounds like a tidy project. Retail demand rarely cooperates. The same product moves differently by store, season, promotion and channel. A model can predict a number; someone still has to decide what to order, where to put it and what to do when the prediction is wrong.

The Japanese home-improvement retailer Cainz offers a useful public example. Google Cloud’s customer story says Cainz built a demand-forecasting system with Vertex AI and expanded it to 209 stores by August 2024. The company also reported reducing sales-data preprocessing to about 50 minutes across its network. These are vendor-published claims, not independent audit findings or a promise that another retailer will get the same result. This is an independent analysis, not a project carried out by Kirill Naumov.

A forecast is not an order

Cainz described a previous fixed-order-quantity system that used a moving average of recent weeks. According to the case, it struggled with seasonal products and short-term sales patterns. Better predictions may help, but the useful business question is whether the predicted demand changes an order early enough to affect availability. A beautiful chart cannot unload a delivery truck.

The case also describes a less glamorous constraint: preparing data from six stores had taken about three hours. Expanding a model across hundreds of stores would have made that pipeline an operating bottleneck. The reported 50-minute preprocessing result therefore matters for a different reason from model accuracy: the team could get a current signal into a decision while it was still useful.

Start with the decision, then the model

Before choosing technology, name one decision to improve. Is the problem avoidable stockouts in a seasonal category, excess inventory in certain stores, or slow reactions to a promotion? Those are different tests. Map four links: the freshness and accuracy of sales and stock data; the forecast horizon needed by replenishment; who can accept or override an order; and the customer and operating outcomes you will measure.

Inventory records deserve special attention. If the system says there are ten items but the shelf is empty, a clever model may recommend the wrong quantity with impressive confidence. Treat that mismatch as an operating signal. Ask store teams and planners which exceptions the system misses, then distinguish a data error from a late supplier, a local event or a promotion change.

Run a pilot that can teach you something

Choose a limited category and comparable stores. Record a baseline before launch and account for promotions and seasonal peaks. Measure on-shelf availability, stockouts, excess inventory, markdowns and replenishment workload alongside forecast accuracy. Track overrides and ask why they happen. If a simple rule performs just as well, keep the simple rule; it is cheaper to explain and maintain.

Scale only when the team can say what improved, what it costs to run and who owns the exceptions. The practical lesson from Cainz is not “buy this model”. It is to connect prediction, data preparation and replenishment into one decision-making system. The outcome is a product being available where a customer expects it—not a more elegant line on a dashboard.

Explore the English AI for Retail workshop → · Discuss a retail AI consulting brief

Case-study source: Google Cloud’s Cainz customer story. Its figures are vendor-reported, not independently audited or guarantees of another retailer’s result.

Start a conversation →