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
- 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.
- Click Download Failed Rows. You get an Excel file with only the rejected rows, in your original column layout, with an
_ImportErrorcolumn explaining each one. - Fix the rows in that file.
- Upload it as a new import using Add or update. Rows already imported are updated in place, not duplicated, and the
_ImportErrorcolumn 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. :::
Learn more about Biznsbook Data Import on biznsbook.com.