What goes wrong with manual CSV price edits
These mistakes are common when prices are edited by hand:
Common Scenarios:
- Currency symbols or commas in price cells import as 0.00.
- A percentage formula is copied into the wrong column.
- Sale price becomes higher than compare-at price after a discount.
- The file is saved in the wrong encoding and special characters break.
Update prices fast without breaking the catalog
ShopTools' bulk price editor applies percentage or fixed changes only to the price columns, supports .99 charm rounding and a minimum price floor, and exports a validated CSV. Use it when you want spreadsheet speed without spreadsheet risk.
Features:
- Rule-based updates: Percentage or fixed amount across all rows
- Margin protection: Flags sale prices above compare-at
- Clean export: Plain numbers, UTF-8 BOM, ready to import