Case study · Professional project
Production ERP
Custom management software for a stone-cutting workshop: from quote to delivery, with stock, scheduling and statistics.
Anonymised project. The client, its data, prices and documents are not shown: the diagram and examples are generic.
Context
The workshop ran its orders with spreadsheets: a quote template, a price list and a customer tracking file kept by hand. Every document (quote, order acknowledgement, production sheet, delivery note) was copied from one file to the next, each time with a risk of error on prices or tracking.
Goal
A single piece of software, installed on the company computer and working offline, that follows an order end to end with no re-typing, without changing the documents customers know: the files it produces are still those of the existing spreadsheet template.
Working mock-up
- Customer: the record is filled from the SIRET number (public French company API), with the address split into number, street, postcode and town.
- Quote: stone lines (dimensions, quantity, finishes); the calculation reproduces the spreadsheet template formulas exactly, then the document is generated from that template.
- Order: order acknowledgement with lead time and customer discount; prices are frozen at quote stage and never move afterwards.
- Production: production sheet: each line is split across the workshop machines, week by week, in a Gantt-style schedule. The stock of blocks and cuts is tracked in three dimensions, with overlap checks.
- Delivery: partial delivery notes, quantities split per pallet, remaining quantity line by line; the order closes once everything is delivered.
- Tracking: the tracking file updates itself (with a dated copy before each write); turnover, indicators, stock losses and machine load, each chart with its calculation method.
Screenshots



Anonymised screenshots: names, numbers, dates and amounts are hidden.
Approach
- Gathering needs and writing the specification: interviews with the workshop, study of the existing files (quote template, price list, tracking), and a record of business rules that had never been written down: categories by thickness, rounding to standard thicknesses, document numbering.
- Analysing what existed before coding: the spreadsheet template formulas were rewritten in Python as a mirror, then checked by tests comparing the software totals with the spreadsheet totals.
- Evolving in short versions: about ten versions, each driven by feedback from use: customer discount, partial deliveries, machine schedule, block status, statistics, choice of output folders. Earlier versions are archived.
- Testing at every change: about 130 automated tests cover calculations, document generation, deliveries, stock and licensing.
- Protecting the data: no network port opened, nothing loaded from the Internet; source files opened read-only; a dated copy before any write, and no write if the file is open elsewhere; deleting sends documents to a recycle bin, never to erasure.
- Shipping an installable application: Windows build with an installer, licence bound to the computer (key signed with HMAC-SHA256 from a machine identifier); the key generator stays outside the shipped package.
The life of an order at a glance
Quote
Prices are computed from the price list, then frozen for the whole order.
Order and production
The acknowledgement confirms lead time and discount, the production sheet schedules the workshop.
Delivery and closing
Delivery notes follow one another until everything is delivered: the order is then closed.
Results
- Generated documents are identical to the spreadsheet template used until then: nothing changes for customers.
- An order goes from quote to closing without any re-typing.
- Orders made by hand before the software are recognised and imported, read-only.
Limitations
- The Windows version is built but not yet proven on a real Windows computer (developed on Linux).
- Interface windows are tested through the API, not yet by automated UI tests.
- Orders in an old format cannot be regenerated.
- The code is not published (proprietary licence) and the client is not named.