The verdict in three sentences
A consumer goods distributor running 4 warehouses around Berlin that learns about stockouts when customers call typically loses 4 to 8 % of revenue in missed sales, while tying up 10 to 15 % dead stock in other sites. Automated reorder thresholds, Slack or Teams alerts and replenishment suggestions connected to the ERP cost, as a 2026 estimate, 25,000 to 70,000 EUR depending on SKU count and data quality. The project usually pays back within months once revenue passes 20 million EUR a year, provided inventory discrepancies are fixed first.
Why stockouts happen without warning
Most German mid-sized wholesalers have stock in their ERP (SAP Business One, Microsoft Dynamics, Sage, weclapp) but nobody watches it site by site. The Spandau warehouse can be empty on a fast mover while Marzahn holds three weeks of cover. Sales reps hear it from the customer, the delivery slot is lost and the order goes to a competitor.
| Symptom | Usual cause | Estimated cost (2026 estimate) |
|---|---|---|
| Stockout discovered by the customer | No per-warehouse alert threshold | 4 to 8 % of revenue in lost sales |
| Overstock in one site, stockout in another | No consolidated view of the 4 sites | 10 to 15 % of stock tied up |
| Supplier orders placed by gut feeling | No average demand calculation | 2 to 4 rush orders per month, freight up 15 to 30 % |
| Gaps between ERP and physical stock | Late postings, undeclared damage | 2 to 5 % of stock value |
| Expired goods at year end | No date-based rotation tracking | 0.5 to 1.5 % of revenue |
| Time spent calling warehouse staff | Scattered information | 1 to 2 h per day for the logistics manager |
What the automation actually does
The principle is simple: every hour, a service reads stock per warehouse from the ERP, compares it to a calculated threshold, and triggers an action.
- Dynamic thresholds: each SKU's reorder point per warehouse is recalculated weekly from the last 8 to 12 weeks of sales and the supplier lead time.
- Alerts: the warehouse lead and the buyer get a clear message in Teams, Slack or WhatsApp ("Spandau: sunflower oil 5 L, 2 days of cover, 140 cases available in Marzahn").
- Transfer or order suggestion: the system first proposes an inter-warehouse transfer, then a pre-filled supplier order to approve in one click.
- Dashboard: service level per site, days of cover, dead stock older than 90 days.
| Project scope | 2026 price range (estimate) | Timeline | For whom |
|---|---|---|---|
| Simple fixed-threshold alerts, daily ERP export | 12,000 to 25,000 EUR | 3 to 4 weeks | Under 500 SKUs, 1 to 2 warehouses |
| Dynamic thresholds + alerts + dashboard | 25,000 to 45,000 EUR | 6 to 8 weeks | 500 to 2,000 SKUs, 3 to 5 warehouses |
| All of the above + transfers and pre-filled supplier orders | 45,000 to 70,000 EUR | 8 to 12 weeks | Over 2,000 SKUs, central purchasing |
| Recurring cost (hosting, messaging, maintenance) | 400 to 1,500 EUR per month | Depends on volume and support level |
The heaviest line item is usually the ERP connection, especially with an older on-premise version without a usable API. Hosting in a German data centre (Hetzner, IONOS, Azure Germany West Central) keeps the setup in line with GDPR and works council expectations.
The prerequisite everyone forgets
An alert based on wrong stock destroys trust within two weeks. Before switching on automation, run cycle counts on the 200 SKUs that make up 80 % of revenue and enforce same-day posting of goods issues. Without this, no tool will deliver.
Mini case study
Lena, head of operations at a food and household goods wholesaler near Berlin, runs 4 warehouses (Spandau, Marzahn, Schönefeld, Hennigsdorf), 1,400 SKUs and 45 million EUR in annual revenue.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Estimated lost sales from stockouts: 5 % of revenue, or 2,250,000 EUR. At an average gross margin of 14 %, that is 315,000 EUR of lost margin.
- Realistic goal: halve stockouts, recovering 157,500 EUR of margin per year.
- Dead stock at 12 % of an average 6,000,000 EUR inventory: cutting it by 3 points through transfers frees 180,000 EUR of working capital.
- Investment: 38,000 EUR for the project + 900 EUR per month, so 48,800 EUR in year one.
The project pays back in under four months on recovered margin alone, before counting freed cash or the phone calls no longer needed.
FAQ
Our ERP has no API. Can we still automate?
Yes, in most cases. A scheduled export (CSV or read-only database access) is read every one to four hours. This costs 3,000 to 8,000 EUR less than a full API integration, at the price of a short delay in the data.
Teams, Slack, email or WhatsApp?
Use the channel your warehouse leads actually read on the floor. Push alerts on a phone are typically read within the hour by over 90 % of recipients, while email alerts often wait until the next day. A daily email digest remains useful for management.
How soon will we see an effect on stockouts?
First alerts work from go-live, 6 to 8 weeks after kickoff. A measurable improvement in service level usually shows after 2 to 3 replenishment cycles, so 1 to 2 months.
Can field sales reps be included?
Yes. Each rep can see per-warehouse availability for their top 50 SKUs and be warned before promising a delivery date. This module adds roughly 5,000 to 10,000 EUR.
Who maintains the system after delivery?
Thresholds and rules evolve with your range. A maintenance contract of 400 to 1,200 EUR per month covers monitoring, rule adjustments and connector updates.
Let's scope your project. Tell us your ERP, number of warehouses and SKU count, and we will scope the build, indicative budget and a site-by-site rollout plan. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
