Prepare before import
Here are the key things to get right. None of them are complicated on their own, but skipping one tends to undermine the rest.
- Match column names to the collection fields.
- Normalise dates, URLs and references.
- Keep slugs unique and preserve existing stable values.
- Check required fields and image URLs.
- Export or duplicate the current data before updating.
Once the file is prepared, run the import in the controlled order below.
- Create two or three test records in a copy or controlled batch.
- Import the smallest useful sample.
- Check dynamic pages, references and mobile layouts.
- Correct the source CSV rather than patching records randomly.
- Run the larger import and review the live listing and detail pages.
Rollback sequence if an import goes wrong
Here is the process broken into clear steps. Take them one at a time and check each off before continuing.
- Stop further imports immediately.
- Restore from the pre-import export or duplicate collection.
- Identify which records were affected by comparing timestamps.
- Re-import only the corrected rows once the source file is fixed.
- Confirm live pages match the restored data before republishing.
Common CSV import mistakes
The list below breaks this down into the parts that matter most. Read through each one and note anything that applies to your own setup.
- Reference fields pointing to a title instead of a stable ID.
- Encoding issues turning quotes or accents into broken characters.
- Blank required fields silently accepted as empty strings.
- Duplicate slugs created from near-identical titles.