From excel & hard work to a system that runs itself.

A custom inventory management system that replaced a workflow with spreadsheet and manual processes for counting and reporting stock every month, with a purpose-built web app — including real-time stock tracking, automated tax reports, and a procurement flow that makes it easy to use.

ROLE SoloCLIENT Svendborgsund BryghusNext.jsPostgresPrismaVercel

0Manual reports per week

4h →Previous weekly reporting time

99.9%Inventory accuracy

3 weeksTo full adoption

Manual workflows were taking too long

Before the system, inventory management and reporting were handled through time-consuming manual processes. The brewery needed a better way of tracking inventory to stay compliant with reporting requirements for authorities such as SKAT and Sundhedsstyrelsen. The challenge was to create a tool that was simple to use, but powerful enough to support real operational and legal requirements.

Understanding the workflow before writing code

The project began by mapping out how the brewery actually worked day to day. Instead of starting with features immediately, I focused on understanding their stock flow, product structure, batch handling, and reporting needs. This made it possible to design a system around their real workflow, rather than forcing them into a generic inventory solution.

Batches

Products

Inventory items

Packaging

Design and planning

I started planning the project by just writing about their needs and converting them info features, pages, and breaking down the steps needed to creating them. I created tasks in notion to help myself keep track and plan the process. I started by working out the database and researching UI designs that I felt would work well. I went with retro and brutalist design as I felt it matched the vibe of the brewery while also being easy to understand.

The solution

A modern full-stack web application

The system was built using Next.js and Prisma, with a strong focus on performance, reliability, and maintainability. It includes advanced caching, role-based access control, cloud hosting, uptime and error monitoring, and a complete audit trail that logs changes to important inventory data. This ensures that the system is not only fast and user-friendly, but also secure and traceable.

0,00CLS

0,0 sTBT

0,8 sFCP

1,1 sLCP

Testing

Making sure the system worked flawlessly

I did extensive testing of the most important and business critical features, such as tax calculations, inventory synchronization and quantities and security auth gates. I wrote tests using vitest and integrated them in the CI/CD pipe lines.

LIKE WHAT YOU SEE

Got something like this on your plate?

No open slots right now — but reach out and I'll add you to the waitlist.

Start a project See all work