Imports • reference

CSV Import Hub & Migration Overview

Centralized spreadsheet migration hub for Categories, Suppliers, Products, Stock, and Lots with Create Only vs Upsert modes and dry-run validation.

Reviewed on 2026-10-07

Get the source files ready#

Gather clean source files and create referenced categories, products, and warehouse locations before importing stock.

Validate and import in the right order#

  1. 1
    Open CSV Import and choose the data type you need.
  2. 2
    Download its template and enter one record per row without renaming the column headers.
  3. 3
    For a new company, import categories, suppliers, and products before opening stock or lots.
  4. 4
    Under Existing records, choose Create only or Create or update. Select Validate, fix errors, then Import.
  5. 5
    Open a sample record from each imported file before starting the next file.
  6. 6
    Keep the validated source files and import results with the migration workpaper.

If many rows fail, stop the sequence and resolve the template or reference data first.

Check the imported records#

Review the accepted, failed, and skipped counts. Open sample records and compare them with the file you supplied.

WARNING: Validate does not save records; Import does. Save the row results before retrying so you do not duplicate or overwrite data.

Have a question about this workflow?

Subscribed customers can ask questions about this guide inside the authenticated dashboard.

Ask about CSV Import Hub & Migration Overview in Dashboard