Bulk Product Data Cleaner
Open a product CSV from Shopify, WooCommerce or a spreadsheet. The cleaner fixes spacing and formatting, flags what needs your attention, and lists every change before you download.
Your product file
How it works
The cleaner reads your CSV, recognizes Shopify and WooCommerce columns by their header names, and applies only the clean-ups you choose. It records every cell it changes, with the value before and after.
- Missing values: rows with an empty value in the columns you tick are flagged. In Shopify files, extra rows for variants and images leave Title blank by design, so Title is checked only on each product's first row and image-only rows are skipped, following the Shopify product CSV guide.
- Duplicates: a Shopify file repeats the handle on every variant row, so duplicates are found by SKU and by handle plus option values, not by handle alone. Rows that are exact copies of an earlier row are listed and removed only if you tick that option.
- Other checks: handles with characters Shopify doesn't use, image addresses that don't start with http:// or https://, prices that aren't plain numbers, and text starting with = + - or @ that a spreadsheet could treat as a formula.
Assumptions, limits and privacy
- Files up to 15 MB and 100,000 rows, saved as CSV or TSV. Excel files (.xlsx) aren't opened.
- The cleaned file keeps your header row and column order and is written as comma-separated UTF-8. Import a few products first to check the result.
- It can't tell whether a price, SKU or description is correct, only whether it's formatted consistently.
- Your file is processed in this browser tab and isn't saved; close or reload the page and it's gone.
Files you open and text you paste are processed in your browser and aren't uploaded to Ecom Outpost. This tool doesn't save anything: when you close or reload the page, your data is gone.
Next steps
- Improve the product descriptions you've cleaned with the Product Description SEO Helper.
- Need the data as JSON for another system? Use the File Converter.
Related free tools
Supplier Quote & Landed Cost Calculator
Compare up to three supplier quotes on the true cost per unit once freight, duty, fees and samples are added.
Inventory Reorder Calculator
Find a product's reorder point and safety stock, whether to reorder now, and how many units to order.
Measurement & Unit Converter
Convert product weights, dimensions, volumes and temperatures between metric and US units for listings and shipping.
Product Research Scorecard
Compare up to four product ideas on margin, demand, competition, shipping and risk with weights you choose.
