Python CSV Automation for Warehouse Dispatch

Independent demonstration with fictional warehouse exports.

Two warehouses export daily shipment CSVs. Before import, an operations team needs to catch duplicate shipments, resolve disagreements between files and keep a record of what was excluded.

This Python CLI validates file structure and shipment fields, normalises records, and produces an import CSV, an exception CSV and a JSON reconciliation report. It preserves source files, keeps one copy of identical shipments and sends all conflicting versions of a shipment to review.

Verified sample run: 3 exports checked, including 1 rejected legacy layout. Of 13 parsed records, 8 were accepted and 5 were excluded. Accepted shipments total 21 parcels. Automated tests verify reconciliation, rejection of a malformed file and protection against overwriting existing output.

For a similar project, share a redacted export, the destination schema and your rules for duplicates and exceptions. I can scope a small pilot around one export format and a reviewable handover.