A CLOSER LOOK / SAMPLE HANDOFF
See what good order
looks like.
The source file, the cleaned catalog, and the thinking in between. Five fictional products show exactly what comes back to you.
Download the sample pack01 / THE AGREED RULES
Three rules.
A traceable result.
- Standardize product names. Use consistent capitalization and spacing. Normalize the illustrated side-table label without changing its meaning.
- Use agreed category labels. Map home / textile to Home textiles; KITCHEN and Kitchen to Kitchenware; furniture to Furniture.
- Flag missing information. Keep the unknown category empty and place the question in the decision list.
02 / THE DELIVERABLES
Every file has
a purpose.
Original supplier filebefore.csv · Untouched source valuesCleaned product catalogafter.csv · Same SKUs and row countCell-by-cell change logchange-log.csv · What changed and whyOne open questiondecision-list.csv · The category for CT-005Notes on the sampleREADME.txt · Rules, contents, and limitations
Ready to define your own cleanup?
Explore the $49 pilot