Stock like 10+ or "in stock" in a CSV: find and fix
Stock cells like 10+, 5-10 or in stock give no exact count, so an import may reject or misread them. Find them, enter real counts, then recheck.
Ler o postPosts
Guias curtos para encontrar e corrigir erros em um CSV de produtos, e novidades do projeto. Os posts são publicados em inglês.
Uma ferramenta para usar agora
Encontre erros no CSV dos seus produtos
Verifique 20 linhas e baixe um relatório com os passos para corrigir erros de importação. Grátis, sem cadastro. O arquivo fica no seu navegador.
Preços e números
Weight and size units in a product CSV: find and fix
A 250 g item shows as 250 kg? Pick one unit per measurement, split units from numbers, convert the rest, spot outliers, then recheck.
Ler o postFractional stock quantities in a CSV: find and fix
A stock of 2.5 or 0,5 can be rejected, rounded or split into an extra column. Find fractions with a helper column, fix them to whole units, recheck.
Ler o postDate columns in a CSV: serials, swaps, formats
Dates shown as 45992, day and month swapped, or three formats in one column. Find each problem, rebuild the column as yyyy-mm-dd text, then recheck.
Ler o postThousands separators in CSV prices: find and fix
Is 12,500 twelve thousand five hundred or twelve and a half? Find thousands separators in a CSV price column and rewrite them in one style.
Ler o postText in a CSV price or stock column: find and fix
Words like N/A, free or call us in a price or stock column can make an import skip or misread rows. Find them, write real numbers, then recheck.
Ler o postZero or negative CSV price and stock: find and fix
A price or stock of 0 or below can make a product look free or show wrong availability. Find the rows on a copy, fix them from your records, recheck.
Ler o postCurrency symbols in a CSV price column: find and fix
Prices like "$12.50" or "45 TL" can make an import reject or misread rows. Find the symbols on a copy, keep prices as plain numbers, then recheck.
Ler o postDecimal comma or column separator in CSV prices?
A comma in a price can be a decimal mark or a column separator. Learn how to tell them apart, fix a copy of your CSV, and recheck before you import.
Ler o postSKUs e códigos de barras
Size and colour variant rows in a CSV: find and fix
Variants on separate rows need their own SKUs and titles that fit their options. Sort by product, check each group, fix, then recheck.
Ler o postBarcode check digit errors in a CSV: find and fix
A barcode can have the right length and still fail because its last digit does not match. Check it by hand, copy the code again from the source, recheck.
Ler o postBarcodes shown as 1.23E+12 in a CSV: find and fix
A barcode column showing 1.23E+12 has been read as a number. Rebuild it as text from the source, then check the saved CSV in a text editor.
Ler o postDuplicate SKUs in a product CSV: find and fix
Shared SKUs can make an import reject, merge or overwrite products. Clean spaces and case, sort the whole table, then decide which row stays.
Ler o postWhy SKUs lose leading zeros in CSV files
Spreadsheet apps can read a digits-only SKU as a number and drop its leading zeros. Import the column as text and compare the export with your original.
Ler o postDuplicate SKU: what should I change?
Two different products share one SKU. A synthetic before-and-after example of fixing it without deleting a valid product.
Ler o postCabeçalhos, linhas e células vazias
Line endings (CR, LF, CRLF) in a product CSV
Your CSV looks fine, but the import fails at the end of a row? See what CR, LF and CRLF are, how to spot them in a text editor, and how to change them.
Ler o postVery long text in a CSV cell: find and fix
Rows rejected as too long, or one cell holding several rows? Count the characters, fix missing quotes, shorten or move the text, then recheck.
Ler o postCSV opens in a single column: check the separator
Every row stuck in one cell in column A? Find the character between your values, pick it when importing, then recheck the columns.
Ler o postQuotes and commas inside CSV cells: find and fix
A comma or a quote inside a cell can push values into the wrong column. Wrap those cells in double quotes, double the inner quotes, then recheck.
Ler o postBlank rows in a product CSV: find and remove
Rows with nothing in them raise the row count and may cause upload warnings. Find fully blank rows with a filter, delete them, then count again.
Ler o postCSV column headers that don't match the template
An import can reject a product CSV over one header that differs from the template. Compare headers character by character, fix the header row, recheck.
Ler o postLine breaks inside a CSV cell: fix split rows
A line break or a stray quote inside a cell can split one product into two rows. Put the text back on one line, close every quote, then recheck.
Ler o postEmpty cells in your product CSV: why and how to fix
Empty cells in a product CSV usually come from four causes. Find them on a copy, fix each one, then check the file again before you import it.
Ler o postTexto, links e codificação
Duplicate product titles in a CSV: find and fix
Different products with the same title confuse shoppers. Compare titles ignoring case and spaces, tell variants from real duplicates, fix, recheck.
Ler o postImage links in a CSV: capitals, spaces and %20
Blue-Mug.JPG and blue-mug.jpg may be two different files. Check capital letters, edge spaces and %20 in your image links by hand, on a copy.
Ler o postHTML tags in CSV product descriptions: find and fix
Pasted HTML tags and codes like & can show up as raw text in product descriptions. Find them on a copy, clean them to plain text, then recheck.
Ler o postEmoji and invisible characters in a product CSV
Emoji, symbols like ™ and invisible zero-width characters can break a product import. Find them on a copy, swap in plain text, then recheck.
Ler o postCategory or brand names in a CSV: find and fix
"Shoes" and "shoes" can import as two categories. List the unique values, pick one spelling for each, replace the variants, then recheck.
Ler o postMissing column in a CSV import: check for a BOM
If an import says a column is missing although the name looks right, this post shows how to check a copy of the file.
Ler o postBroken image links in a product CSV: find and fix
A space, a doubled dot or a missing ending in an image link can hide a product picture. Check the column by hand and match each link to the real file.
Ler o postHidden spaces in a product CSV: find and fix them
A space at the start or end of a cell makes SKUs and prices stop matching. Find edge spaces by comparing lengths, trim them on a copy, then recheck.
Ler o postWhy accented letters look broken in your CSV
Turkish or accented letters look garbled in a CSV? Find the file's encoding, save a copy as UTF-8 and check it again without touching the original.
Ler o postComo revisar um arquivo passo a passo
CSV correction worksheet: log each fix, recheck
A copyable template for recording each flagged row, the value you verified, the fix you made and the result of the recheck.
Ler o postCheck, fix, recheck: a product CSV before you use it
A use case, not proof of demand: how a solo founder can check a product CSV in the browser, fix it and check it again.
Ler o postOutras publicações
The starting point, in numbers
Revenue $0, no verified paying customers, and a catalog of 196 business ideas you can rate. Here is the honest picture on day one.
Ler o post