Supplier Catalog Cleanup
Turn a supplier spreadsheet into a consistent, reviewable file. We map your source columns to your target layout, keep product identifiers intact, and flag records that need a decision.
What the work includes
Map the fields
Agree on your target column names, required values, and how to handle variants, units, and leading zeros in product codes.
Clean the catalog
Standardize formats, check for duplicate records, and flag conflicting or missing product details for review.
Review the handoff
Receive the prepared file, a field map, and a quality report. Store imports can be scoped separately.
See what changes in a catalog cleanup
In this sample, 12 source rows became 11 catalog rows. The workbook shows which records changed and which still need a buyer’s decision. The data is fictional.
| SKU | Source issue | How it was handled |
|---|---|---|
| 00101 | Extra spaces in the product name and an exact duplicate | Trimmed the name, removed the duplicate, and preserved the leading zeros in the SKU. |
| 00102 | Price stored as text with a CAD marker | Converted it to a number without changing the price. |
| 00104 | Missing price | Left it blank and flagged it for buyer confirmation. |
| 00105 | Two source rows disagree on price | Kept both rows and flagged the conflict for review. |
The Excel file contains three tabs: Original data, Cleaned catalog, and a Change log that references the source rows.
Download the sample Excel workbookWhat to send for a quote
Start with a small, redacted sample, the approximate number of products, and your target template or import requirements. Tell us if variants use separate SKUs or if any fields need to stay exactly as supplied.
Discuss your catalog project