Public-Data WorkflowSample Delivery
Product Catalog Cleanup — 10k SKUs
Not a client project — public-data demo
Task
Normalize 10,000 SKUs — de-duplicate, map categories, standardize variants, colors and pricing.
Input
Shopify CSV (10,240 rows, 8 category trees), taxonomy rules, variant mapping (size/color), price validation.
Workflow
- Import & profile SKUs, detect duplicates (SKU + title fuzzy)
- Map categories to canonical taxonomy
- Normalize variants, colors, sizes per rules
- Validate pricing & flag outliers
- Export CSV + change log
Output
Clean CSV — 10,000 SKUs (240 duplicates removed), categories mapped, variants normalized, ready for import.
Time
7h 50m
Cost
$78
Deliverable
CSV + change log · $10/hour
Related: Data Cleaning · E-commerce Service