Bulk edit prices on Shopify

Shopify’s own bulk editor is a spreadsheet: it shows you the price field and expects you to type the new number into every row. That works for ten products. For a thousand, you need rules rather than typing — “take 15% off everything in this collection and round to .99” — and you need a way back if the rule was wrong.

Bulk Product Edit by MITS applies price rules to a filtered slice of the catalog, shows the calculation on a sample before it writes anything, and stores the previous price of every variant it touches.

Ways to change a price

• Change to — set the same price on every matched variant.
• Increase or decrease by amount — move every price by a fixed sum in your store currency.
• Increase or decrease by percentage — the usual way to run a sale or absorb a supplier increase.
• Adjust based on cost per item — price from cost by amount or percentage, which is margin pricing without a spreadsheet.
• Adjust based on compare-at price — derive the live price from the reference price you already keep.
• Round to — apply a rounding rule after the calculation so the catalog ends in the decimals your store uses instead of 17.4285.

Choosing which products get the new price

• By collection — the most common way to run a category sale.
• By vendor or product type — for supplier-wide or category-wide changes.
• By tag — if you already tag seasonal or clearance products.
• By current price — more than, less than, equal to; useful for price-band rules.
• By inventory — discount only what is actually in stock.
• By creation date — mark down products that have been sitting for a season.
• Filters combine with match all or match any, and you can preview the selection and exclude individual products before running.

A worked example: 20% off one collection for a weekend

1. Filter: collection is “Summer”, inventory quantity more than 0.
2. Editor: compare-at price → set the same as the price, so the original price shows as the reference.
3. Editor: price → decrease by 20%, round to .99.
4. Scheduler: start Friday 00:00, revert Monday 00:00.
5. Run it. The task changes the prices on Friday and puts every one of them back on Monday, without anyone logging in over the weekend.

If the rule was wrong

Every task keeps the old value of each field it wrote. Open the task, hit revert, and prices go back to what they were — or set the revert time up front and let the app do it on schedule.

The task log lists each variant with the old and new price, plus anything that was skipped and the reason, so a partial run is never a mystery.

Related guides