Free price list tools and guides
Everything here is free and runs in your browser. Start with the compare tool if you have an old and a new supplier list; use the calculators and guides for what comes next.
Free tools and calculators
- Compare two price listsPaste an old and a new list, see every increase, decrease, new and dropped SKU.
- Price increase calculatorOld and new price to percentage change, per unit and per year.
- Margin impact calculatorCost up X%: new margin, new sell price, extra volume needed.
- Markup vs margin converterMarkup to margin and back, plus the price for a target margin.
- Landed cost calculatorPer-unit landed cost (goods, freight, duty, fees) before and after.
- Bulk price increasePaste a list, apply +X% with rounding, copy the result back.
How to compare price lists
- Compare in ExcelXLOOKUP and VLOOKUP formulas, highlighting, missing SKUs.
- Compare in Google SheetsARRAYFORMULA lookups, IFERROR, highlighting and FILTER.
- New and discontinued SKUsCOUNTIF and FILTER both ways, plus renumbered items.
- Columns in a different orderLookups by header name that survive moved columns.
- SKU leading zeros and formattingKeep leading zeros, normalise dashes and spaces, avoid collisions.
- Compare CSV price filesDelimiters, decimal commas, quoting and encoding done right.
- Check a price increase letterExpected vs actual per line, and your weighted increase.
Price increases by type of buyer
- For distributorsRank by gross profit at risk, reprice, size locked-price exposure.
- For contractorsRe-price a takeoff, job margin impact, escalation above a threshold.
- For retailersTarget-margin retail prices, rounded to .99, checked.
- For MRO purchasingAnnual usage, weighted increase and budget variance.
Which one do I need?
- You have last quarter's supplier list and the new one: compare them to get every change.
- You know the change and want to know what it costs: the price increase calculator or the margin impact calculator.
- You want to do it in your own spreadsheet: the Excel or Google Sheets guide.
Get this done for you every time a supplier sends a new list.
Pricecheck takes the supplier's email as it arrives, PDF included, compares it with the last version and sends back only the lines that moved. $49/mo, first month free for early signups. No payment now.