rows written: 124 (120 orders + 4 duplicates)
revenue per month: {'April': 1538.6, 'May': 847.4, 'June': 1009.5}
revenue per category: {'Pantry': 1109.7, 'Drinks': 886.8, 'Home': 1399.0}
top product by units: Vinho Verde 750ml 42 | all: {'Flor de Sal 250g': 18, 'Piri-piri Sauce': 30, 'Olive Oil 500ml': 21, 'Olive Oil 1L': 17, 'Vinho Verde 750ml': 42, 'Ceramic Bowl': 40, 'Cork Coasters x4': 21, 'Sardines Tin x3': 23, 'Linen Tea Towel': 32, 'Ginjinha 200ml': 38}
grand total: 3395.5
duplicate order ids: ['PT-1027', 'PT-1075', 'PT-1085', 'PT-1120']
mismatched totals: [('PT-1010', 9.6, 8.4), ('PT-1028', 4.9, 1.9), ('PT-1037', 17.8, 16.6), ('PT-1039', 8.9, 7.7), ('PT-1101', 13.5, 18.5)]
blank qty: ['PT-1004', 'PT-1013', 'PT-1084']
blank region: ['PT-1055', 'PT-1104']
blank category: ['PT-1022', 'PT-1033', 'PT-1041', 'PT-1053', 'PT-1092', 'PT-1097', 'PT-1105', 'PT-1114']
text prices: 18 | messy names: 18 | dd/mm dates: 30 | 'Apr 5, 2026' dates: 12
--- alternates a tool may report ---
sum of Total column as-is (dupes + mismatches kept): {'April': 1536.2, 'June': 1029.3, 'May': 1052.3} grand 3617.8
deduplicated, mismatches kept: {'April': 1536.2, 'June': 1008.3, 'May': 849.4} grand 3393.9
rows per month if dd/mm read as mm/dd: {'April': 36, 'June': 29, 'December': 1, 'INVALID': 20, 'May': 32, 'August': 2, 'July': 2, 'February': 1, 'September': 1}
rows in file: 124