Updating 500 prices one by one is the slow way. The CSV way takes minutes.

Change hundreds of variant prices at once: export a CSV, apply a percentage or fixed rule, and import it back. No app required.

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

The three steps

Export products from Shopify admin (Products > All products > Export).
Open the CSV and locate Variant Price and Variant Compare At Price columns.
Update prices row by row, or use a formula to apply a percentage change.
Remove currency symbols, commas and trailing spaces from every price cell.
Save as CSV UTF-8, validate with ShopTools and import back into Shopify.

Before and after

Before: Variant Price: 40.00, 20.00, 60.00 (500 rows to edit by hand) After: +10% rule applied: 44.00, 22.00, 66.00 (all rows, one pass)
Before: Discount 39.99 -10% -> 36.00 (naive rounding raises price) After: 36.00 stays 36.00 - .99 rounding never raises a discount

When you need this

Supplier price changes: Re-apply margins across the whole catalog
Seasonal promotions: Mark everything down for a sale window

Frequently Asked Questions (FAQ)

Does importing a CSV overwrite my prices?: Yes - Shopify updates existing products from the file. That is the point, and why you should review the preview before confirming.
Can I do this without an app?: Yes. Export, edit the CSV, re-import. This guide shows the safe way; a browser tool just removes the spreadsheet risk.
Which columns should I edit?: Variant Price, and Compare At Price if you use sales. Leave SKU and Handle untouched.
What if I only want to change some products?: Filter the CSV to the products you want, edit only those rows, and import - Shopify updates only what is in the file.
Can I round prices to .99?: Yes - use the ShopTools bulk price editor with .99 charm rounding enabled.