CHECK THE INPUT FIRST
A price report is only as useful as its unresolved rows.
Before sorting the largest increases, review the rows the tool could not compare. An invalid price or ambiguous product code should not quietly become a zero or a guessed match.
What to check and how to resolve it
| Finding | Possible cause | Next step |
|---|---|---|
| Duplicate SKU | Two pack options share a code, or a row was repeated | Verify product and pack identity; do not simply keep the cheapest row |
| Missing or invalid price | Blank, currency text, unsupported format | Check the quotation and chosen number format; a blank is not a free item |
| Invalid pack quantity | Zero, negative, fractional or missing item count | Provide a positive whole-number count, or use per-unit pricing if that is the actual basis |
| Added or removed | A SKU occurs in only one file | Check for changed identifiers; do not assume availability or discontinuation |
Zero is not the same as missing
If the previous unit price is zero and the new price is US$2, the absolute difference is US$2. The usual percentage formula divides by the old price, so the percentage increase is undefined. Do not report it as 200% or as a normal increase from a positive baseline.
A five-minute review order
- Confirm currency, underlying unit and pricing basis are comparable. The tool cannot detect every mixed-currency or specification error.
- Resolve duplicate identifiers and invalid rows in a copy of the source.
- Run the comparison again, then investigate unexpected added and removed SKUs.
- Review pack changes and unit-cost increases together. A lower pack price can still mean a higher unit cost.
- Save the full report alongside the two original lists. Do not treat a filtered printout as the full report.
Practice with known results
The previous sample and updated sample are fictional. They produce 3 increases, 1 decrease, 2 unchanged, 1 added, 1 removed and 2 rows requiring review. Use them to understand the findings before comparing business data.
先處理待核對資料，再看加價排名
空白價格不能當作零元；同一貨號出現兩次，也不能隨意選較便宜的一行。先核對原始報價、產品規格及包裝數量，修正副本後再比較。
原價為零時，加幅百分比沒有定義。例如由零元變兩元，金額增加兩元，不能說加價200%。新增／移除只描述貨號是否存在於檔案，不代表供貨狀態。
建議順序：確認幣別及單位 → 修正重複與無效資料 → 核對新增／移除 → 檢查單件加幅 → 保存完整報告及原始檔。