Data Import: Customers & Vendors
Load your customers and vendors from a spreadsheet, then load their contacts, so that every contact is attached to the right company.Updated Nov 9 2026
Before you start
- Data Import is under Admin > APIs & More. The APIs & More menu appears only for users with the Can View API & Import Submenu function (the API Access role by default; the Admin role always has it).
- Load the codes your customers and vendors point at first, using Terms, Shipping Methods and FOB Codes imports (see Data Import: Understanding the Basics). A customer's or vendor's Terms column must match the External Key of a terms code that already exists.
- Give every customer and every vendor an External Key of your own (for example the number from your old system). The contact files find their company by that key.
-
Import the customers
- Go to Admin > APIs & More > Data Import. The page is titled Import Data To Cetec ERP.
- In Import Type, pick Customers. Available Import Columns lists the columns: Customer Name and External Key are required; Credit Limit, Highest Limit and Intercompany are suggested. Optional columns include Terms, Custnum, Sales Location, Taxable and the contact and accounting phone/email fields.
- Click Download Template, fill it in, and save it.
- Click Choose File and pick the file. For a CSV file a CSV Delimiter box appears; leave it empty for a comma-separated file. Click Import File.
- In Import Preview, the drop-down above each column starts at (identify column): pick the import column for each one. Cetec unticks Use? on the header row; untick it on any other row you don't want loaded.
- Click Validate. Fix anything listed in Validation/Import Results (each problem shows its row and column), load the file again and validate again. A Terms value that matches no terms code is reported as Terms was not found.
- When Cetec shows Validation completed successfully., click Import, then Download Import Summary to keep a record.
-
Import the customer contacts
- Go to Admin > APIs & More > Data Import and pick Customer Contacts in Import Type.
- Fill Customer External Key on every row with the External Key you gave that customer in the customer file. It is the only required column. Contact Firstname, Contact Lastname, Contact Email, Contact Mobile and Primary Contact are suggested.
- Click Choose File, then Import File, pick each column's import column in the preview, and click Validate.
- Click Import once validation succeeds.
-
Import the vendors
- Go to Admin > APIs & More > Data Import and pick Vendors in Import Type.
- Vendor Name and External Key are required. The corporate and remit-to address columns (Corporate Name, Corporate Street1, Corporate City, Corporate State, Corporate Zip, and the matching Remit columns) and Intercompany Flag are suggested. Terms, Fob and Shipvia Method Of Shipment are optional and look up codes you imported earlier.
- Click Download Template, fill it in, then Choose File and Import File. In the preview pick each column's import column (unmapped required columns give Missing required columns: External Key, Vendor Name), then click Validate.
- Click Import once validation succeeds. Cetec also uses the External Key as the vendor's Vendor #.
-
Import the vendor contacts
- Go to Admin > APIs & More > Data Import and pick Vendor Contacts in Import Type.
- Fill Vendor External Key on every row with the vendor's External Key from the vendor file. It is the only required column.
- Click Choose File and Import File, pick each column's import column in the preview, then click Validate and Import.