EARTHLOOMGuides   Apps

How to plan a Shopify bulk price change safely

Changing hundreds of Shopify prices in one go is quick and unforgiving. A wrong percentage, a missing cost or a compare-at price below the new price goes live immediately. A safer routine is to compute everything in a spreadsheet first, review it row by row, and apply only after checks pass.

Why this is harder than it looks

Bulk editors tend to apply first and explain later. If a rule is wrong, the only repair is another bulk edit while customers see wrong prices. Margins vanish silently when cost is missing, rounding produces odd endings, and compare-at prices end up lower than the selling price, which looks broken on the storefront.

Step by step

  1. Export a backup first. In the Shopify admin go to Products > Export, choose All products and the CSV for Excel or Numbers. Save this file untouched as your rollback. It contains Variant Price, Compare At Price and, if filled, Cost per item, which you need for margin checks.
  2. Set up the sheet. Open a copy of the CSV in a spreadsheet. Keep Handle, Variant SKU, Variant Price, Variant Compare At Price and Cost per item. Add columns for New price, New compare-at, Margin before and Margin after. Filter out rows with an empty Variant Price, such as the extra image rows.
  3. Calculate the new price. Percent change: =ROUND(price*(1+pct),2), where pct of -0.15 is 15 percent off. Cost-plus: =cost*(1+markup). Target margin: =cost/(1-margin), so a 40 percent margin on a cost of 12 gives 20. Margin is (price - cost) / price, and markup is not margin.
  4. Apply the rounding rule. For .99 endings use =ROUNDUP(newprice,0)-0.01 to round up, or =ROUNDDOWN(newprice,0)-0.01 to round down. For steps of 0.50 use =MROUND(newprice,0.5). Round after calculating margin, then recompute margin from the rounded price, because rounding can move margin by a point or more.
  5. Protect compare-at and floors. Compare-at must stay above the price, or the sale badge breaks. Add a check such as =IF(compare<=newprice,"CHECK",""). Also flag rows where new price is below cost, where margin falls under your minimum, or where the change exceeds a limit such as 30 percent.
  6. Test on a few products. Filter to a small set, such as one vendor or tag, and import only those rows. In Products > Import, tick Overwrite existing products with the same handle. Check the storefront, a cart and the margin on two or three items before running the full file.
  7. Run the full change and verify. Import the full file during a quiet period, then export again and compare to the plan. Check that nothing outside the intended filter changed. Keep the backup CSV for 30 days or more, because re-importing it is your undo for rows nobody edited meanwhile.

Common mistakes

Where PriceDryRun fits in

PriceDryRun is a bulk price planner for Shopify built around a dry run: every row is shown before and after, with margin and warnings, and nothing is written until you apply. It supports percent, amount, fixed, target margin and cost-plus rules, price endings and steps, compare-at options, minimum margin guards and filters. It is built but not yet in any store.

PriceDryRun support and FAQ

FAQ

What is the difference between margin and markup?

Margin is profit divided by price, and markup is profit divided by cost. A product costing 10 and selling for 15 has a 33 percent margin and a 50 percent markup.

How do I round prices to end in .99?

In a spreadsheet use =ROUNDUP(price,0)-0.01 to round up to the next .99, or ROUNDDOWN to go down. Always recompute margin after rounding, since the price changes slightly.

Why should compare-at stay above the price?

Shopify shows compare-at as the original price with a strike-through. If it is equal to or below the selling price, the sale display looks wrong or misleading, so check every row.