Drag your CSV here or click to select
Formats: .csv · .txt · Max. 20 MB · PrestaShop Products
UTF-8
ISO-8859-1
Auto delimiter
BOM strip
Reading file...
0 rows processed
Automatic Detection
—
Calculating...
Preview (first rows)
Errors & Warnings
| Type | Row | Column | Found Value | Issue | Recommended Solution |
|---|
Downloads
Automatic fixes only include: UTF-8 BOM removal, whitespace trimming, and price decimal separator normalization. Data errors (EAN, duplicates, invalid prices) are listed for manual review.
What is the PrestaShop CSV Validator?
The PrestaShop CSV Validator is a free tool that analyzes your product import files before uploading them to your store. It detects the most common errors that cause import failures, including duplicate references, invalid EAN-13 codes, malformed price fields, and invalid image URLs.
Unlike importing directly into PrestaShop and troubleshooting errors after the fact, this tool allows you to review and fix issues before importing, saving time and preventing catalog corruption.
How to use the validator
1. Upload your CSV
Drag your product import file or click to select it. Delimiter and encoding are detected automatically.
2. Review results
View your quality score, error breakdown, warnings, and a preview of the first rows.
3. Fix errors
Follow the recommendations for each issue. Critical errors block import; warnings should be reviewed.
4. Download fixed CSV
Download your file with safe automated fixes applied (BOM removal, whitespace, price decimals).
Most common PrestaShop CSV import errors
Invalid EAN-13
The checksum digit of the EAN-13 code is invalid or the field does not contain exactly 13 digits. PrestaShop rejects these values.
Verify the checksum digit or generate valid EAN-13 codes.
Duplicate Reference
Two or more products share the same reference (#). PrestaShop may overwrite existing items or duplicate records.
Assign a unique reference to each product using category prefixes.
Price with comma decimal
PrestaShop requires a period as the price decimal separator. Values like "9,99" fail in many versions.
The validator automatically converts commas to periods in price fields.
UTF-8 BOM
Files with a Byte Order Mark (BOM) produce an invisible character that breaks header parsing.
The validator strips the BOM automatically when downloading the fixed CSV.
Missing required columns
The CSV lacks required columns such as Name, Reference, or Price. PrestaShop cannot import incomplete rows.
Ensure your file contains all mandatory PrestaShop columns.
Frequently Asked Questions
Is my CSV uploaded to any server?
No. All analysis is performed entirely inside your browser via JavaScript. Your file is never transmitted to any external server.
Which PrestaShop versions are supported?
Compatible with PrestaShop 1.6, 1.7, 8.x, and 9.x. Product CSV import structures remain identical across versions.
What is the maximum file size?
Up to 20 MB. Large files are processed in non-blocking chunks.
Which fixes are applied automatically?
Only safe fixes: UTF-8 BOM removal, whitespace trimming, and price decimal normalization.
Related iDiUtils Tools
JSON / CSV Converter
Convert JSON structures to CSV compatible with Excel and PrestaShop.
EAN Barcode Generator
Generate valid EAN-13 barcodes with correct checksums.
Margin Calculator
Calculate optimal selling price from product cost.
Volumetric Weight
Calculate billable shipping weight for e-commerce.