How large a bulk change is safe to run at once?

There's no hard technical limit, but a good operational rule is: never run a change larger than you can manually inspect on a five-product sample afterwards. Split larger batches by collection or tag.

Can I round different products to different endings?

Yes — run one bulk edit per product group with its own rounding rule (e.g. accessories to .95, apparel to .99). Filter by tag or collection each time.

Will rounding trigger Shopify's 'sale' badge?

Only if it lowers the current price below the existing compare-at price. Rounding-up won't. Verify a few rows in a private window after applying.

How to round Shopify prices to .99 in bulk

Quick answer

To round Shopify prices to .99 in bulk, export the affected products as CSV, apply a formula like FLOOR(price)+0.99 to the Variant Price column and re-import. For live catalogs or when you need undo, use a dedicated bulk-edit app that applies rounding rules with a before/after preview.

Key takeaways

The admin bulk editor is fast but has no preview and no undo.
CSV scales but silently overwrites empty cells — always take a filtered export as a snapshot first.
A dedicated bulk-edit app is the safest option for recurring changes because it previews and undoes each field.
Verify a five-product sample after any bulk change before closing the ticket.

TL;DR

Three paths: the native admin bulk editor for small filtered lists, CSV for one-off bulk changes, and a dedicated app when you need preview, safety limits and undo. Pick by risk, not by habit.

The manual way — Shopify admin

Shopify's native bulk editor has no rounding rule — you can only type a new value into each cell. For anything above a handful of products, the manual method is only viable if you don't care about consistency across variants.

The CSV way — with pitfalls

Export the products, apply FLOOR(price)+0.99 (or 0.95, 0.90) to the Variant Price column in your spreadsheet, and re-import. Pitfalls: (1) FLOOR on values already at .99 produces .99 again — no harm but no change either, so filter first; (2) rounding down can drop the price below your target margin, so add a MAX(rounded, floor_price) guard formula; (3) don't forget Variant Compare At Price if you want the discount ratio to stay stable.

The app way — preview and undo

In ABAR Bulk Edit you pick 'change price by %' or 'set fixed price', choose the rounding rule (.99 / .95 / .90 / none), set a minimum-price safety limit, preview every affected row, and undo if the rounding drops rows through the floor.

The safe workflow

Filter → export CSV snapshot → preview → apply → verify on five products → keep an undo path open. Every safe bulk change on Shopify looks like this, whichever tool you use.

Try the app

ABAR Bulk Edit

Bulk edit products, prices, inventory and metadata — with previews, scheduling and reliable undo.

Learn more