Toggling fixes per category
Every auto-fix in CSVwise can be turned on or off independently. This article covers when you'd turn a fix off and how to do it.
Why all fixes default to ON
Every one of CSVwise's 13 auto-fixes prevents a specific failure in Shopify's CSV importer. That's why they're all on by default. The standard expectation is "the tool produces a file Shopify will accept."
You'd turn a fix off only when your data is intentionally formatted in a way that fix would change.
When to turn each fix off
| Toggle (as labeled in the app) | Turn off when… |
|---|---|
| Auto-generate missing Handles from Title | You're only updating existing Shopify products, and a missing Handle should be flagged per row rather than filled in automatically. |
| Normalize Handle format (lowercase, hyphens) | Rare. Your handles are already exactly correct and you want CSVwise to flag any drift as a problem instead of silently fixing it. |
| Truncate Handles longer than 255 characters | Rare. You want truncation to be an explicit decision you make per row. |
| Strip non-numeric characters from prices (currency symbols, quote characters, thousands separators, letters) | You have a custom price column that already stores bare decimal numbers AND you want CSVwise to flag stray currency symbols instead. |
| Convert EU decimal format (1.234,56) to Shopify format (1234.56) | Your prices are in USD-style notation, and you want commas treated as thousands separators rather than decimal points. |
| Normalize prices to exactly 2 decimal places (49 → 49.00, 49.995 → 50.00) | You're deliberately tracking sub-cent prices (e.g., precious-metal pricing) and want the precision flagged for your review. |
| Convert weights with units to whole grams (e.g. '1.5 kg' → 1500 + kg) | Your weights are already in pure grams as a bare number, with no unit suffix anywhere. |
| Normalize yes/no values (yes/Y/1 → TRUE) | You're using a non-standard yes/no vocabulary that CSVwise might map incorrectly. (Uncommon. Most variations are covered.) |
| Normalize tag separators (semicolons, pipes → commas) | Your tag strings are already comma-separated, and you want any stray separators flagged. |
| Truncate tag lists exceeding 250 tags per product | You want "too many tags" to surface as a row-level problem instead of being silently trimmed. |
| Trim whitespace from Handle, SKU, and Option values | Almost never. Trimming whitespace is essentially always desirable. |
| Normalize Shopify-specific values (Inventory Tracker, Policy, Fulfillment Service, Weight Unit, Status) | You're using Shopify's exact expected values and don't want CSVwise rewriting anything in those columns. |
| Round non-integer inventory quantities and image positions | You want fractional inventory or image positions to surface as a row-level problem rather than be silently rounded. |
How to toggle
On the Fix issues stage, the Auto-fix options panel groups the 13 switches under five headings: Handles, Prices, Tags, Weight & inventory, and Formatting. It lays out in two columns, or one on a narrow screen.
Each switch is a label and an on/off state, nothing more. To see what a fix is actually doing to your data, watch the live preview: flip a switch and the tinted cells for that fix appear or disappear immediately. The panel notes that each toggle applies to every row in the downloaded file, not just the AI-analyzed sample.
To undo experimenting, open Advanced… next to Generate and choose Reset auto-fix options to defaults.
What a toggle changes, and what it doesn't
Detection runs independently of the toggles. CSVwise reports an issue whether the matching fix is on or off. What the toggle controls is whether the fix is applied to the file you download. For example:
- With Strip non-numeric characters from prices ON: the problem list reports a warning for the affected rows, and
$24.99is written to the cleaned file as24.99. - With Strip non-numeric characters from prices OFF: the problem list reports the same warning, and
$24.99stays as-is in the cleaned file.
Turning a fix off doesn't quietly break your Shopify import. You see the problem before you generate. Most of these surface as warnings, which never block the download, so you can leave them, fix them manually, or remove the rows from the cleaned CSV.
Toggle state is per cleanup
Toggles are per cleanup. Every cleanup starts with all 13 fixes on, and a change you make on one file is not carried over to the next. If your data routinely needs a fix turned off (say, European decimal conversion when your commas are really thousands separators), turn it off after uploading each time.