Product catalog workflow

How to compare product lists across suppliers and stores

A practical approach to reconciling product catalogs and supplier SKUs, finding delisted products, and reviewing duplicate source records.

5 min readBy Comparable List Editorial Team

Prepare → compare → reviewPrivate, local list reconciliation

A useful list comparison starts with a clear decision, not an upload. This workflow keeps the comparison in your browser and makes the matching rules visible, so the resulting exception list can be reviewed rather than blindly acted upon.

1. Choose the matching field

Prefer a stable product ID or supplier SKU over a title. Product titles change frequently and may describe variants inconsistently.

2. Prepare comparable sources

Export active products from comparable channels and use one identifier per line. Record which catalog and date each export represents.

  • Use exports created for the same scope and approximate date.
  • Keep the original source files untouched for audit and recovery.
  • Compare one meaningful field at a time instead of mixing identifiers.

3. Normalize intentionally

Use the SKU preset when codes contain formatting differences. Preserve leading zeroes if they are meaningful; use the ID preset only after confirming they are padding.

4. Review the result before acting

Common values confirm the shared catalog. Only in A and Only in B reveal catalog gaps, while the duplicate audit exposes repeated supplier records.

Ready to check your data?

The tool runs locally in your browser. Review the result before you act on it, especially when a list contains customer, account, or operational data.

Open product list compare

Frequently asked questions

Does this comparison upload my list?

No. The comparison, normalization, audit, and export happen in the browser tab. A share link is an exception: it intentionally encodes list data in the URL, so do not use it for confidential information.

Should I turn on every cleaning option?

No. Use only rules that preserve the identity of every item. Review the Common result and the suggested normalizations before exporting or acting on a difference.

Can I keep this workflow for next time?

Yes. You can save a local template with the selected options, or save a result summary in this browser. Full source lists are never stored unless you explicitly choose that local-device option.

Related tools and guides

Need a spreadsheet column selector? Try CSV & Excel compare. For a general workflow, return to the two-list comparator or browse all data-cleaning guides.