Order Match Wizard
The Problem
Orders leaving Shopify carried phone numbers and addresses that did not match what J&T expects. A parcel would ship, fail delivery, and come back as a return to sender. The store pays freight both ways and loses the sale, and staff were checking every order by hand against the courier's address list.
What We Did
We built the checking layer that was missing. Every order's phone is normalised to Philippine format and its address is matched against J&T's own reference data, with an alias system for the landmark spellings people actually type. Anything doubtful goes to a review queue where staff approve or correct it, and only then is it written back to Shopify, with a full audit trail. Shopify stays the source of truth, and nothing changes without a person agreeing to it.
98%
Of returns caused by address mismatch between Shopify and J&T, resolved
- 90 of 110
- Orders arriving with something to fix
- Every order
- Phone and address checked before dispatch
- Full trail
- Each correction tied to the person who made it








