Skip to main content

Fix failed rows and re-import

When some rows are rejected, you do not need to start again. Fix just those rows and load them.

Fix and re-import​

  1. On Status (or on the review page), read the problem summary. It lists each distinct reason with how many rows it hit. Most bad files are one mistake repeated.
  2. Click Download Failed Rows. You get an Excel file with only the rejected rows, in your original column layout, with an _ImportError column explaining each one.
  3. Fix the rows in that file.
  4. Upload it as a new import using Add or update. Rows already imported are updated in place, not duplicated, and the _ImportError column is ignored.

If the download is not offered​

The stored copy of your file has aged out. Click Export Error List instead for a CSV of row, field and message, and correct your original file.

Common messages​

  • Product Group 'X' was not found: create it, or re-upload choosing Create it automatically.
  • Warehouse, Supplier or Tax Group was not found: these are never created automatically. Create them first.
  • Quantity cannot be changed by an import: skip the Quantity column on update rows and use a goods receipt or stock adjustment.

:::tip A clean file with a few bad rows Import the valid rows now with Partial success, then load the corrected rows later with Add or update. :::