Sale price update audit
Shopify CSV Bulk Price Update Audit
Check a bulk Shopify price update before a sale import changes the wrong variants, clears values, or makes compare-at prices unusable.
Browser-side scan
Drop a Shopify price update CSV
No CSV selected
This page is for merchants editing hundreds of prices for a sale. It checks whether the CSV has stable Shopify identifiers, reviews price and compare-at relationships, warns about risky blank price cells, and exports a smaller price-only update CSV for one-product testing before a catalog-wide import.
Import blockers
Common causes this scan checks
- Sale prices were edited in a full product export with too many unrelated columns.
- Compare-at price is blank, equal to, or lower than the sale price.
- Rows do not include enough Handle, SKU, or option data for Shopify to match variants safely.
- Blank cells in included price columns may clear values during overwrite imports.
Workflow
How to use the cleaned CSV
- Upload the edited price CSV and review identifier warnings first.
- Check every compare-at warning before importing sale prices.
- Export the reduced price update CSV and import one product or variant as a controlled test.
- Keep the original export unchanged so the sale update can be audited or rolled back.
Auto-fix policy
What the export can safely change
- Keeps only stable identifier columns and non-empty Shopify price columns in the export.
- Normalizes unambiguous price formatting in the generated update CSV.
- Flags compare-at values that will not display as a sale price.
- Leaves blank-cell overwrite risks visible for manual review.
CSV example
CSV example: price update audit
The price audit exports only identifiers and price columns so sale updates can be tested without carrying unrelated product fields.
Handle,Variant SKU,Variant Price,Variant Compare At Price,Body (HTML) mug,MUG-1,14.99,19.99,Old copy
Handle,Variant SKU,Variant Price,Variant Compare At Price mug,MUG-1,14.99,19.99
FAQ
Shopify CSV questions
Can this create a complete sale campaign?
No. It prepares a safer CSV update file for Shopify import. Merchants still decide which products and prices belong in the sale.
Why export fewer columns?
A smaller update CSV reduces the chance of accidentally overwriting titles, descriptions, images, categories, or other product data.
Does compare-at price need to be higher than price?
For a normal sale display, compare-at should be higher than the current variant price. Equal or lower values usually need review.