How do I translate supplier categories to store collections and surface ambiguous or missing mappings?
Match parallel lists by exact case-insensitive category. Unequal key and collection counts cannot be aligned.
Open Collection CrosswalkTry the worked example
These are the example inputs from Collection Crosswalk. Replace them in the tool to run your own case.
| Supplier category | Observed SKU | Mapping keys | Store collections |
|---|---|---|---|
| Drinkware | CUP-1 | Drinkware, Tea | Cups, Pantry |
| Trays | TR-1 | Drinkware, Tea | Cups, Pantry |
Example result
TR-1 · Check · No mapping for Trays.
Who uses this?
Retail navigation editors. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Benchcraft adapted the reviewed merchant catalog readability audit idea for retail navigation editors. The rules and fictional example here were created for this tool.
Original video