Shopify doesn’t have a native bulk price editor. If you need to apply a percentage discount across a collection or adjust margins on 200 products at once, here are three options, each with a different set of trade-offs.
1. Edit prices manually in the admin
For stores with 15 or 20 products, manual editing works fine. Open a product, change the price, save it, move on. You see exactly what you’re changing before it goes live, and nothing can go wrong that you didn’t cause yourself.
It doesn’t scale. At 100 products you’re looking at an hour or two of repetitive clicking. At 400 products with multiple variants each, it’s a full day. There’s also no way to apply a percentage change without doing the math yourself on every product, and no way to schedule the change or revert it automatically. If you run a 48-hour flash sale, you’ll be resetting every price by hand when it ends.
Good for stores with small catalogs doing infrequent updates.
2. Export, edit, and reimport a CSV
Shopify lets you export your product catalog as a CSV, make changes in a spreadsheet, and import it back. For large catalogs, this is the fastest built-in option.
Go to Products, click Export, and download everything as a CSV. The column you want is Variant Price. In Google Sheets or Excel you can write a formula to apply a percentage change across every row at once, or filter by product type to target a specific subset. Then import the modified file back into Shopify.
The risks are real. The product CSV has a lot of columns, and editing the wrong one or accidentally deleting rows while scrolling through the file is easy to do. Products with multiple variants get a separate row per variant, so it’s easy to miss some. A formula applied to the wrong column pushes bad data to your store without any warning. And like manual editing, there’s no scheduling. You’re making the change when you run the import, and reverting means running another import.
Good for merchants comfortable in spreadsheets making a one-time bulk change.
3. Use a dedicated price editor app like Metra Price Automation
Apps built for this are more direct: select the products or collections you want to update, set a rule (reduce by 20%, increase by $10, set a specific price), and apply it. No spreadsheet, no clicking through individual product pages.
The main thing these apps add over the first two options is scheduling. You can set a sale to start and end at specific times, with prices reverting automatically when the window closes. That removes the manual step of resetting everything after a sale ends.
The trade-off is cost. If you update prices twice a year, a subscription probably doesn’t make sense. If you run regular promotions or manage seasonal pricing across large collections, the time you save adds up. Metra Price Automation handles scheduling and automatic price reverts. It’s what we built after dealing with this problem ourselves.
Good for stores that run regular promotions or need changes to revert on a schedule. It’s got a free plan for you to try so give it a shot.