A warehouse system for timber yards: log measuring, stock and offers in one
A timber yard counts logs and keeps stock in a notebook or Excel, and prepares offers by hand. This is a multi-tenant WMS: you measure logs, control stock with locations and send commercial offers from one place.
Industry: Timber yards and sawmills
In short
- Log measuring by the industry standard
- Stock with locations and QR codes
- Commercial offers from one place
- Multi-tenant: each company has its own secure space
About the project
A timber yard or sawmill measures logs, tracks stock and issues offers every day. Done in a notebook and Excel, it is easy to miscount and lose track of stock.
The challenge
Log measuring, stock and sales had to come into one system that serves many companies at once, each in its own secure space.
Goals
- Replace the notebook and Excel with one system
- Measure logs by the industry standard
- Keep stock with locations and QR codes
- Serve many companies, each separately and securely
Technical challenges
Measuring by the standard
Logs are measured by an industry standard. The system computes it the same way every time so stock and pricing add up.
Many companies, separate data
It is a multi-tenant SaaS. Each company has its own separated space, so one company's data does not mix with another's.
Solution and implementation
The whole yard in one system
Log measuring, stock with locations and commercial offers in one place, instead of several notebooks.
From log to offer
You enter a measured log once, then it shows in stock and you can put it straight onto a commercial offer.
Results
No more notebook and Excel
Measuring, stock and sales are in one system, available at once, without re-typing.
Order in stock
Locations and QR codes cut clutter and mistakes in stock levels.
Takeaways
The industry has its own rules
Measuring logs by the standard is not a detail. Without it the numbers do not add up and the system loses value for a sawmill.
Scope
- Log measuring
- Stock with locations
- Commercial offers
- Multi-tenant
Technologies
- Next.js
- PostgreSQL
- Prisma
- QR
Frequently asked questions
What does this system do?
It brings log measuring, stock with locations and commercial offers into one place, instead of a notebook and Excel.
Does it measure logs?
Yes, by the industry standard, the same way every time, so stock and pricing add up.
Will it handle my company separately?
Yes. It is multi-tenant, each company has its own secure, separated space.
Why QR codes?
They make it easier to find and label stock positions, so there are fewer mistakes.
Who is it for?
For timber yards and sawmills that do measuring, stock and sales by hand.