Where spreadsheet edits go wrong
The flow is simple, but these three mistakes break the import:
Common Scenarios:
- Formulas instead of values: cells like =A1*1.1 export as formulas or blank when Excel recalculates.
- Accidental price rounding: .99 rules that quietly raise discounted prices.
- Header damage: Excel re-saves the header row in a different case or order.
Apply the rule without the spreadsheet risk
ShopTools' bulk price editor applies percentage or fixed changes to price, compare-at and COGS in the browser - with .99 rounding that never raises a discounted price - and exports a clean CSV.
Features:
- Percentage or fixed: One rule applied to every selected column
- Safe .99 rounding: Never raises a discounted price
- Margin view: COGS-aware so you see margin before importing