Skip to main content
Try for free

Import data

Load records into Cetec from a file.

Updated Nov 5 2026

Who this is for

Cetec administrators and implementation leads load parts, customers, vendors, BOMs, prices and opening balances from spreadsheets — at go-live, and whenever a batch of records is easier to load than to type.

Applies to
Setup

Why it matters: a bad import puts hundreds of wrong records into Cetec at once. Validating before importing is what catches the mistakes.

  1. Get the import template

    1. Open Admin > APIs & More > Data Import. The page is titled Import Data To Cetec ERP.
    2. Pick the Import Type, such as Parts. Available Import Columns then lists the required, suggested and optional columns.
    3. Click Download Template. For what each column means, click Import Documentation at the top, open its menu (☰) and pick the import type.
    4. Fill in the template. Required columns must be filled on every row.
    5. For parts, start each Part Number (prcpart) with the part's 3-letter PRC, such as PRT + 1234-5. Otherwise validation says PRC "…" was not found or is inactive.
  2. Load and check the file

    1. On Data Import, click Choose File and pick your file. Password-protected spreadsheets can't be imported. For a CSV, type the CSV Delimiter that appears, such as ,.
    2. Set the Import Options, such as Update Related Data. Leave them unticked to add new records only.
    3. Click Import File. Cetec shows the Import Preview.
    4. Check the drop-down above each column names the right column; set it to (identify column) to skip that column. Untick Use? on any row you don't want to load, such as the header row.
    5. Click Validate. Validation/Import Results lists each problem with its row and column. Fix the file, attach it again, click Import File, and Validate again.
  3. Import the records

    1. When Cetec shows Validation completed successfully., click Import. It stays greyed out until the file validates.
    2. Check Rows imported in the results, and click Download Import Summary to keep a record of what was loaded.