Support & Troubleshooting
Troubleshooting CSV Import & Data Formatting Errors
Fix CSV import rejections: format spreadsheet headers properly, resolve duplicate SKU conflicts, and ensure clean UTF-8 encoding.
Common CSV Import Failure Causes
Bulk product import rejections are almost always caused by spreadsheet header mismatches, invalid currency formatting, or duplicate SKU identifiers.
Formatting Rules & Fixes
Verify your CSV against these requirements:
- 1. Required Header Columns: Your spreadsheet must include at least: `Title` (or `Name`), `Price`, `Quantity` (or `Stock`), and `Category`.
- 2. Clean Numeric Values: Ensure prices and stock counts contain numbers only (e.g. `2500`, not `KSh 2,500` or `$25.00`).
- 3. Unique SKU Codes: If your file includes SKUs, ensure each code is unique within your site catalog.
- 4. Save as UTF-8 CSV: In Excel or Google Sheets, export the file specifically as "CSV UTF-8 (Comma delimited) (*.csv)" to prevent special character corruption.