Feature
Bulk Import
Creating many catalogue records at once from a CSV, XLSX or JSON file.
Bulk import brings the records of an old catalogue into the catalogue at once from a CSV, XLSX or JSON file. The work is done on the Catalogue → Bulk import screen.
The uploaded file is checked first, and the result of each row is shown in a dry-run report. No record is created at this step. When you confirm the report, the valid rows are created as draft records and the rows with errors are skipped. Publishing is a separate step.
A row uploaded again with the same source ID does not create a second record. The existing record is skipped or updated, as you choose. Rows that could not be imported can be retried once the problem has been fixed.
Topics in this section
How-to guides
-
Importing Records in Bulk
Filling in the template, uploading the CSV, XLSX or JSON file, reviewing the dry-run report and importing the valid rows as draft records.
-
Retrying Failed Rows
Importing the invalid or failed rows of a completed bulk import again with a new dry-run report after the problem has been fixed.
Screens and settings
-
Import Columns
The columns of a bulk import file, which ones are required, how values are written and the rules that make a row invalid.
-
Bulk Import Screen
The upload area, the source system name, the template buttons and the list of earlier imports on the bulk import screen.
-
Dry-Run Report
The counts, notes, import and retry sections, row tabs and columns of the bulk import report.
Troubleshooting
-
An import file does not upload or cannot be read
Why a bulk import file does not upload, or an error appears instead of the dry-run report, and how to solve it.
-
An import created the same record twice
Why uploading a file again created new drafts instead of updating the existing records, and how to clean up the extra records.