For merchants, distributors & wholesalers
Fix the catalogue before it becomes a bigger operating problem.
When supplier files, identifiers, variants and historical imports stop agreeing, Aldervick reconciles the catalogue into a safer working dataset with unresolved uncertainty left visible.
Typical triggers
The problem is rarely “a CSV needs cleaning”.
Supplier sources disagree
SKU, barcode, option, image or availability values do not line up cleanly across files.
A migration exposes old mess
Historic catalogue decisions that worked in the old platform cannot be mapped safely into the new structure.
No one trusts the master
The team no longer knows which file or field is authoritative, making manual cleanup risky.
Example QA view
Conflicts remain visible until evidence resolves them.
A “clean” file created by guessing is worse than a messy file with a documented exception.
Catalogue exception register
Synthetic demonstration| Record | Issue | Evidence | Status |
|---|---|---|---|
| AB-100 / AB100 | Possible duplicate SKU | Barcode differs across sources | Review |
| SKU 1482 | Variant label mismatch | Blue / Blu | Resolved |
| SKU 2219 | Image reference missing | Source URL not retrievable | Exception |
| SKU 3044 | Barcode preserved | Authoritative export + supplier match | Checked |
Deliverables
A handoff another person can understand.
Work can include
- Supplier / multi-source reconciliation
- SKU, barcode and variant integrity
- Schema and field mapping against known target definitions
- Safe transformation and normalisation
- Image-reference reconciliation where technically feasible
- Shopify-ready import preparation
- Exception log, reconciliation summary and QA notes
It is not
- Generic data entry or cheap CSV cleanup
- Product fact invention or AI-generated catalogue content
- Routine feed management
- Permanent PIM / ERP administration
- Live-store change management by default
- Silent merges where product identity is ambiguous
Indicative pricing
Scope by data condition, not headline catalogue size.
Diagnostic
Catalogue assessment
Sample review, structural diagnosis and recommendation for a bounded remediation path.
Remediation
Bounded rescue
Defined remediation and QA for a catalogue with manageable source complexity.
Complex
Multi-source rescue
Higher reconciliation burden, multiple sources or significant exception handling. Quoted after review.
Have a catalogue nobody wants to touch?
Describe the sources, approximate scale, current platform and the decision or migration that is forcing the issue. We will assess whether the problem is bounded enough to take on.