Fictional company and data. Hontanel Suministros Eléctricos, S.L. does not exist: its names, products, customers, figures and documents are made up. The AI is real and it can make mistakes.
Try the AI at a made-up warehouse
An electrical supplies distributor we invented: 408 items, 60 customers and two years of sales. The AI that serves it is real.
The demo, working
Fictional company and data · Real AI
Questions to start with
Data as of 30-09-2026. Last 12 months = Oct 2025 to Sep 2026.
- Sales, last 12 months
- 2,743,381.13 €
- +11.5 % vs the previous 12
- Gross margin
- 23.2 %
- 635,486.10 € over 12 months
- Active customers
- 57
- 16 buying less this quarter
- Stock at cost
- 340,354.17 €
- Turns 5.8 times a year (about 63 days)
- Dead stock
- 28,840.22 €
- 42 items with no sales in 6 months
Monthly sales
August drops every year: that’s why each quarter is compared with the same one last year.
Hover a bar or tab through them to see its value.
Show the table and the query
| Month | Sales | Margin |
|---|---|---|
| Oct 2024 | 222,648.66 € | 53,076.81 € |
| Nov 2024 | 199,140.95 € | 47,601.69 € |
| Dec 2024 | 175,407.11 € | 42,372.58 € |
| Jan 2025 | 171,013.14 € | 40,552.19 € |
| Feb 2025 | 198,775.81 € | 46,942.73 € |
| Mar 2025 | 237,891.59 € | 55,066.24 € |
| Apr 2025 | 220,212.48 € | 50,137.23 € |
| May 2025 | 235,305.33 € | 54,468.91 € |
| Jun 2025 | 241,853.24 € | 55,265.65 € |
| Jul 2025 | 220,450.52 € | 50,913.77 € |
| Aug 2025 | 129,815.19 € | 30,256.09 € |
| Sep 2025 | 208,068.21 € | 48,470.59 € |
| Oct 2025 | 258,821.05 € | 59,774.93 € |
| Nov 2025 | 250,643.08 € | 58,425.73 € |
| Dec 2025 | 193,001.71 € | 46,146.51 € |
| Jan 2026 | 196,247.33 € | 45,503.45 € |
| Feb 2026 | 214,040.43 € | 50,177.89 € |
| Mar 2026 | 242,775.53 € | 56,235.60 € |
| Apr 2026 | 253,492.15 € | 57,418.59 € |
| May 2026 | 270,288.30 € | 61,591.83 € |
| Jun 2026 | 270,661.85 € | 61,583.76 € |
| Jul 2026 | 231,556.89 € | 53,704.01 € |
| Aug 2026 | 131,418.19 € | 30,630.90 € |
| Sep 2026 | 230,434.62 € | 54,292.90 € |
SELECT mes, SUM(importe), SUM(margen) FROM ventas_mensuales GROUP BY mesGross margin by product family (12 months)
Show the table and the query
| Family | Name | Sales | Margin | Margin |
|---|---|---|---|---|
| ILU | Iluminación LED | 421,146.47 € | 148,027.22 € | 35.1 % |
| PRO | Protección (magnetotérmicos y diferenciales) | 574,665.84 € | 136,450.00 € | 23.7 % |
| MEC | Mecanismos | 368,131.65 € | 107,580.34 € | 29.2 % |
| CAB | Cable y conductores | 768,173.05 € | 84,208.56 € | 11.0 % |
| CAN | Canalización y cajas | 323,847.04 € | 76,953.01 € | 23.8 % |
| HER | Herramienta y medida | 127,700.06 € | 43,227.36 € | 33.9 % |
| CUA | Cuadros y envolventes | 159,717.02 € | 39,039.61 € | 24.4 % |
SELECT a.familia_id, f.nombre, ROUND(SUM(v.importe),2) AS ventas, ROUND(SUM(v.margen),2) AS margen, ROUND(100.0*SUM(v.margen)/SUM(v.importe),1) AS margen_pct FROM ventas_mensuales v JOIN articulos a ON a.codigo=v.codigo JOIN familias f ON f.familia_id=a.familia_id WHERE v.mes BETWEEN '2025-10' AND '2026-09' GROUP BY a.familia_id, f.nombre ORDER BY margen DESCStock turnover by family
Show the table and the query
| Family | Cost of sales, 12 months | Average stock at cost | Turnover (times a year) | Days of stock |
|---|---|---|---|---|
| CAN | 246,894.03 € | 39,997.43 € | 6.2 | 59 |
| ILU | 273,119.25 € | 43,902.84 € | 6.2 | 59 |
| CAB | 683,964.49 € | 115,542.49 € | 5.9 | 62 |
| MEC | 260,551.31 € | 43,848.18 € | 5.9 | 61 |
| PRO | 438,215.84 € | 80,052.63 € | 5.5 | 67 |
| HER | 84,472.70 € | 16,506.84 € | 5.1 | 71 |
| CUA | 120,677.41 € | 26,066.64 € | 4.6 | 79 |
WITH cv AS (SELECT a.familia_id, SUM(v.coste_total) AS coste_ventas FROM ventas_mensuales v JOIN articulos a ON a.codigo=v.codigo WHERE v.mes BETWEEN '2025-10' AND '2026-09' GROUP BY a.familia_id), sm AS (SELECT a.familia_id, SUM(s.valor_final_coste)/12.0 AS stock_medio FROM stock_mensual s JOIN articulos a ON a.codigo=s.codigo WHERE s.mes BETWEEN '2025-10' AND '2026-09' GROUP BY a.familia_id) SELECT cv.familia_id, ROUND(cv.coste_ventas,2) AS coste_ventas_12m, ROUND(sm.stock_medio,2) AS stock_medio_coste, ROUND(cv.coste_ventas/sm.stock_medio,1) AS rotacion_veces_anio, ROUND(365.0*sm.stock_medio/cv.coste_ventas,0) AS dias_stock FROM cv JOIN sm ON sm.familia_id=cv.familia_id ORDER BY rotacion_veces_anio DESCDead stock by family
Show the table and the query
| Family | Items | Dead stock value | Share of total stock |
|---|---|---|---|
| PRO | 11 | 10,621.72 € | 3.1 % |
| CAB | 9 | 8,170.11 € | 2.4 % |
| CUA | 4 | 4,820.50 € | 1.4 % |
| HER | 1 | 1,897.80 € | 0.6 % |
| MEC | 9 | 1,843.57 € | 0.5 % |
| ILU | 6 | 1,267.91 € | 0.4 % |
| CAN | 2 | 218.61 € | 0.1 % |
SELECT a.familia_id, COUNT(*) AS articulos, ROUND(SUM(s.valor_coste),2) AS valor_inmovilizado, ROUND(100.0*SUM(s.valor_coste)/(SELECT SUM(valor_coste) FROM stock_actual),1) AS pct_sobre_stock_total FROM articulos a JOIN stock_actual s ON s.codigo=a.codigo WHERE s.stock>0 AND COALESCE((SELECT MAX(v.mes) FROM ventas_mensuales v WHERE v.codigo=a.codigo),'0000-00')<'2026-04' GROUP BY a.familia_id ORDER BY valor_inmovilizado DESC12-month sales by sales rep
Show the table and the query
| Sales rep | Name | Area | Sales, 12 months | Margin, 12 months | Change |
|---|---|---|---|---|---|
| COM1 | Lucía Herrero (ficticia) | Toledo y Guadalajara | 914,563.02 € | 203,456.10 € | 22.9 % |
| COM2 | Andrés Molina (ficticio) | Ciudad Real | 899,916.82 € | 200,239.74 € | 15.4 % |
| COM3 | Rocío Campos (ficticia) | Albacete y Cuenca | 823,380.89 € | 176,029.30 € | -1.0 % |
SELECT cm.comercial_id, cm.nombre, cm.zona, ROUND(SUM(CASE WHEN v.mes BETWEEN '2025-10' AND '2026-09' THEN v.importe ELSE 0 END),2) AS ventas_12m, ROUND(SUM(CASE WHEN v.mes BETWEEN '2025-10' AND '2026-09' THEN v.margen ELSE 0 END),2) AS margen_12m, ROUND(100.0*(SUM(CASE WHEN v.mes BETWEEN '2025-10' AND '2026-09' THEN v.importe ELSE 0 END)/SUM(CASE WHEN v.mes BETWEEN '2024-10' AND '2025-09' THEN v.importe ELSE 0 END)-1),1) AS variacion_pct FROM ventas_mensuales v JOIN clientes c ON c.cliente_id=v.cliente_id JOIN comerciales cm ON cm.comercial_id=c.comercial_id GROUP BY cm.comercial_id, cm.nombre, cm.zona ORDER BY ventas_12m DESCCustomers buying less this quarter
| Name | Sales rep | Change |
|---|---|---|
| Servicios Eléctricos Oteruela, S.L. | Rocío Campos | -100.0 % |
| Instalaciones Folgaria, S.Coop. | Lucía Herrero | -100.0 % |
| Construcciones Lagunel, S.L. | Andrés Molina | -100.0 % |
| Obras y Reformas Lucernia, S.A. | Rocío Campos | -77.1 % |
| Gestión de Instalaciones Urbasel, S.L. | Rocío Campos | -62.6 % |
| Multiservicios Jarandel, S.L. | Rocío Campos | -58.9 % |
| Electricidad Serrania, S.L. | Andrés Molina | -58.6 % |
| Obras y Reformas Zarcena, S.A. | Rocío Campos | -57.3 % |
Show the query
WITH q AS (SELECT cliente_id, SUM(CASE WHEN mes BETWEEN '2026-07' AND '2026-09' THEN importe ELSE 0 END) AS act, SUM(CASE WHEN mes BETWEEN '2025-07' AND '2025-09' THEN importe ELSE 0 END) AS ant FROM ventas_mensuales GROUP BY cliente_id) SELECT c.cliente_id, c.nombre, cm.nombre AS comercial, ROUND(q.ant,2) AS t3_2025, ROUND(q.act,2) AS t3_2026, ROUND(100.0*(q.act-q.ant)/q.ant,1) AS variacion_pct FROM q JOIN clientes c ON c.cliente_id=q.cliente_id JOIN comerciales cm ON cm.comercial_id=c.comercial_id WHERE c.tipo<>'mostrador' AND q.ant>=3000 AND q.act<=0.8*q.ant ORDER BY variacion_pctItems below minimum stock
| Item | Stock | Minimum stock | Expected arrival |
|---|---|---|---|
| Cable RZ1-K 0,6/1 kV 3G2,5 mm², por metro | 0 | 3,050 | 05/10/2026 |
| Cable H07V-K 450/750 V 6 mm² azul, rollo 100 m | 2 | 9 | 16/10/2026 |
| Serie Plano, Interruptor 10 AX antracita | 180 | 275 | 14/10/2026 |
| Clavija aérea CETAC 32 A 3P+N+T | 62 | 89 | 06/10/2026 |
| Cable H07Z1-K (AS) 6 mm² azul, rollo 100 m | 6 | 7 | 09/10/2026 |
| Magnetotérmico 1P+N 25 A curva C 6 kA | 179 | 195 | 08/10/2026 |
| Escalera aislante de fibra 5 peldaños | 1 | 2 | — |
| Diferencial 2P 40 A 30 mA clase A superinmunizado | 3 | 4 | — |
| Cable coaxial TV 75 ohm, caja 100 m | 2 | 3 | — |
Show the query
SELECT a.codigo, a.descripcion, s.stock, s.stock_minimo, s.pedido_pendiente, (SELECT MIN(c.fecha_prevista) FROM compras c WHERE c.codigo=a.codigo AND c.estado='pendiente') AS llegada_prevista FROM stock_actual s JOIN articulos a ON a.codigo=s.codigo WHERE s.stock < s.stock_minimo ORDER BY (s.stock_minimo - s.stock)*s.coste_unitario DESC
Nothing you do here is saved.
Log in as
A quick check before using the AI
How to use it
Pick one of the four pieces and try it. You can type whatever you like or start with the suggested questions.
Hontanel is a wholesaler with 408 items in seven product families, 60 trade customers, three sales reps and sales from October 2024 to September 2026. All of it generated by code, without a single figure from a real company.
You’re talking to an artificial intelligence, not a person. It answers with Hontanel’s data and shows you where each figure comes from, but it can make mistakes. Don’t type in real data: this demo only works with sample data.
The AI has a daily usage limit, because every answer costs computing power. If today’s allowance has already been used up, you’ll see prepared answers based on the same data, and we’ll tell you so.
An assistant that cites the source
Ask it what you’d ask your warehouse manager. It answers with the data and, under each answer, shows you which table it comes from and which query worked it out. The suggested questions are in the demo itself, above.
A dashboard for management
Sales for the last 24 months, margin by product family, stock turnover, money tied up in items that don’t move, customers in decline and items below minimum stock. Every chart says where it comes from, so no figure is an act of faith.
Look at August: sales drop every summer, as in any warehouse that lives off building work. That’s why the dashboard compares each quarter with the same quarter a year earlier, not simply with the one before.
Document reading
Pick a sample document. For security, you can’t upload files here.
There are three delivery notes and two invoices from Hontanel. The AI reads each one and shows you the result next to the original: customer, date, lines, quantities, amounts. Anything it can’t read with confidence, it flags.
Try delivery note A26/1587. It has a smudged quantity that could be 21 or 27. Only 21 matches the line amount, so the demo suggests 21, explains why and asks you to confirm it. Then you can cross-check it against its invoice, where the quantity reads clearly.
We don’t keep anything you do here.
The sales portal
What each sales rep sees on their phone: their customers, who is buying less, who isn’t buying LED lighting from them when they could, and the price and stock of any item before walking onto a site.
Log in as Lucía Herrero (Toledo and Guadalajara), Andrés Molina (Ciudad Real) or Rocío Campos (Albacete and Cuenca). All three are made up.
What you’re seeing and what you’re not
You’re seeing real pieces working with made-up data. What you’re not seeing:
- Your management software. Here the data sits in a prepared database. With your business, the machine connects to what you already use.
- Your rules. Hontanel’s price lists, discounts and alerts are generic. Yours are defined with you.
- The real volume. Hontanel’s sales are grouped by month. Your business has its orders one by one, and the machine works with them.
- Your team’s review. In the demo, you confirm. In your business, you decide who should.
And most importantly: we don’t promise that your data will give the same figures. We measure it with you before we promise anything.
What it would look like in your business
If you recognised yourself in any of these questions, you already know what we need to talk about.
More on what’s behind it: automation for distributors, AI automation, AI chatbots and custom software. How we use AI in this demo is explained in AI use (in Spanish).
When the daily allowance runs out
The AI has reached its usage limit for today. We’re showing you answers already worked out with the same data and the same query. They’re real; they just aren’t being generated right now. Tomorrow the live AI works again.