How to change prices in bulk on Shopify

Whether you are running a sale, passing on a supplier increase or repricing a category, the shape of the job never changes: decide what to change, decide how, decide when, and decide how you will check it afterwards.

1. Decide the selection before the rule

The single most common bulk editing accident is a rule that was right applied to products that were wrong. Start with the filter, look at the count, and read a sample of what it matched. If the count surprises you, the filter is wrong — not the count.

• A collection is the most reviewable filter, because someone already decided what belongs in it.
• Add an inventory condition so you never promote what you cannot ship.
• Exclude protected products with a “does not contain” tag condition.

2. Express the change as a rule

Typing values is what makes bulk editing slow. Everything worth doing at scale can be stated as a rule instead: decrease by 20%, increase by 1.50, set from cost plus 120%, round to .99.

If the storefront should show that the product is discounted, remember it takes two fields: copy the current price into compare-at price first, then reduce the price.

3. Decide when — including when it ends

A promotion with no end time is a promotion someone has to end manually, usually on a Monday morning while traffic is still arriving. Set the revert time when you create the task and the problem disappears.

4. Check the result, not the intention

1. Read the task log: it lists old and new values per variant, and anything skipped.
2. Open two product pages on the storefront, not just in the admin.
3. Check that the sale badge renders — that is compare-at price doing its job.
4. Spot-check one product at the edge of the filter, where mistakes hide.

Rounding is not cosmetic

A percentage change produces prices like 41.4917. Left alone they make a catalog look unfinished and they undermine whatever price psychology your endings were meant to carry. Apply the rounding rule inside the same task rather than fixing it afterwards.

When to split a task in two

One task per discount tier is easier to reason about and easier to revert selectively than a single task carrying three rules. The same goes for price bands: a 20% cut can be sensible on a 200 item and absurd on a 4 one.

Keep reading