Enterprise Systems
Retail ERP: simplifying pricing work
I designed pricing workflows in ERP to move managers’ core tasks out of Excel, then simplified the table they use every day.
Problem and context
Category managers used Excel for pricing and assortment work. In 2025–2026, we were moving that work into ERP. The task was to connect product selection, price review and approval in one interface while keeping managers in control of prices and margin.
60% of managers’ core tasks moved from Excel to ERP · 2.5 hours saved per manager each week · 6 → 4 steps
My role
I defined the page structure with the product manager, then designed the workflows, interfaces and prototypes for usability testing.
From product selection to price approval
I connected product selection, recommended-price review and submission for approval in one workflow, with the calculation explanation beside each recommendation.
Managers see how a new price affects margin and can revise their selection or proceed when margin falls. Bulk actions support multiple products, and approval statuses keep submitted prices traceable.
Simplifying the daily table
I removed redundant columns, grouped the main actions in the header and let managers choose which columns to show. I kept the calculation explanation beside the recommended price.
Usability testing
We ran three rounds of moderated usability testing, with five participants in each round.
Outcome
60% of managers’ core tasks were moved from Excel to ERP. After implementation, each manager saves 2.5 hours a week, and updating prices takes four steps instead of six.