Troubleshooting • reference
Troubleshooting CSV Import Errors
Resolving CSV batch import failures across products, stock, and suppliers, including missing headers, duplicate SKUs, foreign key lookups, and format errors.
Reviewed on 2026-10-07
Locate the first failed row#
- 1Open the import results and read the row and column error.
- 2Download the current template and compare its column headings with the file that failed. Keep the template headings unchanged when editing your data.
- 3Check the affected row's required values, referenced products, warehouses, and categories. If you chose Create only, check whether a matching record already exists.
- 4Correct a small sample of rows in the source file. Select Validate again and confirm that the same error no longer appears.
- 5Review the remaining errors and repeat the correction by cause, such as a missing category or duplicate stock keeping code.
- 6Select Import only after the rows you intend to load pass validation; open sample created or updated records afterward.
If the same field fails across many rows, check the column mapping before editing each row.
Correct and validate the file#
Import only rows that passed. If some rows were already imported, retry the failed ones rather than uploading the same batch again.
WARNING: Some rows may import while others fail. Correct and retry only the failed rows so you do not duplicate accepted records.
Previous
Troubleshooting Currency & Exchange Rate Errors
NextTroubleshooting Insufficient Stock & Reservation Failures
Have a question about this workflow?
Subscribed customers can ask questions about this guide inside the authenticated dashboard.
Ask about Troubleshooting CSV Import Errors in Dashboard