← All guides

How to bulk edit Shopify prices without CSV (and undo it if it goes wrong)

Changing the price of one product in Shopify is easy. Changing the price of 500 is where it gets painful - and where a lot of merchants reach for a CSV export, edit it in a spreadsheet, and re-import it, only to discover a reformatted column or a stray comma has quietly broken part of their catalog. This guide covers the three realistic ways to bulk edit prices in Shopify, what each is genuinely good at, and the exact point where it stops being good enough.

Option 1: Shopify's built-in bulk editor

Shopify's admin has a bulk editor built in, and for small changes it's the fastest free option.

  1. In your admin, go to Products.
  2. Tick the checkboxes next to the products you want to change.
  3. Click Bulk edit at the top of the list.
  4. Click Columns, add the Price column, type the new values, and click Save.

Where it runs out of road: the native bulk editor works on the products on the current page, so on a large catalog you're editing in batches and losing your place between pages. There's no “take 20% off” - you type each new price by hand. There's no preview of what's about to change, and no real undo: once you Save, rolling back means remembering the old numbers and typing them back in. For a handful of products it's fine. For a seasonal sale across a few hundred, it's a long afternoon.

Option 2: Export to CSV, edit in Excel, re-import

The CSV route is the classic way to change prices in bulk, and it can move a lot of rows at once.

  1. Go to ProductsExport and export your products as a CSV.
  2. Open the file in Excel or Google Sheets and edit the price columns.
  3. Go back to ProductsImport and upload the edited file, overwriting existing products.

The risk: the CSV is the whole catalog, not just the rows you wanted to touch. A spreadsheet app can “helpfully” reformat a price, drop a leading zero, or change how variants line up - and you won't see the damage until after the import has written it to your live store. There's no preview and no one-click rollback. Plenty of merchants have wiped variant prices on hundreds of products this way and spent a weekend putting them back. If you only need a price change, exporting and re-importing your entire catalog is a lot of risk for the job.

What you actually want

For a routine price change, the ideal is: filter down to exactly the products you mean, change them in place, see what's about to change before it saves, and undo in one click if a number looks wrong. No full-catalog export, no import step, no guessing.

Option 3: Edit prices inline, with preview and undo

This is the approach BulkSheet takes - a spreadsheet-style grid inside your Shopify admin, without the CSV round-trip.

  1. Open the bulk editor and filter your catalog - by tag, vendor, status, price range, inventory, or whether a product is already on sale - so you're looking at only the rows you want to change.
  2. Apply a price template - a percent or fixed discount, a price increase, or a compare-at anchor - across every selected product at once, with optional .99 or whole-number rounding. Or type into individual price cells like a spreadsheet.
  3. Preview the change: how many rows will change and a sample of old → new values, before anything is written to Shopify.
  4. Press Save. If a price looks wrong, step back with Undo (Cmd+Z) - in your current session on any plan, or across sessions on Growth and Pro. The whole batch is a single undo step.

Because nothing is written until you Save, and the entire batch can be undone, a mistake never has to reach your storefront. You can read exactly how that safety net works on the your catalog is safe page.

Bonus: schedule a sale that ends itself

If the price change is a sale, you don't have to remember to turn it off. On paid plans you can schedule a discount with a start time and an auto-revert time: the prices change in the background when the sale begins and restore themselves automatically when it ends - useful for weekend and flash sales. See how to schedule a Shopify sale that ends itself.

Frequently asked questions

Can I bulk edit prices in Shopify for free?

Yes - Shopify's native bulk editor is free, and BulkSheet's free plan includes up to 100 product saves per day. The free options work well for small batches; large or repeated price changes are where the paid, unlimited-save plans pay off.

Will bulk editing prices break my variants?

It can, with CSV imports, if the file is reformatted. Editing inline avoids that: you change the exact cells you mean, preview the result, and undo if anything looks off. Variants are edited in their own rows.

Can I undo a bulk price change after I've saved it?

With the native editor or CSV, not easily. With an inline editor, yes - undo steps back through changes (even across sessions on paid plans), and Pro merchants can revert an already-saved batch from edit history.

Not sure the native editor is holding you back? See what to do when Shopify's native bulk editor isn't enough. Ready to stop round-tripping CSVs? Install BulkSheet - it's free to start - or compare plans on the pricing page.

Stop round-tripping CSVs. Edit live.

Install BulkSheet on your Shopify store in under a minute. Free forever - 100 product saves a day.

Install on Shopify