Data Import: Parts and BOMs
Load your part master, then your bills of materials, and then your starting inventory, each from its own spreadsheet.Updated Nov 9 2026
Before you start
- Data Import is under Admin > APIs & More, shown to users with the Can View API & Import Submenu function (API Access role by default; Admin always).
- Importing BOMs also needs the Can Edit BOM function (Manager, Engineer or Can Edit BOM role by default). Without it Cetec shows You do not have permission to edit BOM.
- Every part number starts with its three-letter PRC (product code), so the PRCs must exist and be active first. Load them with the PRCs import if they aren't set up.
- Units of measure and warehouse locations you refer to must already exist (Unit of Measure and Warehouse Locations imports).
-
Import the parts
- Go to Admin > APIs & More > Data Import and pick Parts in Import Type.
- Part Number (prcpart) is the only required column. Description, Revision, Part Revision, Default Transcode and Non Inventory are suggested. Optional columns include Unit Of Measure, Purchase Uom, Vendor External Key, Work Center and the GL account columns.
- Click Download Template and fill it in. Click Choose File and pick the file; for a CSV file a CSV Delimiter box appears (leave it empty for commas). Click Import File.
- In Import Preview, each column's drop-down starts at (identify column): pick the import column for each one. Cetec unticks Use? on the header row; untick any other row to skip.
- Click Validate. A part number whose first three characters aren't an active PRC is reported as PRC "…" was not found or is inactive. A Unit Of Measure or Purchase Uom that doesn't exist is reported as not found.
- When Cetec shows Validation completed successfully., click Import.
-
Import the BOMs
- Go to Admin > APIs & More > Data Import and pick BOMs in Import Type.
- Fill one row per component with Top Level Prcpart (the assembly's part number), Component Prcpart, Component Number (the line number on the BOM) and Qty Per Top. The screen marks only Component Number and Qty Per Top as required, but every row needs both part numbers. Leave Top Level Revision and Component Revision blank to use each part's current revision. Suggested columns include Reference Designator, Scrap Factor, Scrap Adder, Customer Supplied and Vendor Supplied.
- Click Choose File and Import File, pick each column's import column in the preview, and click Validate. An assembly or component that isn't in Cetec yet is reported as no part found for prcpart …. A BOM that contains itself is reported as recursive BOM detected.
- Click Import once validation succeeds.
-
Load the starting inventory
- Go to Admin > APIs & More > Data Import and pick Bins in Import Type.
- Part and Warehouse Location Code are required. Add Quantity, Cost, Bin Location, Lot Code, Date Code and Receipt Date as needed.
- Tick Create Ledger Entries under Import Options if the opening stock should post to the general ledger.
- Click Choose File and Import File, pick each column's import column in the preview, then click Validate and Import. A part that has no record at that warehouse location is reported as Part + Warehouse Location Code combination was not found.