PREPARE YOUR PRICE LIST

Is SKU 001 really the same as SKU 1?

A product identifier is a label, even if it contains only digits. Removing a leading zero can change its meaning. Before comparing prices, check that both lists preserve the supplier's original identifiers.

繁體中文 ↓

Three small differences worth checking

That does not prove they are different products. It means the tool lacks enough information to merge them safely. Confirm the supplier's identification rules before changing either file.

Prepare a comparison without guessing

1. Keep the supplier's original file. Make changes to a working copy.
2. Inspect a few identifiers in a plain-text view of the CSV, especially ones beginning with zero. The file contents matter, not just how a spreadsheet displays a cell.
3. Check both lists use the same identifier system. A supplier SKU and your internal catalog number are not interchangeable.
4. If formatting was changed, recover the original identifiers from an authoritative source. Adding zeros to every short number can create incorrect matches.
5. Compare the lists. Investigate unexpected added and removed rows before interpreting the price changes.

When you need a mapping table

If a supplier has deliberately changed product codes, retain an explicit old-to-new mapping verified against the product specification. This preview does not apply mapping tables or fuzzy matching. Prepare consistent identifiers in your own system first, or use a tool that supports that workflow.

Two rows sharing one identifier are another problem: the tool holds duplicate SKUs for review. Deleting a row without checking its pack size, specification and commercial terms can hide a legitimate distinction.

Compare your CSV files