Deduplication
Find and resolve duplicate SKUs and variants — merged with survivorship rules, never blindly.
Product data cleanup · done for you
We clean and standardize your product catalog — import-ready in days.
Send a messy Excel or CSV export. Get back a deduplicated, unit- and GTIN-standardized, import-ready file — for a PIM migration, a new webshop, or a marketplace — with a full change-log of every edit.
Pre-PIM migration prep
Deduplication
Unit & GTIN standardization
Category mapping
Import-ready feeds
A real clean, line by line
| SKU | Name | Size |
|---|---|---|
| 001 | widget A | 33cl |
| 001 | WIDGET a | 33 CL |
| 47 | gadget-b | 1,5L |
| 88 | Gadget B | — (missing) |
| SKU | Name | Size |
|---|---|---|
| 001 | Widget A | 330 ml |
| 047 | Gadget B | 1.5 L |
| 088 | Gadget B | ⚑ flagged — review |
| 2 deduped · units fixed · 1 flagged | ||
Every change logged, line by line — nothing merged or guessed silently.
What we clean
All services →Unit & GTIN standardization
Consistent units of measure and GS1 GTIN check-digit validation — bad barcodes flagged, not dropped.
Category mapping
Inconsistent or missing categories standardized to your own taxonomy.
Attribute completion
Missing fields filled from your sources or surfaced as a short decision list.
Format & currency normalization
Dates to ISO 8601, currencies to ISO 4217 minor units — one clean, consistent standard.
Pre-PIM migration prep
Catalog staged and validated so your PIM or platform migration doesn't stall on dirty data.
Built to named standards — not house style
GS1 GTIN (UPC / EAN)
ISO 8601 dates
ISO 4217 currency
ISO 3166 countries
UN/CEFACT Rec 20 units
Unicode / UTF-8
How it works
Full process →01
Send your export
Email your catalog as Excel or CSV — however messy. We agree scope and confidentiality up front.
02
We clean & verify
Deduped, standardized and validated, with a structured three-layer quality review — and anything uncertain flagged for your call, never guessed.
03
You get it back
An import-ready file plus a data dictionary, a per-cell change-log, and a findings report — in about five business days.
What you get, every job
01
A cleaned, import-ready data file
02
A data dictionary — every column explained
03
A per-cell change-log — original → cleaned → why
04
A findings report + a short decision list
Not a data-entry mill. A craftsman's clean — and you see every cut.
- Nothing changed silently. Every edit is in a per-cell change-log — original, cleaned, and the reason.
- Flagged, never guessed. Anything uncertain is surfaced for your confirmation, not silently overwritten.
- Reconciled in and out. No row quietly dropped, no value invented — the numbers tie out.
- Confidential by default. Your data is used only for your job and deleted after delivery.
Questions
What does CatalogSmith actually do?
You send your product catalog export — Excel or CSV, however messy. We return a clean, standardized, de-duplicated, import-ready file, along with a data dictionary, a per-cell change-log, and a findings report. It is done for you, usually in about five business days.
What is "pre-PIM" data readiness?
Pre-PIM data readiness is the work of cleaning and standardizing product data before it is loaded into a PIM system or new platform. Most PIM migrations stall on dirty data — readiness means the catalog is deduplicated, consistently formatted, and validated so the migration goes smoothly.
What format do I send, and what do I get back?
Send Excel or CSV; multiple sheets and separate supplier files are fine. You get back a cleaned file in the format you need to import, plus a data dictionary, a per-cell change-log, and a findings report, so you can see exactly what was done to every value.
Is my data safe?
Yes. Your data is treated as confidential, used only for your job, and deleted after delivery. Nothing is changed silently, and anything uncertain is flagged for your confirmation rather than guessed. We will also sign your NDA.
What does it cost?
Most engagements start with a fixed-price audit, then a full cleanup, then ongoing support if you want it. Before any of that, you can have 50 of your real SKUs cleaned for free, with no card and no obligation, so you can judge the quality first.
See it on your own data — free
Faraz Naqvi
Founder, CatalogSmith
You work directly with one accountable specialist — your whole catalog, start to finish, with no offshore queue and no handoffs. Every change is recorded in a per-cell change-log, so you can check the work line by line.
Will sign your NDA
Send a subset, not your whole catalog
Data deleted after delivery
No obligation, no card, no call
Free because it is the fastest way to prove quality