Compare supplier pack prices by unit cost
Check whether a lower pack price hides a higher unit cost. Compare old and new supplier tables, flag pack changes and export a CSV review. No signup.
How do I compare prices when the pack size changes?
Divide each pack price by its pack quantity. Compare the resulting unit costs only when the supplier and SKU identify the same product, the unit has the same meaning and the currency matches. A lower pack price can still mean a higher unit cost.
Input requirements and report limits ↓Inputs
Copy a table from Excel or Google Sheets, including its header row, and paste it below. CSV/TSV files also work. Use “Map your columns” for different headers. IDs stay as text.
Free: UTF-8 CSV/TSV · 200 KB / 500 rows per input · 5 successful reviews per browser per day. CSV calculations run locally.
Need larger files or repeat batches? View editions →
Reuse a column profile
A profile stores column names only. It does not store your file contents.
Review report
Before you use this review
| Bring | Old and new price lists: supplier, sku, pack_price, pack_qty, unit, currency. |
|---|---|
| Match | Unique supplier + SKU in each file. Pack quantity must be positive; the product and base unit must be comparable. |
| Calculate | Unit cost = pack price ÷ pack quantity. A 100-unit pack at 20 costs 0.20 per unit; 50 at 12 costs 0.24. |
| Cannot establish | Comparable costs across different currencies or units. Freight, tax, discounts and changed product contents need separate review. |
In a synthetic example, $20 for 100 units is $0.20 per unit; $12 for 50 is $0.24, a 20% increase. Reproduce the calculation with downloadable CSV files.
Required inputs and matching
Both files need supplier, sku, pack_price, pack_qty, unit, currency. Map different column names as needed. Each supplier + SKU key must be unique, and pack quantities must be positive.
Interpret the report
The report shows unit costs, percentage changes, pack changes and added or missing rows. A unit or currency mismatch is flagged, not converted. A zero old cost has no percentage baseline. Missing rows do not prove discontinuation. Freight, taxes, discounts and product changes require separate review; this is not a purchase order.
Can I paste from Excel without exporting a file?
Yes. Copy the header row and data rows from each price list and paste them into the two input boxes. Keep supplier and SKU identifiers as text. The file picker accepts CSV/TSV, not Excel workbooks.
Why does the review ask me to map columns?
Your headings may differ from the required fields. For example, map Vendor to supplier and Units per case to pack_qty only when those columns have the same meaning. Pack price must be the price of the whole pack, not an already-calculated unit cost. If a field is missing, confirm it with your source before continuing.
What is the difference between case price and unit price?
Case price is the cost of the whole case; unit price is case price divided by the number of comparable units inside. Enter case price as pack_price and units per case as pack_qty. For a case containing inner packs, first confirm which unit the supplier means. Pack Audit does not infer nested packaging or convert kilograms to pieces.
Prepared by Supplier Desk Team · Updated . Examples are synthetic.
Who this is for
Small retail and wholesale operations teams reviewing supplier exports before changing catalog, stock or purchasing records. This is a focused review worksheet; it does not connect to your store or post transactions.
Related background
Read the source discussion or documentation. This describes the broader workflow. Use the input requirements and calculation rules above to decide whether this particular check fits your task.
Free tools with optional offline batch editions. Higher file limits, saved batch configurations and grouped report exports. No automatic store changes.