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.
snapshot
- type
- Client automation
- period
- 2026
- source
- Private client project
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
Want something similar?
The source for this one isn't public. I can walk you through it if that helps.