An across-the-board price increase is common when material costs shift or when you need to adjust margins. The hard part is applying changes consistently across all affected parts without missing items or introducing typos that show up later on quotes and orders.
Cetec ERP supports bulk updates through a pricing/costing import. Instead of opening each part record and editing prices one at a time, you can prepare a spreadsheet and import changes in one pass.
Why Bulk Price Updates Matter
When a price update touches dozens or hundreds of parts, manual edits create two risks: inconsistent pricing and extra administrative time. Using an import helps your team apply the same update logic across the full list, then move on to quoting and order management with confidence.
Prepare Your Pricing Spreadsheet
Start by building the spreadsheet you will import. Cetec ERP accepts .xls and .csv formats. Include the columns you need for the update and leave the rest out.
The available columns include:
- PRC
- Part
- Desc
- Qty
- Cost
- Resale
- Std Cost
- MOQ
- StdPack
- UOM
- Leadtime
- Vendor Name
- Ignore
Run the Pricing/Costing Import
In Cetec ERP, navigate to Parts > Pricing Maintenance > Pricing/Costing Import. Click Choose File, select your spreadsheet, then click Import File.
Map Columns and Handle the Header Row
After you upload the file, Cetec ERP prompts you to define how the spreadsheet should be read. If your spreadsheet includes a header row, uncheck the header row option so Cetec ERP does not treat the header as part data.
Next, map each spreadsheet column to the correct field in Cetec ERP. Use Identify Column and select the matching field name from the drop-down list.
Update and Review Results
When the column mapping is complete, click Update at the bottom of the page. At that point, your updated pricing and costing data is applied based on the spreadsheet values you provided.
Key Takeaways
- Use the pricing/costing import when you need to update many part prices without editing records one-by-one.
- Build a .xls or .csv with only the columns you intend to update, then upload it through Parts > Pricing Maintenance > Pricing/Costing Import.
- Confirm header row handling so the system does not treat headers as part data.
- Map each column carefully using Identify Column before clicking Update.
Conclusion
Price increases do not have to mean manual part-by-part updates. With a prepared spreadsheet and the pricing/costing import, Cetec ERP lets your team apply changes in a consistent way and keep your pricing data current.