Integrations · SAP B1 · Pipelines
Smaller automations that removed hours of manual work
- Key result
- ~70%
- less time in the SAP B1 sync
VIDEOPENDIENTEAnimación del diagrama orquestador / workers / callback (reemplaza al video en este caso) Animated pipeline with an orchestrator dispatching parallel workers
Case studies are anonymised: client names and data are omitted, and any screenshots use synthetic data.
Context and problem
My role
What I automated
SAP B1 sync pipeline
- Problem
A massive, slow synchronisation of products across branches. - Solution
Redesigned with an orchestrator / worker / callback pattern, parallel tasks, retries and checkpoints. - Result
~70% less sync time, with ~150,000 products across ~30 branches.
Bulk document upload
- Problem
Documents of ~500 products each had to be captured by hand. - Solution
Upload of ~500 products per file, with validation of existence and duplicates, and retries and checkpoints per item. - Result
Replaced manual data entry.
Inbound goods distribution
- Problem
Each incoming document was distributed by hand in a spreadsheet, taking ~1–2 hrs per document. - Solution
Automated the distribution of incoming goods. - Result
~6 documents a day, saving ~6–8 hrs a day.
Invoice stamping (CFDI) and bulk purchase orders
- Problem
PENDIENTEdescribe cómo se hacía antes del proceso de timbrado y carga de órdenes - Solution
Automated both, with error handling and status tracking. - Result
PENDIENTEcifra de impacto, si la tienes
Decisions and discarded alternatives
Sync pipeline architecture
- What I chose
An orchestrator / worker / callback pattern with parallel tasks, retries and checkpoints. - Alternatives I discarded
PENDIENTEalternativas que se evaluaron y por qué se descartaron - Why
PENDIENTEpor qué
Architecture
DIAGRAMAPENDIENTEDiagrama del orquestador, workers paralelos y callback Diagram of the orchestrator, worker and callback pattern
Results
- SAP B1 sync
Slow, massive sync ~70% less time (~150,000 products, ~30 branches) - Inbound goods distribution
~1–2 hrs per document ~6–8 hrs saved per day - Bulk document upload
~500 products per file, validated, with per-item retries
Technologies
ERP
SAP Business One
Patterns
Orchestrator / worker / callback Parallel tasks Retries and checkpoints
Other
PENDIENTElenguajes, colas, base de datos y servicios usados
What I would do differently
Demo
VIDEOPENDIENTECaptura o video corto de una ejecución del pipeline con datos sintéticos Demo of the sync pipeline with synthetic data