CostLatch

Purchasing workspace · Free launch preview

Review a supplier update.

Find cost changes, duplicate SKUs and pack mismatches in two CSV lists. Review the exceptions, then export a complete report.

Files stay in your browserUp to 5,000 rows per listFull CSV exportNo ERP connection needed

01 / Bring your lists

Old list. New list. Same supplier.

Choose UTF-8 CSV files or paste their contents. Excel users: save each sheet as CSV first. Your files are processed in this tab and cleared when you reload.

01 Old price list

02 New price list

02 / Check your settings

Costs: positive numbers or zero, up to 4 decimal places. Remove currency symbols and thousands separators. SKU matching is case-sensitive and preserves leading zeros; surrounding spaces are trimmed.

Use the same currency, tax basis and pack size for each matching SKU. Map currency and unit columns when available. Missing unit columns mean matching units are assumed; CostLatch cannot verify the contents of a pack.

A repeatable review

From a supplier update to a checked price list

  1. Export two comparable lists. Use the same supplier and SKU scheme. Keep identifiers as text: 001 is different from 1. Export only one header row, followed by the product rows.
  2. Map columns on each side. The column names can differ. Choose the identifier and cost, then unit/pack and currency if present. SKU matches are exact after trimming surrounding spaces.
  3. Review exceptions first. A duplicate SKU can hide a variant. A case of 6 and a case of 12 cannot be compared as equal quantities. Ask the supplier to clarify before using those prices.
  4. Check the commercial result. Compare increases and decreases; check new and missing products. A target gross margin is a calculation based on input cost, not a guarantee of profit.
  5. Export and approve. Download the complete CSV, review it with your team and update your systems through their normal process. CostLatch never writes to your catalog.

Margin is different from markup

At an $11 cost, a 30% markup gives a $14.30 selling price. A 30% gross margin needs $11 ÷ 0.70 = $15.714…, rounded up here to $15.72. Tax, freight, platform fees and rebates are not included unless you already included them in cost. Add those costs before comparing when they matter to your decision.

Try a complete worked example

The fictional files contain one increase, one decrease, one unchanged SKU, one added SKU, one missing SKU and two review cases: a changed pack and a duplicate. Use “Load example” above or download the files.

Old list CSVNew list CSV

Free to adapt. These examples are not real supplier quotes and should not be imported into a live catalog.

Pricing & availability

Free launch preview. Complete reports.

Compare up to 5,000 rows per file and export every result for free. There is no account, card requirement or paid checkout today.

Working through supplier updates every month?

We’re evaluating saved column mappings and price history for repeat work. Tell us which step costs you time. Please describe the workflow rather than emailing confidential price files.

Share workflow feedback

Can I use Excel or PDF files?

Export an Excel sheet as UTF-8 CSV first. Direct XLSX import, PDF extraction and scanned price lists are not supported.

Does it match different suppliers?

No. Use stable SKUs from the same supplier. There is no fuzzy matching, product-name inference or automatic currency conversion.

Where do my files go?

Files and report contents stay in this tab’s memory. Reloading clears them. Optional analytics records counts and actions, never your files, SKUs, prices or reports.

Can it change my store prices?

No. The output is a review worksheet. You decide what to change and use your store or ERP’s normal update process.