SheetCleaner LogoSheetCleaner
UseCase Solution

Deduplicate SKUs and Merge Inventory

Clean supplier catalogs, match different SKU formats, and aggregate inventory quantities.

100% Local Processing
Large File Ready
Instant Results
?

The Problem

Product data comes from multiple suppliers with different SKU formats. Same product has entries in different warehouses. Orders might be imported twice. Manual reconciliation is error-prone and time-consuming.

Our Solution

Match products by extracting core SKU numbers (regex: 'SKU-12345' → '12345'), aggregate inventory across warehouses, deduplicate orders while preserving the latest status. Sum quantities, average prices, count occurrences.

Key Features

Features optimized for this use case

SKU pattern extraction
Inventory aggregation
Order deduplication
Sum quantities
Average pricing
Multi-warehouse support

Download an SKU Deduplication Sample

Use two supplier catalogs to test regex SKU matching and inventory aggregation.

Rule: extract digits with \d+ for matching, sum Stock, preserve non-aggregated fields from the first row in each duplicate group, and pass unique rows through unchanged.
Supplier A catalog
First input CSV
Supplier B catalog
Second input CSV
Expected catalog
Aggregated result for comparison

How It Works

Complete data cleaning in three simple steps

Upload Catalog

Import product/order data

Match Products

Configure SKU matching rules

Export Clean Data

Get deduplicated catalog

FAQ

Common questions about this use case

Yes! Use 'aggregate sum' strategy to combine quantities for the same product across different locations.
Use regex to extract the core identifier. 'SKU-12345', 'sku12345', and '12345' can all be matched.
Keep the newest status with 'keep by newest date' strategy, using your order date or update timestamp column.

Ready to Clean Your Data?

100% free. 100% local. Your data never leaves your browser.