← All articles

How to bulk edit prices in Shopify for a sale (and put them back)

Short answer

To bulk edit prices in Shopify, select products under Products, click Bulk edit, add the Price and Compare-at price columns, edit the cells and click Save. For hundreds of products, export a CSV, change the price columns and re-import with Overwrite products with matching handles. Shopify's docs describe no percent-off tool in the bulk editor, so calculate sale prices yourself and keep the export to restore them.

Key takeaways
  • The Shopify bulk editor edits Price and Compare-at price for many products and variants in one table, but its help docs describe no percent-off or formula tool.
  • A product CSV import with Overwrite products with matching handles replaces every column included in the file, and a blank cell overwrites the existing value as blank.
  • When a price CSV leaves out the Option1 name and Option1 value columns, Shopify creates a new default variant and deletes the existing variants.
  • Product CSV files can't exceed 15 MB, and an import can't be canceled once it starts.
  • A market catalog's Price adjustment changes every price in that catalog by a percentage, and by default applies to compare-at prices too.

To bulk edit prices in Shopify, select the products under Products, click Bulk edit, add the Price and Compare-at price columns, change the cells and click Save. For hundreds of products, export a CSV, change the price columns in a spreadsheet and re-import it. Shopify's help docs describe no percent-off tool in the bulk editor, so you calculate sale prices yourself, and the CSV you export first is what puts them back after the sale.

The edit is the easy half. The half that goes wrong is the restore: a sale ends on Monday morning and someone has to remember what 140 products cost on Thursday. This guide covers the four ways to change prices in bulk, the percentage math, the CSV mistake that deletes variants, and a clean way back.

Can you bulk edit prices in Shopify?

Yes, in four ways. Pick by how many products you're changing and whether you need a percentage.

Method Best for Percentage off? How you put prices back Plan or limits
Bulk editor Dozens of products, hand-picked prices No, you type each value (or fill a range with one value) Type the old prices back Any plan; avoid Microsoft Edge (URL length errors)
CSV export and import Hundreds of products, calculated prices Yes, with a spreadsheet formula Re-import the original export 15 MB per file; an import can't be canceled
Market catalog Price adjustment Every price in one market Yes, built in Remove the adjustment, or set the catalog back to draft Needs Markets; fixed catalog prices override it
Smart Pricing markdowns Slow sellers flagged by Shopify's model Suggested by the app Change prices again yourself Shopify app; needs 10+ products with 25+ sales a month each

The bulk editor and CSV import change the product's own Price and Compare-at price, which is what shows the crossed-out sale price on your storefront. A discount code or automatic discount is different: it changes the cart, not the product, so products keep their regular price on product and collection pages. If you aren't sure which one your sale needs, compare-at prices on Shopify explains the difference.

How to bulk edit prices with the bulk editor

Select the products, open the bulk editor, add the price columns and type. The steps come from Shopify's help docs.

  1. From your Shopify admin, go to Products.
  2. Filter the list to the products in the sale, for example by a collection, vendor, product type or tag.
  3. Select them with the checkboxes. To select more than 50 from a filtered view, click the checkbox at the top of the list, then Select all results in the selected dropdown.
  4. Click Bulk edit.
  5. Click Columns and add Price and Compare-at price. Each row is a product or a variant.
  6. Edit the cells, then click Save.

Three shortcuts save most of the time:

  • Fill one value into many cells. Click and drag across several cells, then type. The value goes into every selected cell.
  • Fill handle. Drag a cell's fill handle down or up to copy its value into the cells beside it.
  • Range select. Click a cell, hold Shift and click another to select everything between them.

None of these calculates a new price. The docs describe typing values, not formulas, so a "20% off" sale in the bulk editor means working out each price first.

If you see Update the invalid values, then save again, a row has a problem, possibly in a column you haven't displayed. Shopify's docs name a missing required SKU and metafield validation errors as the usual causes; add the SKU and metafield columns to find the row.

How do you change prices by a percentage in Shopify?

Use a CSV and a spreadsheet formula, or a market catalog's Price adjustment if the change is for one market. Shopify's help docs don't describe a percentage tool in the bulk editor.

In the spreadsheet, keep the original price, copy it into the compare-at column, and calculate the sale price from it. For 25% off with prices in column B:

  • Compare-at price: =B2
  • Price: =ROUND(B2*0.75, 2)

Decide on rounding before you start. Here's what 25% off does to a few real prices:

Product Regular price 25% off, exact Rounded to cents Rounded to .99
Wool beanie $28.00 $21.00 $21.00 $20.99
Leather card case $39.99 $29.9925 $29.99 $29.99
Linen napkins, set of 4 $22.50 $16.875 $16.88 $16.99
Canvas tote $64.00 $48.00 $48.00 $47.99

Rounding up to .99 can take the napkins to $16.99, which is less than 25% off. If your banner says "25% off everything", round down, not to the nearest .99.

For a single market, Shopify's catalogs have a percentage built in. Under Markets > Catalogs, a catalog's Price adjustment increases or decreases all prices in the catalog by a percentage, and by default also adjusts compare-at prices unless you turn off Include compare-at price. A price you set manually on a product in that catalog overrides the adjustment. A rollout can set a catalog to Active or Draft at a scheduled time, which our guide to scheduling a sale covers in more detail.

How to bulk edit prices with a CSV file

Export the products, change the price columns, and import the file with Overwrite products with matching handles turned on. Keep an untouched copy of the export; it's your way back.

  1. Go to Products, filter to the sale products and click Export.
  2. Choose Products that match your search and filters (or Products you have selected) and click Export products. Larger exports arrive by email. Exports with thousands of variants can time out, so split them by filter if that happens.
  3. Save a copy of the file named for the date, for example prices-before-sale-2026-11-27.csv. Don't edit this one.
  4. In the working copy, change Price and Compare-at price.
  5. Go to Products, click Import, click Add file and pick the working copy.
  6. Select Overwrite products with matching handles, click Upload and continue, review the preview, and click Import products.

