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#

  1. 1
    Open the import results and read the row and column error.
  2. 2
    Download the current template and compare its column headings with the file that failed. Keep the template headings unchanged when editing your data.
  3. 3
    Check the affected row's required values, referenced products, warehouses, and categories. If you chose Create only, check whether a matching record already exists.
  4. 4
    Correct a small sample of rows in the source file. Select Validate again and confirm that the same error no longer appears.
  5. 5
    Review the remaining errors and repeat the correction by cause, such as a missing category or duplicate stock keeping code.
  6. 6
    Select 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.

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