Applied Product Research · 2026 · Workflow Systems

Recovering a Failed ERP/CRM Workflow for Retail Operations

Stakeholder interviews, workflow mapping, and process audit to recover a failed ERP/CRM implementation — realigning requirements, surfacing 20+ issues, and delivering 45 actionable recommendations.

Role Product Research Consultant
Method Stakeholder interviews + workflow mapping
Scale 6 workflows; 20+ issues; 45 recommendations
Impact Requirements realigned and further losses avoided
01 — Snapshot

Project Snapshot

Role
Product Research Consultant
Timeline
2026
Client Type
International Consumer Goods Company
Targeting overseas markets
Situation
Failed ERP/CRM Implementation
Recovery & realignment
Confidentiality
NDA — Client Anonymized
6
Workflows Mapped
5
Stakeholders Interviewed
20+
Issues Identified
45
Recommendations Delivered
What I did
Interviewed stakeholders, mapped workflows, audited process gaps, and translated findings into recovery recommendations.
What surfaced
A failed ERP/CRM implementation with missing backend logic, centralization gaps, and 20+ actionable issues.
What changed
The team realigned around real workflows, stopped further spend on an unrecoverable system, and reset implementation direction.
02 — Context

Overview

Engaged to diagnose a failed ERP/CRM implementation after two vendors could not deliver — auditing workflows, realigning requirements, and charting a recovery path before leadership committed further resources.

My Role
  • Product Research Consultant
  • Process Auditor
  • Workflow Researcher
Research Activities
  • Stakeholder Interviews
  • Workflow Mapping
  • Document & Contract Review
  • Process Audit
  • Stakeholder Readout
Outcomes at a Glance
  • Implementation direction recovered
  • Requirements realigned
  • Further failed investment avoided
Core Problem: The vendor had delivered mostly a frontend. Backend logic was not clearly wired. Multiple partial entry points for data existed, but the intended centralization — the entire reason for the system — had not happened. A significant prior investment had produced no functioning system, and a second vendor's salvage attempt also failed.

What the client wanted

  • Centralized customer records
  • Unified order processing
  • Live inventory visibility
  • Integrated invoicing and payment tracking
  • Management reporting

What was delivered

  • Mostly frontend UI
  • Backend logic incomplete or disconnected
  • Multiple partial data entry points, no integration
  • Disconnected workflows across functions
  • No central customer or order record
Stakeholders: 3 admin stakeholders, 2 staff members, the original and salvage vendors, and leadership deciding whether to commit further resources.
03 — Research

Research Focus

Objectives and guiding questions for the process audit.

01
Actual Workflows
Document how staff and admin really work today — and where it breaks down.
02
Requirement Gap
Establish what the client needed versus what was scoped with the vendor.
03
System Diagnosis
Identify what is missing or broken in the backend, and what a working system requires.
04
Viable Path Forward
Define the minimum realistic route to centralization within current constraints.
03 — Research

Research Approach

Three phases — from discovery through synthesis — each building on the last.

1
Discovery
Stakeholder interviews, document & contract review, system walkthrough with admin.
2
Mapping & Analysis
Six workflows traced, data-flow journey mapped, issue taxonomy built, requirements realigned.
3
Synthesis & Readout
45 recommendations developed, stakeholder workshop, renewed implementation roadmap.

Methods

Discovery & Diagnosis
  • Stakeholder & Staff Interviews
  • Document & Contract Review
  • Process Audit
  • Usability Review
Mapping & Synthesis
  • Workflow Mapping
  • Journey Mapping
  • Requirements Analysis
  • Stakeholder Readout Workshop
04 — Analysis

Analysis & Findings

Six core workflows mapped — all six disconnected or broken in the delivered system, with no central customer/order record linking them.



Customer
Records


Quotation
Workflow


Order
Processing


Inventory
Management


Invoice &
Payment


Reporting
Dashboard
Before / After Centralization Concept
Before: Scattered Entry Points
  • Customer data entered in multiple places
  • Orders tracked in separate spreadsheets
  • Inventory not synced to orders
  • Invoices disconnected from order records
  • No unified reporting possible
After: Central Record Design
  • Single customer record links all activity
  • Orders flow from quotation to fulfillment
  • Inventory updated on order confirmation
  • Invoices auto-linked to order records
  • Reporting draws from unified data layer

Key Findings

System
Frontend Without Backend

The delivered system was a UI shell without the backend logic to make any workflow function. A second vendor's salvage attempt failed because the architecture was inadequate — not just incomplete.

Root Cause
Centralization Never Happened

The unified customer/order record — the system's entire purpose — was never implemented.

Process
Requirement Misalignment

Vendor and client held fundamentally different understandings of what the system needed to do at each workflow stage.

Org Reality
Few People, Many Hats

A small team covered multiple functions, so workflows overlapped by necessity — but the system was designed for siloed departments that didn't exist.

Key Insight

ERP failures are requirement failures before they are technical failures.

Vendor and client were operating from different mental models of what "centralization" meant in practice. No amount of salvage engineering could fix a system scoped against the wrong understanding of the work.

05 — Outcomes

Outcomes

Research contributions that turned a failed implementation into a recoverable plan.

Deliverables

Map
Workflow Map

All 6 workflows documented with gap annotations.

Taxonomy
Issue Log

20+ issues categorized by type and severity.

Strategy
45 Prioritized Recommendations

Actionable, sequenced guidance for recovery.

Workshop
Stakeholder Readout

Findings presented to leadership for decision-making.

Design
Centralized Process Redesign

Proposed workflow redesign around a single customer/order record.

Roadmap
Renewed Implementation Plan

Phased path forward with vendor selection criteria grounded in real workflow needs.

Impact

Direction Recovered
Implementation direction restored after two failed vendor attempts
Requirements Realigned
Reframed around real workflows and centralization needs
Further Losses Avoided
Halted spending on an unrecoverable system before more investment was lost
Team Aligned
Staff, admin, and leadership aligned on what the system needs to do
06 — Reflection

Reflection

What this project revealed about systems research and vendor engagements.

What Worked
Mapping Beats Asking

Workflow mapping with admin revealed where data actually entered the system and where it got lost — abstract requirements interviews alone would never have surfaced it.

What Surprised Me
Two Vendors, Same Blind Spot

Both vendors built against an assumed departmental structure instead of how the small, multi-role team actually worked.

Key Takeaway
Map Before You Sign

Workflows must be mapped in operational detail before any ERP/CRM contract — and vendor scopes validated against those maps, not generic feature lists.

Back to Research Portfolio

View more applied UX, product, and marketing research projects.

← View All Projects