1. Home
  2. Setup
  3. Estimating Settings
  4. Import/Export Items
  1. Home
  2. Needs Update
  3. Import/Export Items

Import/Export Items

Print Friendly, PDF & Email

Export Item Prices

You can export prices of existing Items to an Excel file or to a Google Sheet. This can be used to efficiently update multiple items at one time or when requesting costs from a New Supplier/Subcontractor.

  1. To export prices, on the navigational sidebar, select Setup.
  2. Once the Setup section expands, select Estimating.
  3. On the tabbed menu, select Export Prices.
  4. In the From and To boxes, select the range of Items for export.
  5. Click Preview. The system will generate a list of Items within the selected range.
  6. Click Generate File or Generate Google Sheet..
  7. Save the prompted Excel file to your local computer by clicking Download. Or click the link to transition to the generated Google Sheet file in the Link to Google Sheet form.

Note

The exported file will include the four columns: Code, Price, Description, and UoM. The Description and UoM columns in the Excel file will be ignored by the system during the import.

Import Item Prices

You can import prices of existing Items and update them in the system. Additionally, you can import new Items with their prices into the system.

You can import prices in two ways:

  1. from an Excel file
  2. from a Google Sheet
  1. To import prices, on the navigational sidebar, select Setup.
  2. Once the Setup section expands, select Estimating.
  3. On the tabbed menu, select Import Prices.

The Import Prices page opens, as follows:

To import prices from an Excel file:

  1. Click the Select Excel File button and select the file with prices for importing.
  2. Click Import Prices. The system will upload the selected the file and parse it. The system will do the following:
    1. determine updated Items
    2. determine new Items
    3. determine Items with errors
  3. Switch between the tabs to select Items that you want to import into the system.

Note

The system will reject any imported file if its file extension differs from *.XLSX.

On the Updated Items tab, you can view Items which price was changed. For each Item, the following information is shown:

CodeCode of the Item.
Current Price, $Current price in dollars of the Item.
New Price, $New price in dollars of the Item from the imported Excel file.
Variance, $Price variance in dollars. It is calculated as a variance of the new price to the current price.
Variance, %Percentage price variance. It is calculated as a ratio of the new price to the current price.
TrendTrend of the price change which is indicated with the arrows, as follows:

 

 – price was decreased.

 – price was increased.

On the list with Items with updated prices, select the ones you want to update in the system. To select all records, check the Select All box located above the table with Items.

On the New Items tab, you can view new Items which do not currently exist in the system. For each Item, the following information is shown:

CodeCode of the Item.
Price, $Price in dollars of the Item.
UoMUnit of Measure of the Item. The select box activates when you select the Item for importing. Select the Unit of Measure which applies to the Item.
Sales TaxCheck the box to apply the sales tax to the Item. The check box activates when you select the Item for importing.
DescriptionDescription of the Item. By default, the Item description is not imported from the Excel file. You can specify manually description for a new Item.

On the New Items list, select the ones you want to import into the system. To select all records, check the Select All box located above the table with Items.

On the Errors tab, you can view rows that contain invalid data about Items in the imported Excel file. For each error, the explanatory description is provided, as follows:

Item Code in row N is emptyThe Item Code is not provided in the imported Excel file.
Item Code in row N is not uniqueThe Excel file more than one Item with the same Item code.
Item Code in row N has incorrect formatThe Code of the Item is of the incorrect format.
Price in row N  is emptyThe price of the Item is empty.
Price in row N has incorrect formatThe price of the Item has incorrect format.
Unexpected error in row NAny error that differs from the errors described above.

When complete, click Apply.

Note

During import of Items with updated prices, the system performs the following activities: 
1. The system updates the Item Cost. 
2. The system finds all Components where updated Items are used and initiates recalculation of the Component Cost.
3. The system finds all House Plan Estimates where updated Items are used and initiates recalculation of these House Plan Estimates.

To import prices from a Google Sheet:

  1. Click the Select Google Sheet button.
  2. In the Select a file form, select the Google Sheet with Items and prices.
  3. Click Select.
  4. Click Import Prices.
  5. Review the updated and new Items, as well as errors in the Google Sheet. For the details, see the importing from an Excel file.
  6. When complete, click Apply.
Updated on November 6, 2021

Was this article helpful?

Related Articles