Client automation · 2026
Bol.com to DPD & Mail Merge Export Tool
A Python operations tool that turns Bol.com order data into DPD Excel exports and Word Mail Merge customer datasets.
Solo · built for one client's order workflow, tool code public
problem
A client needed a repeatable way to process Bol.com orders without manually preparing shipping spreadsheets, customer records, and re-export rules every time.
outcomes
- Reduced repetitive order administration
- Made export history explicit through local persistence
- Protected production workflows from test-data contamination
what i built
- Bol.com order processing workflow
- DPD-ready Excel export generation
- Word Mail Merge-ready customer dataset export
- SQLite persistence for imported and exported orders
- Duplicate prevention for already-exported orders
- Configurable filtering for orders older than 7 days
- Intentional re-export support for controlled reruns
- Production safeguards to keep mock data out of live exports
tech stack
PythonSQLiteopenpyxlExcel generationMail MergeBol.com order processingDPD exportsBusiness rule logic
Read the source
The repo has the code, structure, and implementation detail.