Contact person: Business Client

Phone:Show

Email:Show

Location: rozzano, Italy

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project Description
We are a food manufacturing group developing a complete Recipe and Product Management System to centralize the entire process of formulation, costing, nutritional calculation, allergen tracking, packaging, certifications, and technical documentation.

The platform will consist of two main portals connected to a single shared database:

Internal Portal ([login to view URL]):
Used by our internal teams (R&D, Quality, Production, and Sales) to manage recipes, ingredients, suppliers, prices, certifications, allergens, and documents. This is the operational “core” where all recipes and data will be entered, verified, and approved.

Client Portal ([login to view URL]):
Will be implemented in a later phase. It will be used by our clients (B2B buyers, pastry shops, gelaterie, distributors, and private label partners) to access product information, download datasheets, view personalized price lists, place orders, generate private label labels, and track loyalty points.

The current tender covers only Step 1 – the Internal Platform, which will form the foundation of the entire system.
Once the internal database and management module are complete, the second phase will extend this data to the external customer portal.

The system must be built with open technologies, be fully modular, and allow our in-house engineer to modify or extend it in the future. All source code and intellectual property will belong to the client.

STEP 1 – Internal Platform

This first phase focuses on creating the internal management system for approximately 1,600 recipes, which are currently stored in Excel format. The import will be manual after the system is built.

Main Objectives

Centralize all recipes and ingredients in a PostgreSQL database.

Automate cost, nutritional, and allergen calculations.

Manage supplier data, certifications, and packaging.

Generate multilingual technical datasheets (PDF/DOCX).

Enable versioning, approval workflow, and traceability.

Provide a clean web interface for daily use by internal staff.

Technical Requirements

Backend: Python (FastAPI preferred) or Django

Database: PostgreSQL

Frontend: React or Django Templates

Authentication: JWT or SSO-ready

Storage: S3/MinIO for images and documents

Hosting: Linux environment (Ubuntu/Docker)

Documentation: Swagger/OpenAPI, clean code comments, setup guide

Modules to Develop

Database structure for:

Recipes (code, name, brand, process, yield, department)

Ingredients (supplier codes, description, nutritional values, price history)

Allergens (EU 14 list, bold/contains/may contain logic)

Certifications (Kosher, Halal, Vegan, Organic, Gluten Free, Lactose Free)

Packaging data, EAN/GTIN, HS/TARIC codes

Nutritional data (macro and micro nutrients, kcal/kJ, PAC/POD/SLNG)

Media (images, PDF, video links)

Automatic cost and nutritional calculations.

Recipe scaling engine (e.g., for 800 kg batches).

Versioning system for recipes.

Workflow: Draft → Review → Approved → Published.

Role-based access control (Admin, R&D, Quality, Sales).

PDF/DOCX datasheet generator (multilingual templates).

Media upload system (images, PDFs, videos).

REST API for future ERP integration.

Open-source, editable structure for in-house modifications.

STEP 2 – Future Expansion (Not Included in this Contract)

This first contract covers only the internal system.
Future development will include:

B2B customer portal for clients and distributors.

Online orders, invoices, loyalty system, and stock management.

Customer recipe balancer.

Private-label labeling system.

Global labeling compliance (EU/FDA/CFIA/FSANZ).

ERP integration.

Dashboards and business analytics.

Developers are requested to quote only for Step 1.

Deliverables for Step 1

Complete PostgreSQL schema and migrations.

Backend (API) and web interface for recipe management.

Costing and nutrition calculation engines.

Versioning, workflow, and RBAC implementation.

Media management for images, PDFs, videos.

PDF/DOCX datasheet generation (multi-language ready).

Swagger/OpenAPI documentation.

Source code and deployment manual.

Responsive, user-friendly UI.

Review and basic training for our internal engineer.

Collaboration and Ownership
The project will be supervised by our internal IT engineer.
The system must be open, modular, and editable, allowing future internal extensions.
Clean, well-documented code is mandatory.
Full ownership of the code and rights will be transferred to the client upon completion and payment.

Budget and Timeline
Please include:

Total cost for Step 1 (internal module only)

Estimated development time (in weeks)

Team composition and relevant experience

Workflow description (Agile/Scrum preferred)

Mandatory Video Presentation
Only proposals that include a short presentation video (2–5 minutes) will be considered.

The video should demonstrate:

Your proposed development approach (architecture and technology stack).

A similar project or example system you have developed.

A high-level database structure proposal.

A brief mockup or UI demo (even basic).

Proposals without a video presentation will not be evaluated.

Selection Criteria

Proven experience with Python (FastAPI/Django) and PostgreSQL.

Strong background in database design and modular architecture.

Previous ERP or manufacturing-related projects (preferred).

Clarity, documentation, and code organization.

Realistic timeline and budget.

Professional video presentation.

Application Instructions
Please include in your proposal:

A short introduction of yourself or your team.

Confirmation that you can deliver Step 1 as described.

Timeline and cost estimate.

Link to your presentation video (YouTube, Vimeo, or Google Drive).

Only complete and video-supported proposals will be considered.

Additional Notes

This project covers only Step 1 (Internal ERP Module).

All source code and documentation must be delivered at the end of the project.

All rights to the software will belong to the client after payment.

Communication in English is required.

Collaboration with the client’s internal engineer is part of the process." (client-provided description)