The risks of manual CSV price edits
These are the errors we see most often in hand-edited price CSVs:
Common Scenarios:
- Sale price ends up higher than compare-at price after a percentage discount.
- A formula is copied into the wrong column and overwrites titles or SKUs.
- Currency symbols or thousand separators reappear and import as 0.00.
- The file is saved in the wrong encoding and breaks non-English characters.
Protect margin while moving fast
ShopTools' bulk price editor applies one rule to every row, prevents discounts from raising prices and outputs a validated CSV. You keep the speed of bulk editing without the risk of spreadsheet errors.
Features:
- Column-safe rules: Only touches Variant Price and Compare At Price columns
- Margin guard: Prevents sale price from exceeding compare-at
- Clean export: Outputs plain numbers with no symbols or separators
How a bulk price editor prevents mistakes
- Upload the CSV and choose percentage or fixed adjustment.
- Set rounding rules like .99 charm pricing and a floor price.
- Preview every new price before it is written to the file.
- Download a validated CSV with clean numeric prices.
Manual CSV vs bulk editor
- Before: Manual: =B2*0.9 copied into title column, 12 rows wrong After: Bulk editor: rule applied only to Variant Price column
- Before: Discounted price 22.50 > compare-at 21.00 After: Editor rejects or flags prices above compare-at
Who should switch to a bulk price editor
- Merchants with large catalogs: One mistake copied across hundreds of rows is expensive
- Dropshippers updating supplier prices: Frequent price changes need reliable rules
Frequently Asked Questions (FAQ)
- Is editing prices in Excel really that risky?
- Yes - formula drag errors, overwritten columns and formatting issues are common when prices are edited manually in a spreadsheet.
- Can a bulk price editor handle charm pricing?
- Yes - ShopTools supports .99 rounding and floor prices so discounts stay clean and consistent.
- Will the editor change other columns?
- No - it only adjusts Variant Price and Compare At Price values, leaving titles, SKUs and other fields untouched.
- Do I still upload the result to Shopify?
- Yes - download the repaired CSV and import it through Shopify admin as usual.