How to Change Shopify Prices in Bulk Without Mistakes

Change Shopify prices in bulk safely: the bulk editor, CSV price columns, compare-at prices, market prices, scheduling, testing a few products first and reverting.

In this guide
  1. Pick the right tool
  2. Compare-at prices: the sale price rule
  3. Scheduling
  4. A safe routine for bulk price changes
  5. Changes in several stores
  6. Where Storefleet fits
  7. FAQ

A price change across hundreds of products is a few minutes of work in Shopify. A wrong price change across hundreds of products is a few minutes of work too, and customers can check out at the wrong price before anyone notices.

This guide covers the tools Shopify gives you for bulk price changes, what each one is good for, and a routine that makes mistakes rare and recoverable: export first, change a few products, check, then change the rest.

Pick the right tool

Tool Good for Watch out for
Bulk editor Tens of products, a few columns, quick edits on screen Larger edits take longer; Shopify suggests CSV for big volumes
Product CSV Hundreds or thousands of variants, repeatable edits, a file you can keep Blank cells overwrite values; imports can’t be stopped once started
Market prices (catalogs) Different prices per country or region Fixed market prices override your base prices and compare-at prices
Launchpad or Rollouts Changes timed to an event Launchpad is Shopify Plus only; check what a rollout covers

The bulk editor

Select products in Products (or Collections, Inventory or Customers), then click Bulk edit. Use Columns to add the fields you need, such as price, SKU and compare-at price. Click Save; if errors appear, fix them and save again (Shopify Help Center).

Shopify notes that the more you change at once, the longer the save takes, and recommends CSV files for larger volumes.

The product CSV

The product CSV has a Price column for the variant’s price, a Compare-at price column for the original price when the price is reduced, and a Cost per item column. Enter prices without a currency symbol (Shopify Help Center).

Rules that decide whether a price import is safe:

  • When updating products, only URL handle and Title are required. If a non-required column is missing from the file, the existing value stays the same.
  • A blank cell in a non-required column that is in the file overwrites the existing value with blank.
  • Some columns depend on others. Include SKU without the option name and value columns and the variant option is deleted.
  • Changing Option1, Option2 or Option3 values deletes existing variant IDs and creates new ones (Shopify Help Center).
  • A product CSV can’t exceed 15 MB. Split larger files.
  • An import can’t be stopped once it starts, and there is no history of past imports. Check changes in the store’s activity log.

The practical conclusion: for a price change, export, then delete every column you are not changing except URL handle and Title. A file with only handle, title, the option columns needed to identify variants, and the price columns is much harder to get wrong than a full export. For how rows and variants map, see the product CSV guide.

Market prices

If you sell internationally with Shopify Markets, you can control market prices with percentage adjustments or by setting prices by country or region through catalogs (Shopify Help Center). The CSV has Price / [market] and Compare-at price / [market] columns for a fixed price in that market’s currency (Shopify Help Center).

Two facts matter for bulk changes (Shopify Help Center):

  • Fixed prices set for markets override the prices and compare-at prices in your admin. Change your base price and a market with a fixed price won’t follow.
  • Sale prices for international markets can’t be created in the admin; you import them with a CSV file.

Compare-at prices: the sale price rule

To show a sale, put the original price in Compare-at price and the lower price in Price. The compare-at price must be higher than the price for the sale to display, and your theme controls where it appears. Only the sale price shows at checkout (Shopify Help Center).

Common compare-at mistakes in bulk edits:

Mistake Result
Price lowered, compare-at left empty No sale badge; customers don’t see the saving
Compare-at set below the new price The sale doesn’t display
Old compare-at left after the sale Products look discounted at full price
Base compare-at changed, market fixed prices not International shoppers see the old prices

When the sale ends, you need both columns back: price restored and compare-at cleared or restored. Plan that file before the sale starts.

Scheduling

