Shopify CSV Troubleshooting Guides
Practical walkthroughs for the problems that most often stop a Shopify product import or leave products missing afterwards: header and handle errors, image rows, visibility settings, supplier feeds, unsafe updates, number formats, spreadsheet traps and file encoding. The newest guides cite Shopify’s documentation and say plainly what ShopiClean can and cannot fix.
How to Fix Illegal Quoting in Shopify CSVs
Resolve unescaped HTML quotes, misplaced double quotes, and line breaks that shift entire table columns into incorrect fields during import.
Split Multi-Variant Catalogs by Color
Learn how to partition massive variant matrices into standalone product listings for dedicated Google Shopping feeds and clean collection browsing.
Convert Faire & Square Sheets to Shopify
Map supplier CSV headers into valid Shopify column syntax, calculate gross retail margins, and auto-generate clean handle slugs.
Fix Broken Image Links & Media URL Fails
Detect local workstation file paths (such as C:\), URL-encode spaces, and strip invalid parameters causing Shopify image fetch timeouts.
Update Products by CSV Without Deleting Variants
How the overwrite option treats blank cells, missing Option columns and changed option values, and a safer export-edit-test workflow.
Price, Weight & Inventory Formats Shopify Expects
Plain-number prices, whole-gram weights, inventory rules and what Shopify does with blank prices and quantities.
Fix Excel Scientific Notation in SKUs and Barcodes
Why long identifiers become 1.23E+12 or lose leading zeros, how to prevent it, and what to do when digits are already lost.
Strange Characters or One Column? Fix Encoding & Separators
Save as UTF-8 with comma separators, avoid Excel regional-settings traps, and repair a catalog imported with bad characters.
Fix “Invalid CSV Header” and “Unexpected token” Errors
What the header errors mean, why capitalization and stray spaces matter, and how to match Shopify’s template exactly.
Fix “Options Are Not Unique” and “Handle Already Exists”
Four handle and variant errors explained: duplicate options, reused handles, rows without a title and “Line is invalid”.
Products Not Showing After a CSV Import?
How Status, Published on online store and the sales-channel option decide whether imported products are visible.
Add Multiple Images and Variant Images in a CSV
One row per image, image position, alt text, variant images, the 250-image limit and what makes images disappear.
Guías en español y guias em português
Guides written in Spanish and Brazilian Portuguese for merchants in Latin America: Excel regional settings, number formats such as R$ 1.299,90, accents and Spanish or Portuguese column names. The ShopiClean tools themselves are in English.
Error “Encabezado de CSV no válido: faltan encabezados”
Qué significa, cómo corregirlo y una tabla de equivalencias para pasar las columnas de tu hoja en español a las de Shopify.
CSV de Excel para Shopify: UTF-8, punto y coma y comillas
Tildes y ñ rotas, columnas pegadas y “Comillas no válidas en la línea”: cómo guardar bien el archivo.
Precios con coma decimal y punto de miles (1.299,90)
Cómo convertir precios al formato de Shopify y por qué valores como 15.990 pueden quedar mal.
CSV da Shopify no Excel em português
Ponto e vírgula, preços com vírgula (R$ 1.299,90), acentos e cabeçalhos em português.