Learn more

Valid formats for price update files

Your price update file must use one of the following formats:

The following examples of price update files show how to achieve the same price changes in the database with different file formats. Together, the examples:

Update the material price to $500 for any items that have a WBS code labeled “Level4” and a value of “01-09-31.50”.
Update the subcontract price to $566.14 for any items that have a price code of “U10000”.
Update the labor, material, subcontractor, equipment, and "other" price categories for phase 01-45-23.50, item 1800 to 1800, 0.65, 289.81, 578.97, 868.13, and 1157.29 respectively.

Note: For more detailed information about how to structure each type of record (for example, how to enter WBS code and Value fields), use the links in the Learn More box in this topic.

Example: Excel price update file for WBS or Phase/Item (PI) code types
Update Type*	ID	Value	L	M	S	E	O
WBS	Level4	01-09-31.50		500
PI	01-45-23.50	1800	0.65	289.81	578.97	868.13	1157.29

Example: Excel price update file for the Price Code (PC) type
Update Type*	ID	L	M	S	E	O
PC	U10000		566.14

*The first column specifies how you are going update items. For example, if the first column contains WBS, the second column will have the WBS name, and so on. Note that the PC type does not use the same number of columns as WBS or PI records.

Example: TXT or CSV price update file for the WBS or the PI type
Update Type, Id, Value, L, M, S, E, O
WBS,Level4,01-09-31.50,,500,,,
PI,01-45-23.50,1800,0.65,289.81,578.97,868.13,1157.29

Example: TXT or CSV price update file for the PC type
Update Type, Id, L, M, S, E, O
PC,U10000,,566.14,,,

Note: CSV and TXT files record the same information as the table shown in the Excel example, but without the grid. With these file formats, you need to include all the commas, as shown. You cannot skip the values, even if they are zeros or blanks.