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
Why it matters: a bad import puts hundreds of wrong records into Cetec at once. Validating before importing is what catches the mistakes.
-
Get the import template
- Open
Admin > APIs & More > Data Import. The page is titled Import Data To Cetec ERP. - Pick the
Import Type, such as Parts. Available Import Columns then lists the required, suggested and optional columns. - Click
Download Template. For what each column means, clickImport Documentationat the top, open its menu (☰) and pick the import type. - Fill in the template. Required columns must be filled on every row.
- For parts, start each
Part Number (prcpart)with the part's 3-letter PRC, such asPRT+1234-5. Otherwise validation says PRC "…" was not found or is inactive.
- Open
-
Load and check the file
- On Data Import, click
Choose Fileand pick your file. Password-protected spreadsheets can't be imported. For a CSV, type theCSV Delimiterthat appears, such as,. - Set the
Import Options, such asUpdate Related Data. Leave them unticked to add new records only. - Click
Import File. Cetec shows the Import Preview. - Check the drop-down above each column names the right column; set it to
(identify column)to skip that column. UntickUse?on any row you don't want to load, such as the header row. - Click
Validate. Validation/Import Results lists each problem with its row and column. Fix the file, attach it again, clickImport File, andValidateagain.
- On Data Import, click
-
Import the records
- When Cetec shows Validation completed successfully., click
Import. It stays greyed out until the file validates. - Check Rows imported in the results, and click
Download Import Summaryto keep a record of what was loaded.
- When Cetec shows Validation completed successfully., click