How To Edit/Update Standard Costs

Help/
Guides/

How To Edit/Update Standard Costs

A part's standard cost is set per warehouse. Change it for one part on the part's view, or for many parts at once with the Standard Cost Import.

Updated Nov 9 2026

Allow external media cookies to watch this video.

Before you start

Changing a standard cost needs the Can Edit Part Bin Cost function (Manager, Purchasing, Supervisor, Part Edit or Part Bin Edit by default). Without it, Cetec saves the rest of the warehouse data but leaves the standard cost unchanged.
The warehouse edit icon needs Can Edit Part as well.
The Parts > Pricing menu needs the Parts role. Its Standard Cost Import isn't available when your company costs sales at average cost: it is hidden from the menu.

1
Edit one part's standard cost
1. Go to Parts > Lists > Part List and click the part's number in the PrcPart column. The part's view opens.
2. Find the WAREHOUSE SPECIFIC DATA FOR section for the warehouse and click the pencil beside its heading (Edit Inventory Info.). A window titled with the part and warehouse opens.
3. Enter the new cost in Std Cost. To have Cetec work it out instead, choose BOM Rollup or Price Engine under Set Stdcost.
4. Scroll to the bottom of the window and click Update. Cetec shows Part update inventory succesfully and the section's Std Cost shows the new value.
2
Update standard costs from a file
1. Prepare an Excel or CSV file with three columns: the part number (Prcpart), the warehouse code (Location, for example MN) and the new standard cost (StdCost). A header row is fine. The file can have up to 2,500 rows and can't be password protected.
2. Go to Parts > Pricing > Standard Cost Import.
3. Under Upload a New Document, choose the file and click Import File. A preview opens.
4. In the preview, check the column type above each column (Prcpart, Location, StdCost) and untick Use? on any row you don't want. If your header row uses those names, Cetec picks the types and unticks the header row for you.
5. To also change the cost of the stock already in those warehouses, tick Update Inventory Value and choose an Inv Shortage reason.
6. Click Update, check the preview, then click Finish. Cetec imports the costs and returns to the upload page, which may not show a message. To confirm, open one of the parts and click the Std Cost link in its warehouse section: the history lists the new cost.