Internal applications In production

MP Suppliers

Matching large catalogs to the ERP while keeping conflicts visible and controlled.

Internal platform to match supplier catalogs with ERP products and review conflicts in references, barcodes and prices.

Role: Analysis, architecture, backend, integration and UX
Period: 2025
Type: Aplicación interna

Technologies

PHP Laravel MySQL Dolibarr

Visual evidence

1 video · 13 screenshots

Demo video 1 / 14

Context

In a purchasing environment with multiple suppliers, catalogs arrive in different formats and must be checked against the ERP (Dolibarr) before prices or product data are updated.

The problem

Matching supplier catalogs with ERP products was manual, slow and error-prone. The same barcode could map to different references. Conflicts were lost in spreadsheets and there was no clear flow between safe matches and doubtful cases.

My responsibility

Functional analysis, architecture, data modeling, backend, review UI and match/conflict criteria.

The solution

A tool that imports and normalizes catalogs, validates references and EANs, generates matches, separates safe from doubtful cases and allows human review before controlled price updates.

How it works

01

Importación del catálogo

Carga del archivo o fuente del proveedor.
02

Normalización

Homogeneización de campos, referencias y formatos.
03

Validación de referencias y EAN

Detección de datos incompletos o inconsistentes.
04

Generación de coincidencias

Emparejado con productos del ERP.
05

Separación seguros / dudosos

Los conflictos quedan visibles para revisión.
06

Revisión humana

Interfaz para resolver casos ambiguos.
07

Actualización controlada

Aplicación de cambios de precio o ficha con trazabilidad.