Common repricing mistakes
Bulk repricing often goes wrong in three ways:
Common Scenarios:
- Naive percentage math leaves random decimals (e.g. 24.31) that kill the charm-pricing effect.
- Compare-at prices are set below or equal to the sale price, so Shopify never renders the strikethrough badge.
- Rounding up after a discount - a 10% sale on 9.90 becomes 9.99, which is an increase, not a discount.
Bulk repricing that keeps the psychology
ShopTools' bulk price editor applies your percentage or fixed adjustment, then rounds to a configurable .99 ending - down, never up - and lets you audit compare-at prices so sale badges render correctly.
Features:
- Percent & fixed adjustments: Apply a uniform rule across every variant in the file.
- Downward .99 rounding: Charm endings without accidentally raising prices.
- Compare-at awareness: Flags rows where compare-at is not above the sale price.
Correct repricing workflow
- Decide the rule: percentage shift, fixed amount, or a target .99/.95 ending.
- Apply the arithmetic, then round the result DOWN to the nearest .99 (never up).
- Keep Variant Compare At Price strictly higher than the new Variant Price.
- Preview a sample of the output before exporting the full file.
Before and after
- Before: Old price 24.31 after a 15% increase After: 24.99 - rounded to a clean charm ending
- Before: Compare At 29.99 with sale 29.99 After: Compare At 39.99 with sale 29.99 (badge shows)
Where this matters most
- BFCM & flash sales: Roll out site-wide discounts in minutes, not weekends.
- Supplier price changes: Pass through cost increases cleanly with a fixed margin.
- Premium positioning: Use .00 endings deliberately when the brand is about luxury.
Frequently Asked Questions (FAQ)
- Does .99 work for every store?
- Charm pricing suits value-oriented catalogs. Luxury or B2B stores sometimes intentionally use round .00 endings - pick one and be consistent.
- Should I round up or down?
- Down. Rounding 19.90 to 19.99 after a discount is still a discount; rounding to 20.00 or 21.99 silently raises the price.
- Why is my strikethrough compare-at price not showing?
- Shopify only renders the sale badge when Variant Compare At Price is strictly greater than Variant Price.
- Is there a shortcut for thousands of variants?
- Yes - apply the formula to the whole file at once with a bulk editor, then spot-check the preview.