PhixFlow - Case Studies – PhixFlow
This site uses cookies in accordance with our privacy policy. By continuing to use this site, you agree to these terms. Learn more

Our clients – Tesco

Tracking orders within the online market place

Tesco shop

By Prazak (Own work), CC-BY-SA-3.0, via Wikimedia Commons

Retail Customer care, Order tracking

Tracking orders within the online market place

Tesco Direct were in need of a solution that could improve order tacking in the lead up to the high order volumes expected in Christmas 2014. With little time left before the end of the year, KPMG recommend PhixFlow as a company that could deliver results quickly.


  • Complex order tracking in 4 weeks
  • Thousands of orders saved
  • Partner dispatches monitored over time
  • Single view of order journey

Why track partner orders?

Online shopping systems for large retailers need to handle the complex behaviours of customers who can place multiple items in their baskets but after ordering may cancel some, return others and perhaps replace some items altogether after delivery. Add to this mix an online market place of external partners and suppliers let alone distributed internal warehouses and delivery channels, it’s not surprising that sometimes orders can get lost.

This was not a situation that Tesco were happy to accept as inevitable and, in striving for the best customer experience, asked PhixFlow to monitor the full order flow so that any problem orders could be quickly identified and corrected.

First results in four weeks

Initially engaged on a proof of concept project, one of our experienced data analysts delivered the first results within four weeks of turning up onsite. By using the PhixFlow platform he was able to concentrate on configuring a permanent solution for the business problem. The platform handled all the low level technical details of connecting to multiple databases, reading remote files and querying parcel tracking web services. PhixFlow drag and drop analytics put all this data together and revealed batches of orders occasionally being missed.

Very quickly I came to understand what PhixFlow was capable of and saw that the team delivered on what they promised. I use the term “same quarter solution” to describe my experience of working with them.

Natarajan Alagappan, IT Manager, Tesco Direct Finance Group

Three months later

The pilot turned into a full on deployment once the benefits of the PhixFlow platform were realised. Models were configured to examine all of the major order flows (new, cancelled, returned and replacement orders) between Tesco, partners and customers and PhixFlow now automatically alerts the relevant teams with any problems found. As an added benefit, PhixFlow monitored whether partners were dispatching orders on time and now emails them directly with details of late items and collates this information to monitor partner/supplier performance over time.

PhixFlow is now used at Tesco to address several other business requirements in which flexibility and speed of delivery was a key factor.