Bidev Consulting Logo
About
Case study

QualiKorn

IFS quality control application developed for a food industry manufacturer. Replacement of a critical Excel VBA file in 9 months.

Food Industry IFS / BRC On-premise 9 months
The client

International food industry group

An international food industry group specializing in cereals, mueslis, and breakfast products. The French site handles production under private labels with strict IFS and BRC compliance requirements.

  • Sector — Food industry (cereals, private label)
  • Certification — IFS Food, BRC
  • Deployment — On-premise (client infrastructure)
10+
Years of data
migrated history
IFS
Certification
next level
1
Production site
France
MDD
Production
Private labels
A critical Excel VBA file end of life

The entire quality control process relied on a single internally developed Excel VBA file, accumulating over 10 years of production history.

The situation before

!

Aging Excel VBA

Unstable macros, recurring bugs, permanent risk of data loss over 10+ years of history.

!

Laborious IFS audits

Each audit required significant team effort to manually extract compliance data.

!

No real-time traceability

No consolidated view of ongoing inspections. Data was only available after full entry.

!

Single-user

Only one user at a time could access the file. A permanent bottleneck at the quality workstation.

QualiKorn — the solution

Quality control tracking

Structured batch inspection entry with real-time validation and complete history.

Automated IFS Exports

Automatic generation of compliance reports for IFS and BRC audits.

Real-time dashboards

Quality monitoring dashboards accessible by all users simultaneously.

Complete traceability

Migration of 10 years of historical data and batch-by-batch traceability with built-in audit trail.

0
Major non-conformity
9 mois
From scoping to deployment
15 min
Quality reporting time
100%
Team adoption
Technical stack Qualikorn

Python web application deployed on-premise on the client's infrastructure.

OperatorsControl data entry
Quality ManagerValidation, exports
ManagementDashboards, KPIs
▼ ▼ ▼
Qualikorn — PythonWeb application · REST API · Responsive interface
PostgreSQLDatabase · 10+ years of history
On-Premise ServerClient infrastructure
IFS ExportsPDF · Excel · Audit trail
Python
Python
PostgreSQL
On-Premise
Measured impact at our food industry client

Before / After QualiKorn

Indicator
Before (Excel VBA)
With QualiKorn
Quality reporting
2 days / audit
15 minutes
Simultaneous access
1 user
Multi-user
Traceability
Scattered files
Complete audit trail
Risk of data loss
High (single file)
Secure database
Major non-conformities
Permanent risk
0 NC since deployment
Application screenshots

Non-contractual screenshots — interface subject to change.

Quality dashboard — Finished products
QualiKorn quality dashboard — inspections, compliance, CCP, product scoring
Qualikorn homepage
QualiKorn landing page — quality analysis and control solution
Dashboards & KPIs
QualiKorn dashboards — production indicators, interactive charts
Integrating Qualikorn into our quality control system has enabled us to improve our responsiveness, reduce tedious tasks, centralize data and, above all, analyze our results more meticulously. The software also has the ability to generate customized reports for all communications with our clients. In short, it is an intuitive tool that allows non-technical users to quickly become familiar with the interface, while enabling more experienced users to achieve an extremely advanced level of analysis.
RB
Rachid BEY — Laboratory and Quality Control Manager
Brüggen France

Learn more about Qualikorn

Why was an on-premise deployment chosen?

The client's production data security and confidentiality requirements mandated hosting on internal infrastructure. QualiKorn was designed to operate in this environment with no external dependencies.

How were the 10 years of historical data migrated?

We developed a dedicated migration pipeline that extracted, cleaned, and transformed all data from the Excel VBA file into the PostgreSQL database. Each record was verified to ensure data integrity.

Is QualiKorn adaptable to other industries?

The principles behind QualiKorn (quality control, traceability, audit exports) are transferable to any industry subject to compliance requirements: pharmaceutical, aerospace, packaging, and more. Contact us to assess your needs.

Why Bidev Consulting for this project?

The Bidev Consulting team has hands-on experience in food industry quality control. This in-depth knowledge of IFS processes and constraints enabled us to design a solution perfectly tailored to the teams' real-world needs.

Have a similar project?

Free 30-minute assessment — we evaluate your situation and propose a tailored approach.