You can easily update prices in a standard database with prices from a third party service by importing price information.

The price import file must use a format and data structures that the Data Importer can read.

Estimates you create after updating prices use the new database prices. Updating the database prices does not affect existing estimates.

Notes:

Data Importer does not update prices for labor or equipment where crews are used.

If multiple source rows in the price update file use the same criteria, the final sequential row is used to update the target table

Before you begin
Create a price update file using an acceptable format and structure.

To update prices:

1. In the Database Editor, open the standard database for which you are going to update prices.
2. On the Data tab, click Import.
3. In the Import Data window, in the Source file name box, type the name of the price update file that you want to use to update the current database, or browse to select the file.

Note: If you do not see the file you are looking for, select the correct file type beside the File name box.

4. To start the price update, click [OK].

To cancel the update, click [Cancel]. The original prices will be restored in the current database.

5. When the import price update is finished, click the [View Log] button to display a report that lists the records that were updated as well as records that could not be processed and the reason.
6. Check the log to ensure that it includes all the required changes and that there are no errors or unwanted exceptions.
7. To accept the changes, updating your database permanently, on the Home tab, click the Save icon .

To discard the changes, reverting to the prices before the price update, close the database without saving the price changes.

8. To update the database for use in Estimating, on the Home tab, from the Database group, click Check In.

To cancel the checkout and remove any changes made, click Undo Check Out.

Getting Started: Updating prices in the standard database (SQL)