Shopify
How to clean a Shopify product CSV
If you are preparing a Shopify product import, the main goal is not perfection. It is to get your product data into a consistent, Shopify-compatible shape so imports fail less often and downstream catalog maintenance is easier.
What to do first
Start by comparing your source file to the browser editor, then use the platform preset to map common fields. Once your sample looks right, process the full file locally.
Start with a small sample
Before cleaning a full catalog, test a representative sample. That lets you confirm header mapping, pricing normalization, and handle generation without risking a larger import failure.
- • Export a few products that cover your common edge cases.
- • Check whether variant rows, images, and tags are represented the way you expect.
- • Use the browser editor to normalize one or two rows before processing the full file.
Pay attention to handles, titles, and prices
For Shopify, handles, titles, and prices are the first places imports tend to break down. A consistent handle pattern reduces duplication. A clean title makes your catalog easier to review. A normalized decimal price avoids weird import behavior.
- • Generate handles from titles when they are missing.
- • Trim whitespace from titles and variant fields.
- • Normalize prices to plain decimals before download.
Use validation to catch the boring mistakes
The best CSV cleanup work is often about catching small issues early: missing SKU values, duplicate handles, blank rows, and unexpected option columns. These are exactly the problems that turn into failed imports or manual rework later.
- • Check for missing Title after mapping.
- • Resolve duplicate handles.
- • Review any warning about invalid prices or inventory quantities.
Keep the cleanup local
This guide and the companion tool are designed for browser-only processing. That means you can work on private catalogs, vendor feeds, or agency exports without uploading the raw data to a backend.
FAQ
What is the fastest way to clean a Shopify CSV?
Use the Shopify CSV Cleaner to map headers, let it auto-suggest common fields, then review validation issues before downloading the cleaned file.
Should I clean prices before import?
Yes. Normalizing prices to simple decimal strings helps avoid import errors and makes the file easier to review.
Can I fix my CSV without uploading it anywhere?
Yes. The browser-based cleaner is designed to keep your file local while you map and edit it.