SUPPLIER PRICE COMPARISON
Compare the unit cost,
not just the pack price.
A supplier's new price can look lower even when each item costs more. Divide the price by the number of comparable units in the pack before deciding whether it is a saving.
A smaller pack can hide a price increase
| List | Pack price | Units / pack | Cost / unit |
|---|---|---|---|
| Previous | US$24 | 24 | US$1.00 |
| Updated | US$22 | 20 | US$1.10 |
The pack costs US$2 less, but the unit cost is 10% higher: (1.10 − 1.00) ÷ 1.00 × 100 = 10%. If the items differ in size, quality or specification, this price comparison alone is not enough.
Prepare two comparable files
- Use the previous and updated lists from the same supplier. Save each as UTF-8 CSV or TSV. Work on copies.
- Include an exact SKU, total pack price and whole-number units per pack. For prices already quoted per item, choose Already priced per unit (1).
- Keep currencies and the underlying unit the same for each SKU. For example, do not compare a kilogram with a gram or a net price with a tax-inclusive price. Convert the source data yourself first.
- Remove currency symbols from prices. Select the appropriate number format: 1,234.56 or 1.234,56. Both files must follow that format.
Run the comparison
- Open the comparison and choose both files.
- Check the SKU, pack-price and pack-quantity columns for each file. Similar-looking headings are not proof that the data means the same thing.
- Confirm the units and pricing basis, then select Compare unit costs.
- Review duplicate SKUs, missing values and invalid quantities first. They are excluded from cost comparisons; correct the original files and try again.
- Filter or search the findings. Export the full CSV report, or use the CSV text fallback if your browser blocks the download. The printed summary contains only the displayed rows.
Try a sample before your own data
Download previous CSV · Download updated CSV
Expected result: 3 increased, 1 decreased, 2 unchanged, 1 added, 1 removed and 2 needing review. SKU 001-TEA is the 10% increase above. SKU 002-COFFEE changes from 12 to 10 items per pack but stays at US$3 per item.
“Added” and “removed” describe whether a SKU is present in a file. They do not confirm availability or discontinuation. A zero previous price has no defined percentage increase. Case and leading zeros are significant: 001 does not match 1.
Use it without an internet connection
Download the free offline preview, extract all files, then open index.html in a current desktop browser. Keep the extracted files together. The comparison has no server, external scripts or account requirement. Links back to the online site need a connection.
The offline download is an evaluation copy of the same free preview. No paid edition, additional paid features or purchase flow is available.
When this tool is not enough
Use your spreadsheet or purchasing system for weighted units, multiple currencies, negotiated discounts, landed costs, ambiguous product identity, or vendor-specific matching rules. This preview does not parse PDFs or Excel workbooks, change your catalog, or replace checking the supplier's quotation.
繁體中文：比較真正的單件成本
例子：原本每箱 US$24，有 24 件，即每件 US$1；最新每箱 US$22，只有 20 件，即每件 US$1.10。整箱便宜了，但每件其實加價 10%。
- 將同一供應商的新舊價目表各自另存為 UTF-8 CSV。保留原檔，使用副本。
- 每份資料需要貨號、整包／整箱總價，以及每包／每箱件數。若報價本來就是單件價，選擇「已是單件價格（1）」。
- 確認相同貨號代表相同規格，兩份資料使用相同貨幣、基本單位及計價基準。本工具不會換算重量、容量、貨幣、稅項、運費或折扣。
- 在主頁選擇兩份檔案，核對欄位及數字格式後開始比較。重複貨號、缺失價格及無效包裝數量會標記「待核對」，不會猜測。
- 先修正待核對的資料，再檢視加減價結果。匯出 CSV 包含完整結果；列印只包含目前顯示行。若下載被阻擋，可複製完整 CSV 文字另存。
示範資料應得到：3 項上升、1 項下降、2 項不變、1 項新增、1 項移除及 2 項待核對。「新增／移除」不代表已確認的供貨狀態。貨號大小寫及前置零都會保留。
免費離線試用包解壓縮後，打開 index.html 即可使用，無須安装或註冊。本版尚未出售，不會收款。