What you see
After Bulk upload on Data Import, Items or Suppliers, or Bulk Upload on Users, Clients or Invoices, a box opens:
- On Data Import: "Bulk upload failed", with a table of Row, Field and Message, and Download Error Report.
- On Users: "Bulk Upload Failed:" with the number of errors found, "Fix the issues listed below in your Excel file and re-upload.", Close and Download Error Report.
- On CRM › Clients: "Bulk Upload Failed: [number] Error(s) Found", with Download Error Report (a text file) and Close.
- On Catalog & Inventory › Items: "Bulk Upload Failed: [number] Error(s) Found", with the rows and Download Error Report.
- On Catalog & Inventory › Suppliers: "Bulk Upload Failed: [number] Error(s) Found", with each row's messages, Close and Download Error Report (a text file).
- On Financial › Invoices: "Bulk Upload Failed: [number] Error(s) Found", with Download Error Report and Close. See Import invoices from Excel.
Why it happens
One or more rows break a rule, for example a missing required value, an email that is not valid, or a role or unit that does not exist. For the Suppliers, Clients, Item catalog and Open enquiries imports, one bad row stops the whole file and nothing is imported.
Messages you may see on a users file: "Name is required", "Invalid email address", "Password must be at least 8 characters", "Password must include uppercase, lowercase, number, and special character", "Role is required", or "Invalid role" with the role you typed.
What to do
- Select Download Error Report.
- For each row in the report, open that row in your Excel file and fix the field named. Row numbers count from the top of the sheet, with your data starting on row 3.
- Keep row 1 (headers) and row 2 (hints) as they are.
- Save the file and upload the whole file again.
Import templates: the columns in each file lists every column and hint.
If it still happens
If a row still fails and the message does not make sense, submit a request with the error report attached.
