Migrating a wholesale price list
Getting twenty years of customer-specific pricing into catalogs without a spreadsheet massacre.
The data is worse than they told you
Twenty years of pricing is never one table. It is a table, plus a column of hand-typed exceptions, plus an understanding two people have about a customer who gets the 2019 price on one product line. Extract all three before you model anything.
Every price nobody can explain is a conversation, not a migration step.
Model catalogs around who, not what
- 01One catalog per pricing behaviourNot per customer. Most lists collapse to a handful of real behaviours once the exceptions are pulled out.
- 02Exceptions as their own listKept visible and small, so the next person can see exactly what is unusual and why.