Read the overwrite rules before you trim the file, because they're where price imports go wrong:

  • Required columns. When you update products, URL handle and Title must be in the file.
  • Option columns. If a column depends on variants, the Option1 name and Option1 value columns (and Option2, Option3 if you use them) must be in the file. Shopify's docs warn that without them, a new default variant is created and existing variants are deleted.
  • Blank means blank. A non-required column that's in the file but empty overwrites the existing value as blank.
  • Missing means unchanged. A non-required column you leave out of the file keeps its current value.
  • No edits to option values. Changing the Option value columns deletes variant IDs and creates new ones, which can break apps that rely on them.

The safest price file is the full export with only the two price columns changed. If you want a smaller file, keep URL handle, Title, every Option name and value column, Price and Compare-at price, and nothing else.

Two more limits: a product CSV can't exceed 15 MB, and an import can't be canceled once it begins. If you edit in Excel, check its export settings so the file still uses commas between values.

How do you put prices back after a sale?

Re-import the copy you saved before the sale, with Overwrite products with matching handles on. That restores every price you changed in one step, including variants you might have missed by hand.

Then check three things:

  • Compare-at prices. If the original export had empty compare-at cells, re-importing it clears the sale's compare-at prices too, because blank overwrites as blank. If you restore by hand in the bulk editor instead, delete the compare-at values completely. A compare-at price of $0.00 isn't the same as an empty field.
  • Products already on markdown. If some products had a compare-at price before the sale started, the original export restores those as they were. Typing prices back by hand is where they get lost.
  • Changes made during the sale. If someone edited a product's description or added a variant during the sale, re-importing the full original file overwrites those columns too. Trim the restore file to URL handle, Title, the option columns and the two price columns to leave everything else alone.

Spot-check a product page and a collection page afterward. A product whose variants have mixed compare-at prices can look on sale on its own page and full price in the collection grid.

Common mistakes when bulk editing Shopify prices

Most problems come from the restore, not the edit. Here's what to watch for:

Mistake What happens How to avoid it
No export before the sale Nobody knows the original prices Export the sale products first and don't edit that file
Price CSV without option columns Variants are deleted and replaced with a default variant Keep URL handle, Title and all Option name and value columns
Empty columns left in the import Existing values are overwritten as blank Delete columns you aren't changing rather than emptying them
Compare-at price typed as 0 after the sale Treated differently from an empty field Clear the cell completely
Rounding to .99 on a "25% off" sale Some products get less than the advertised discount Round down, or advertise "up to"
Fixed prices in a market catalog That market doesn't show the sale Set the market's prices in its catalog or by CSV
Importing during peak traffic The import can't be stopped once it starts Run it before the sale starts, then test

How Theme Scheduler helps

The bulk editor and CSV import are fine for a sale you start and end by hand. The work is doing it at midnight and remembering to undo it. Theme Scheduler does the timing and the restore: on the Plus plan ($12.99 a month) you pick products, whole or only chosen variants, and take a percentage or amount off, with the original price shown as the compare-at price. The same schedule can change sale tags, product status, images and the metafields your theme uses for badges, and menus can switch too.

Times use your store's timezone, everything switches back on its own when the sale ends, and you choose whether edits made during the sale are kept. Theme Scheduler is made by NewClick, not Shopify, and it doesn't create discount codes or automatic discounts. The Professional plan ($6.95 a month, 14-day free trial) schedules themes only.

Frequently asked questions

Can you bulk edit prices in Shopify? Yes. Select the products under Products, click Bulk edit, add the Price and Compare-at price columns and edit them in the table, then click Save. For hundreds of products, a CSV export and re-import is faster. A market catalog can also change all prices for one market by a percentage.

How do I change prices by a percentage in Shopify? Shopify's help docs don't describe a percentage tool in the bulk editor. Export your products to CSV, calculate the new prices in a spreadsheet (for 20% off, multiply by 0.8 and round), and re-import with Overwrite products with matching handles. For one market, a catalog's Price adjustment applies a percentage to every price in it.

Can I undo a bulk price change in Shopify? Shopify's help docs don't describe an undo for a saved bulk edit or a finished import, and a CSV import can't be canceled once it begins. The reliable way back is the CSV you exported before the change: re-import it with Overwrite products with matching handles, then clear any compare-at prices you added.

Why did my CSV price import delete my variants? The file was missing the Option1 name and Option1 value columns. Shopify's docs say that without them a new default variant is created and existing variants are deleted. Keep the URL handle, Title and every option name and value column in any CSV that changes prices.

How do I bulk edit compare-at prices in Shopify? In the bulk editor, click Columns and add Compare-at price next to Price, then copy each regular price into Compare-at price and type the sale price into Price. In a CSV, edit the Compare-at price column. To remove them later, clear the cells completely; $0.00 isn't the same as empty.

Sources

  1. Shopify Help Center: Bulk editing
  2. Shopify Help Center: Using bulk actions in your Shopify admin
  3. Shopify Help Center: Using CSV files to import and export products
  4. Shopify Help Center: Importing products with a CSV file
  5. Shopify Help Center: Creating catalogs for markets
  6. Shopify Help Center: Smart Pricing markdowns and markups

Set up your sale once

Theme Scheduler publishes your sale theme on time and, on Plus, puts products on sale and swaps menus, then switches everything back when the sale ends.

Get Theme Scheduler