Cleaning Product Attributes for a Fashion E-commerce Catalogue Migration
Attribute mapping and validation rules agreed before migration, so filters worked on day one.
Catalogue Migration Data Challenge
A new e-commerce platform needed structured attributes for filters, while the old catalogue held most of them as free text.
- Free-text colours and materials
- Missing categories
- Tight migration deadline
What Was Done Before the Catalogue Migration
Attribute mapping
Old values mapped to the new structure.
Validation rules
Blocking checks before import.
Exception list
Manual review of the remaining cases.
Catalogue Migration Results in Numbers
placeholder figuresattributes mapped
SKUs blocked at go-live
Tools Used in the Migration Project
Power Query mapping
Repeatable remapping of attribute values.
Excel exception lists
Owner and status per case.
Related Service: Product Data Quality and PLM Standardisation
Attribute dictionaries, mapping and validation rules for product data in PLM and e-commerce.
Filters only work if the data under them agrees.
Retail and Fashion Analytics Case Studies
Standardising Product Data Across European and Asian Markets in a PLM System
Multi-market fashion brand. One attribute dictionary replaced many local conventions.
Rebuilding the Womenswear Range Plan for a European Fashion Distributor
Option count cut by a fifth, depth moved into proven sizes and colours. Sell-through up, markdown down.
Building a Price Ladder and Margin Report for a Fashion E-commerce Retailer
Entry and exit prices per category, aligned across three markets and monitored weekly in Power BI.