Ilmar MansurovAll case studiesRU

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.

The pricing workspace in Retail ERP

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.

Select products
Select products
Review proposed prices
Review proposed prices
Check margin impact
Check margin impact
Review margin drops
Review margin drops
Track approved prices
Track approved prices

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.

Before · competing columns and repeated controls
Before · competing columns and repeated controls
After · a clearer table with the recommendation at the point of action
After · a clearer table with the recommendation at the point of action
Customise the daily view
Customise the daily view

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.