Prepare a Product CSV for Feed Validation
Prepare a UTF-8 product CSV, keep SKU values as text and use a small control export to diagnose row and column problems.
Export a small control file
Export five representative products before exporting the whole catalog. Include a variant, a title with a comma and an identifier with a leading zero. Open the CSV in a text editor and check that descriptions containing separators are quoted.
Check the header and value types
Use one header row with unique field names. Save the file as UTF-8. Treat SKU and GTIN values as text in the source application, since changing a spreadsheet cell format cannot restore digits already lost.
Read the first report before increasing volume
A duplicate header can make the whole file ambiguous. A missing title usually affects an individual row. Fix repeated export mapping problems in the source. For public analyses, split batches above 5,000 products or 10 MiB and keep product IDs stable across files.
Analyze your product feed for free
Check CSV, XLSX and supported XML/RSS files or a public feed URL. Up to 5000 products and 10 MiB per free analysis. See all findings and manual advice, and apply up to 10 distinct safe corrections.
Analyze your product feed for freeSee the sample report