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 doesn’t affect existing estimates.

Data Importer doesn’t update prices for labor or equipment where you use crews.

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

Before you begin

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

Update prices

1. In the Database Editor, open the standard database for which you’re going to update prices.
2. On the Data tab, click Import.
3. In the Import Data window, locate the Source file name box.
4. Type the name of the price update file for the current database, or browse to select the file. If you don’t see the file, confirm you selected the correct file type.
5. To start the price update, click OK. To cancel the update, click Cancel. Canceling restores the original prices in the current database.
6. When the import price update finishes, click the View Log button to display a report. This lists the records that it updated and records that it couldn’t process.
7. Check the log to confirm it includes the required changes. Confirm the log doesn't contain errors or unwanted exceptions.
8. To accept the changes and update your database, click Save on the Home tab. To discard the changes and revert the prices before the price update, close the database without saving.
9. To update the database for use in Estimating, click Check In on the Home tab. To cancel the checkout and remove any changes made, click Undo Check Out.

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