Shopify has no simple “change this price at midnight” field on a product. Options that exist:

  • Launchpad can change product pricing at the start and end of an event, and is available only on Shopify Plus (Shopify Help Center).
  • Rollouts schedule changes to the main theme, checkout and accounts pages, discounts and product catalogs. An Event rollout publishes changes for a set period and then rolls them back. Rollouts are available on Basic and higher (Shopify Help Center, requirements).
  • A discount instead of a price change. For a short promotion, a discount with start and end dates may be safer than changing prices at all. It expires on its own. See running the same discount across several Shopify stores.

If none fits, do the change by hand at a quiet time, with the routine below, and have someone available to check.

A safe routine for bulk price changes

  1. Export the products you will change. This file is your backup and your revert file. Name it with the store and date, and don’t edit it.
  2. Make a working copy with only the columns you need: URL handle, Title, the option columns that identify variants, Price and Compare-at price (and market price columns if relevant).
  3. Write the rule down. “All winter collection minus 20%, rounded to .99” is checkable. “Lower winter prices” is not.
  4. Apply the rule in the copy. Format price columns as numbers with two decimals; keep handle and SKU columns as text so a spreadsheet doesn’t change them.
  5. Check the copy. Sort by new price and look at the extremes: zero, negative, or higher than before. Count the rows: it should match the number of variants you meant to change.
  6. Test on three to five products. Import a file with only those, using Overwrite products with matching handles. Check them in the admin and on the storefront, including the sale badge and a test cart.
  7. Import the rest. Then spot-check a sample across collections, and every product with variants priced differently.
  8. Check markets. Open a few products in each market that uses fixed prices.
  9. Record what you did. File names, who approved, when it ran.

Reverting

To revert, import the untouched export from step 1 with overwrite selected. Because it holds the old Price and Compare-at price values, it restores both. A full export also resets every other column to how it was at export time. If someone has edited descriptions, tags or stock since, trim a copy of the backup to the same columns as your working file and import that instead.

If prices were changed through the bulk editor rather than CSV, you still want that export first: Shopify’s bulk editor documentation doesn’t describe an undo.

Changes in several stores

If you run more than one store, each store has its own catalog and its own prices, and there is no Shopify feature that applies one price change to all of them. Repeat the routine per store, with one revert file per store, and keep a table:

Store Export taken Test products checked Full import done Markets checked Checked by
Store A ✓ ✓ ✓ ✓ Name

Price changes are also a good thing to freeze close to a peak: see a change freeze for Shopify stores before Black Friday and changes across multiple Shopify stores. If an agency makes the change for a client, agree who approves price changes during client onboarding. Keep your price records after a sale as well: they help if a chargeback asks what the customer saw.

Where Storefleet fits

The approval levels in Storefleet Store Ops cover stock levels, discounts, refunds, cancellations, captures and product tags, not prices, so make price changes in Shopify with the routine above. For those other changes, each store’s change is previewed, approved for that store from one Approvals list, read back from Shopify after writing, and rolled back where Shopify allows. Nothing syncs between stores automatically. For approvals more generally, see approval workflows for live Shopify stores.

FAQ

What is the safest way to change prices on hundreds of Shopify products?

Export the products first as a backup, edit a copy that contains only the columns you are changing, import a few products as a test, check them, then import the rest with overwrite selected.

Will a blank Compare-at price cell in my CSV clear the compare-at price?

Yes, if the column is in the file and you import with overwrite. A blank non-required column overwrites the existing value. If the column is missing from the file entirely, the existing value stays.

Why didn’t my price change show in another country?

Fixed prices set for a market override the prices and compare-at prices in your admin. Update the market’s price columns or catalog as well.

Can I schedule a price change in Shopify?

Launchpad can change product pricing at the start and end of an event on Shopify Plus. Rollouts can schedule changes to discounts and product catalogs on Basic and higher. For a short sale, a discount with an end date is often simpler.

Can I undo a product CSV import?

Not with a button. An import can’t be stopped once it starts. Re-import the export you took before the change to restore the old values.

Sign in to your workspace

Each workspace has its own address: <workspace>.getstorefleet.com. Enter your workspace name, or paste its address, and we take you to its sign-in page.

You will go to

New to StoreFleet? Create a workspace