EDI Mapping App Case Study

Team:  Me as sole designer

Focus:  Full design process from research to execution

Summary

I undertook a practice project to design an EDI mapping application to build my eCommerce background. With no prior experience designing EDI software, I chose to follow Alan Cooper’s Goal-Directed Design process rigorously to ensure my work was grounded in solid research.

What is EDI Mapping?

EDI (Electronic Data Interchange) mapping is the behind-the-scenes process that connects one business’s eCommerce platform to another’s eProcurement system, allowing them to exchange structured business documents automatically and accurately. This gives buyers an experience not unlike purchasing on Amazon, but using pre-negotiated contracts and prices.

EDI mapping always involves three components:

  1. A source schema – the structure of data coming from one platform (e.g. a purchase order from Coupa)
  2. A target schema – the structure expected by the receiving platform (e.g. an 850 transaction set for a vendor’s ERP)
  3. A transformation map – the logic that translates source fields to target fields

These three components are grouped into Packages. Source and target schemas can be reused across multiple packages, but each transformation map is unique to its package since every trading partner relationship has its own unique data requirements.