Apply a percentage increase to a whole price list
Paste rows from Excel or Google Sheets (with the header row), or a CSV. Pick the price column, the percentage and how to round. The result keeps every original column and adds a New price column, ready to paste back. Nothing is uploaded.
The formulas, if you would rather do it in the sheet
Put the percentage in F1 (4.5% as 0.045) and the price in C2, then fill down:
Nearest cent:
=ROUND(C2*(1+$F$1),2)Up to the next 0.05:
=CEILING(C2*(1+$F$1),0.05)Up to the next .99 ending:
=CEILING(C2*(1+$F$1)+0.01,1)-0.01Worked example: +4.5% on five fastener lines
| SKU | Description | Price | Nearest cent | Up to 0.05 | .99 ending |
|---|---|---|---|---|---|
| HX-210 | Hex bolt 3/8 x 2in (box 50) | $12.40 | $12.96 | $13.00 | $12.99 |
| HX-212 | Hex bolt 3/8 x 3in (box 50) | $15.85 | $16.56 | $16.60 | $16.99 |
| WS-038 | Flat washer 3/8 (box 100) | $4.10 | $4.28 | $4.30 | $4.99 |
| NT-038 | Hex nut 3/8 (box 100) | $5.95 | $6.22 | $6.25 | $6.99 |
| AN-500 | Anchor kit 1/2in | $27.30 | $28.53 | $28.55 | $28.99 |
Rounding is not neutral: on low-priced lines a .99 ending can add far more than the percentage you meant to apply. Check the biggest effective increases before you publish a list.
Going the other way, with a supplier's new list in hand? Compare it against the old one with the free price list compare tool, then use this page to apply your own increase to your sell 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.