How to Clean Up Product Variants Before You Import

Every store with more than a couple hundred SKUs ends up with variant drift: "Red," "red" and "RED " all live in the same column because three different people (or three different supplier feeds) entered products over two years. It looks harmless until a customer filters by color and half your red products don't show up, because the storefront's filter logic treats "Red" and "red" as different values.

The Variant Value Cleaner finds these groups automatically and lets you standardize them in one pass, before you re-import.

Why this actually matters for sales, not just tidiness

Inconsistent variant values break three things at once: storefront filters (a size or color filter that silently excludes matching products), search facets in apps like Shopify's own filtering or third-party search apps, and inventory reporting (your "Black" and "black" stock counts are tracked as two separate variant groups instead of one). None of these show up as an error anywhere — they just quietly cost you sales and make your inventory numbers wrong. We go deeper on the mechanics of this in why your product filters are broken.

Step 1 — Export your product catalog

Export your full product CSV from Shopify (Products → Export) or WooCommerce (Products → Export). You want the export that includes variant option columns, not a summary report.

Step 2 — Upload and pick the columns to check

Open the Variant Value Cleaner and upload your export. Tick the columns you want checked — typically Color, Size and Material, or whatever your store's variant options are called. You don't need to check every column; skip anything that's genuinely meant to hold long free-text values.

Step 3 — Review the grouped spellings

The tool groups values that are likely the same thing — differing by case, accents, extra whitespace, or common near-duplicates like "Sm" vs "Small" — and shows you each group side by side. For every group you can:

• Accept the suggested standard value (usually the most common spelling in your data).
• Edit the standard value if none of the existing spellings is the one you actually want going forward.
• Split a group if the tool grouped two genuinely different values together (this happens occasionally with short values like "S" vs "Sm").

Nothing is changed in your file until you approve a group — you're reviewing suggestions, not applying an automatic find-and-replace blind.

Step 4 — Download the corrected CSV

The exported file is your original CSV with only the approved cells changed — same row order, same columns, same everything else. That matters because most CSV round-trip failures on import come from a tool that "cleans" your file by also silently reformatting dates, reordering columns, or stripping columns it didn't recognize.

A worked example

A supplier feed adds 200 new SKUs a month, and over a year your Color column has accumulated: Black, black, BLACK, Blk. A shopper who filters for "Black" on your storefront only sees whichever spelling your theme's filter logic happens to match exactly — usually just one of the four. Running the cleaner groups all four into one approved value, and the next import fixes every one of those SKUs' filterability in a single pass instead of hunting through the catalog by hand.

Try it now

Open the Variant Value Cleaner and upload your export, or load the sample file to see a grouped batch first. If you're mid-migration between Shopify and WooCommerce, running the cleaner before you convert formats (see our CSV converter guide) means you migrate clean data instead of carrying the same inconsistencies to the new platform.