Long numeric identifiers or leading-zero SKUs are silently reformatted before the file ever reaches the migration script.
CATALOG HORROR LIBRARY
Twelve boring ways ecommerce migrations go wrong.
No drama, no fabricated client stories—just recurring data failure patterns worth catching before production.
The same identifier appears under multiple parent products, making stock and variant ownership ambiguous.
A supplier uses 0 for both out-of-stock and “inventory not provided,” creating false certainty.
Some products use Size/Color while others reverse or rename options, breaking mechanical grouping.
A “CSV” contains commas, semicolons or embedded line breaks inconsistently across rows.
The catalog looks fine until remote image hosts block automated retrieval or expire signed URLs.
Whitespace, Unicode or capitalization makes values look unique to humans but collide after normalization.
A clean-looking number becomes dangerous when supplier, market and target shop use different currencies.
Variant rows arrive without enough information to reconstruct the product they belong to.
Business-critical attributes were packed into free-form tags with no stable schema.
A weekly export renames one column and silently shifts a previously working mapping.
Missing source meaning is converted to blank output instead of being surfaced as a question.
HAVE A WORSE ONE?