Supplier Price Change Checker by SKU
Match supplier columns, check cost changes by SKU and choose which prices to approve. Your files stay on your device.
1. Match your columns
Start with the fictional candle range below, or choose your own CSV files. Both files must use GBP unit costs excluding VAT and the same pack size.
2. Review each price change
Approve the changes you want to keep in your review record. A missing SKU never becomes a deletion. A supplier-only SKU never becomes a new product.
| Approve | SKU | Previous £ | Supplier £ | Change % | Status and notes |
|---|---|---|---|---|---|
| CANDLE-01 | 7.5000 | 8.5000 | 13.33% | Needs review Increase exceeds 10%. | |
| N/A | CANDLE-02 | 8.0000 | 8.0000 | 0.00% | Unchanged |
| CANDLE-03 | 6.0000 | 3.8000 | -36.66% | Needs review Decrease exceeds 30%. | |
| N/A | CANDLE-04 | 5.0000 | N/A | N/A | Missing from supplier Keep current product. No deletion proposed. |
| N/A | CANDLE-05 | N/A | 7.0000 | N/A | Supplier only New supplier item. No product creation proposed. |
Percentages are truncated to two decimal places. Notes flag increases above 10%, decreases above 30% and a previous cost of zero. Costs retain four decimal places.
Before changing your catalogue
Use comma-separated UTF-8 CSVs, no larger than 2 MB each, with one unique, non-empty SKU per row. Map the SKU and cost columns separately for each file. Only GBP unit costs excluding VAT are supported. Check product and pack-size matches before accepting any price. Exports are review records, not platform import files.
Check pack sizes, currency and VAT basis yourself. This edition reviews GBP costs excluding VAT. It does not update stock, sale prices or a shop. Leading zeroes in SKUs are kept. Exported formula-like cells have an apostrophe prefix for spreadsheet safety.
How it works
CatalogDiff compares your current unit costs with a supplier’s new price file. Each file can have different column names and row order. Match the SKU and cost columns, then review changes before updating your shop.
- Choose the current catalogue and supplier files. Use GBP costs excluding VAT and verify both refer to the same unit or pack size.
- Map each file’s SKU and cost columns. Leading zeroes are preserved; duplicate or empty SKUs stop the review.
- Review changes individually. Increases above 10%, decreases above 30% and costs rising from zero receive a note. In the offline edition, save the mapping for next time and export the approved changes.
Worked example
The fictional candle example raises CANDLE-01 from £7.50 to £8.50 and lowers CANDLE-03 from £6.00 to £3.80. CANDLE-02 is unchanged. CANDLE-04 is missing from the supplier file and CANDLE-05 is supplier-only. Neither unmatched SKU is automatically added or deleted.
Will the export update Shopify?
No. The approved CSV is a review record with SKU and previous/new cost. Apply approved changes through your shop’s supported process. No stock levels, sale prices, products or tax rates are changed by this tool.
What does the offline edition add?
Up to 5,000 rows per file, reusable column mappings, saved reviews with approvals, a full CSV report, an approved-changes CSV and a printable HTML report. Both editions limit each input CSV to 2 MB. All processing stays on your device.
Can I use other currencies or prices including VAT?
This edition requires GBP unit costs excluding VAT. It does not convert currencies, remove VAT or reconcile different pack sizes.
Related tools
Method and examples reviewed 6 September 2026. These examples use the tool’s stated calculation rules, not measured customer outcomes.