Where clearance repricing goes wrong
Clearance repricing fails in the same places every season:
Common Scenarios:
- Manual edits: touching 300 rows one by one guarantees typos and missed products.
- Naive rounding: a .99 rule that turns 36.00 into 36.99 after a discount, silently raising prices.
- Compare-at mistakes: forgetting to set Compare At Price removes the strikethrough that makes a sale look like a sale.
Run the rule in the browser
ShopTools' bulk price editor applies your discount, sets Compare At Price and rounds safely - margin-aware and formula-free - then exports a clean CSV ready for import.
Features:
- Discount rule: Percentage off applied to every Variant Price
- Compare-at sync: Old price becomes Compare At automatically
- Safe rounding: .99 rounding never raises a discounted price
The clearance workflow
- Export products as CSV from Shopify admin.
- Choose a discount depth - e.g. 30% - and apply it to Variant Price.
- Move the current price into Compare At Price.
- Round to .99 without ever raising a discounted price, then import.
Before and after
- Before: Variant Price: 50.00, Compare At: (empty) After: Variant Price: 35.00, Compare At Price: 50.00 (30% off, strikethrough visible)
- Before: 50.00 - 30% = 35.00 -> naive round to 35.99 After: 35.00 stays 35.00 - rounding never raises a discounted price
Who runs clearance sales
- Seasonal and end-of-line sales: Clear stock before new seasons arrive
- Slow movers and overstock: Move inventory without spreadsheet risk
Frequently Asked Questions (FAQ)
- What discount depth should I use?
- There is no universal number. 20-30% reads as a genuine sale; deeper discounts for slow movers. The tool lets you preview margin at any depth.
- Why set Compare At Price?
- Without it there is no strikethrough, and shoppers see no discount anchor. The compare-at price is what makes a sale look like a sale.
- Can I apply different discounts to different products?
- Yes - filter the CSV into groups and run a different rule per group before importing.
- Does the import overwrite everything?
- Only the columns in your file. Keep SKU and Handle intact and only price columns change.