Run an import
Every import follows the same path: upload, match columns, review (with an optional trial run), run, then check the result.
Upload a file
- Choose Import → New Import.
- Under What are you importing? pick the import type. A panel shows its template downloads and column count.
- Under What if a record already exists? choose one:
- Add or update (default): new rows are added, matching rows are updated. Safe to repeat.
- Add new only: rows that already exist are skipped. Best for a first load.
- Update existing only: rows with no match are skipped. For corrections.
- Optional, under Advanced options:
- If a row fails: Partial success imports every valid row and lists the rest; All or nothing imports nothing if any row has an error.
- Unknown product groups / units of measure: Fail the row, or Create it automatically.
- Drag the file onto the drop zone or click to browse. The page checks the type, size and that the file is not empty.
- Click Upload. The file is read in the background and you move to column matching.
Extra columns are harmless and column order does not matter. In Add new only mode, uploading a file identical to one you already imported (and have not reversed) is refused; use Add or update if you changed the data.
CSV files may use comma, semicolon, tab or pipe separators and may contain quoted cells with line breaks. In Excel files the first sheet is read. Column headings must be unique.
Match, review and run
- Match columns on the page you land on after upload.
- Review and run a trial, then click Import N rows and confirm.
- On the Status page follow the phase, the batch (for example "batch 4 of 12") and the time left. You can close the page and come back. If another company's import is ahead of yours, the page says it is waiting.
- When finished you see a banner (green for clean, amber if some rows failed) and counts for total, inserted, updated and failed rows.
Large files are written in batches of 750 rows. With All or nothing, a file that fits one batch is truly all-or-nothing. Above that, a problem found part-way stops at that batch, and the summary says how many earlier rows were saved and need reversing.
Resume an import that stopped
- Open the import's Status page.
- If it shows a failure after some batches were saved, click Resume import.
Biznsbook continues after the last completed batch and keeps the earlier counts and errors. No rows are duplicated. If the page says server memory was too high, split the file and import the parts.
Discard an import and start over
- Click Discard & Start Over on the review page, on the Status page of an import that stalled before running, or on the Upload page when it says another import is in progress (Discard it and continue here).
- You return to the upload page with the same type selected.
Nothing has been imported at this stage, so there is nothing to undo. Your column matching is kept.
Learn more about Biznsbook Data Import on biznsbook.com.