IFS quality control application developed for a food industry manufacturer. Replacement of a critical Excel VBA file in 9 months.
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)
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.
Python web application deployed on-premise on the client's infrastructure.
Before / After QualiKorn
Non-contractual screenshots — interface subject to change.
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.
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.