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.
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
Customer-focused workflow decisions based on business rules
Tech stack
PythonSQLiteopenpyxlExcel generationMail MergeBol.com order processingDPD exportsBusiness rule logic
Private client work
This project is described as a case study because the client implementation is not published as a public repository.