A customer says “not received” and the system says “delivered”: which record is wrong?

Often neither, and the first check is the date. In a public marketplace dataset, 57% of “not received” reviews on orders marked delivered were written on or before the recorded delivery day: late orders, not suspect customers. Put the claim and the delivery record on one timeline before judging anyone.

How it works

A rule that flags “delivered plus not received” treats every such claim as a conflict between the customer and the record. Two questions come first. When did the customer write, relative to the recorded delivery? A claim written before the delivery was recorded describes a late order, not a conflict. And does what is left concentrate at one origin more than chance allows? Only then is it worth looking at a seller, a carrier or a warehouse.

Evidence

I ran this triage on the Brazilian E-Commerce Public Dataset by Olist, 2016 to 2018. Of 95,824 delivered orders with a review, 2,708 had a review saying the order had not arrived. Of those, 1,542 (56.9%) were written on or before the recorded delivery day.

The 1,166 left are a conflict between records, but a crude one. In a hand check of 40 of those messages, 22 said the order never arrived; the other 18 were partial deliveries, wrong items, invoices and other matters, and one late delivery. Sellers explain little: 8 of 413 sellers with at least 50 orders sat above a 99% chance threshold, against at most about 4 expected by chance, and together they held 73 of the 1,166 conflicts.

What this does not prove

Sources

From the demo Which Record Lies? (code, tests and method)