---
title: "Importing Product Quantities into a New Estimate"
slug: "importing-product-quantities-into-a-new-estimate"
updated: 2025-07-01T08:13:54Z
published: 2025-07-01T08:13:54Z
canonical: "docs.avontus.com/importing-product-quantities-into-a-new-estimate"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Importing Product Quantities into a New Estimate

ou can import Product quantities into Estimates using two import features (see below). An import matches the part number in the import file with the part number for the Product in Quantify to add quantities in an Estimate.

This article contains the following:

## Importing Product Quantities from Another Avontus Program

Quantify enables you to import Product quantities into an Estimate from other Avontus programs, including Avontus Designer, Handset Designer and Scaffold Counter.

To import Product quantities from another Avontus program:

1. Click the appropriate location in the Organization Tree, then click the **Estimates** tab.
2. Click the **Import** button.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/import%20gif.gif)

The *Quantify Import File* dialog appears.
3. Locate and select the Quantify Import File (.qimport file format) and click **Open**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-8NY0ARDX.png)

If there any unmatched parts, a warning message will appear.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-P1CAXD4X.png)

Click Yes to view the errors, and see the missing parts.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-9CHR123V.png)

If you click no, the *Estimate* dialog appears, with the **Summary** tab pre-selected.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-BUFV9DBV.png)

(If you view the **Products** tab, you will see that it displays quantities for the part numbers included in the import file.)
4. Click the **Assigned** dropdown and select the appropriate Branch Office or Sub-Branch.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-QSAYM3NF.png)
5. Click the **Customer** dropdown and select the appropriate customer.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-PT8RSZQ4.png)
6. Click the **Delivery** calendar icon.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-KE9NTSGC.png)

A calendar appears.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-8GY55OJG.png)
7. Locate and click the appropriate delivery date.
8. Click the **Return** calendar icon.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-XGCR0QEG.png)

A calendar appears.
9. Locate and click the appropriate return date.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-4QI8D48E.png)
10. Click in the **Label** text field and enter the appropriate label.

> **Note:** If the same part number is referenced more than once in the import file, the quantities for this item will be combined on the Estimate.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-WL1L5LQ4.png)
11. Click **OK** to create the Estimate

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-UPD00VCP.png)

If Quantify cannot find part numbers, they will not be included in the import. The unmatched part numbers will be displayed in **View Errors**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/856dcb00-95eb-4fb5-bae0-3962793fb0f2.png)

## Import from a Tab Separated File

You can import Product quantities into a Quantify Estimate using a tab-separated file. This is a common file type saved in programs like Microsoft Excel.

This should be a tab separated file with two columns (no header row). The first column should contain part numbers. The part numbers must exactly match the desired part numbers as they appear in Quantify, including spaces and symbols. The second column should contain quantities. These should be whole numbers without decimals or other characters.

To import from a Tab Separated file:

1. Click the appropriate **Branch Office**, click the **Estimates** tab and click the **Add Estimate** button.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/import(1).gif)

The *Estimate* dialog appears.
2. Click the **Customer** dropdown and select the appropriate customer.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-HD1A0UOP.png)
3. Click the appropriate radio button in the **Estimate Price is For** section: **Rent**, **Sell Available**, or **Sell New**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-XQ77B3IL.png)
4. Click in the **Rent Discount %** text field and enter any applicable rent discount percentage.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-DXLCJFJR.png)
5. Click the **Delivery** calendar icon.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-UPKM0GVO.png)

A calendar appears.
6. Locate and click the appropriate delivery date.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-NAJVLQ35.png)

This date will appear on the printed estimate.
7. Click the **Return** calendar icon.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-MDX82SHB.png)

A calendar appears.
8. Locate and click the appropriate return date.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-5OL0QYCT.png)

> **Note:** The next two fields are required, but may be set by the Rate Profile you select in the **Products** tab. They also set up the length of the rental and effect the Estimate total.
9. Click in the **Label** text field and enter the appropriate label.
10. Click in the **No. Periods** fields the length of the rental.

> **Note:** The label and days may be overwritten when copying rates from a Rate Profile, if the Rate Profile uses a different Rental Days setting.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-PN10SQTB.png)
11. Click the **Products** tab.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-106CGGS8.png)

The *Estimate* dialog refreshes.
12. Click **Import**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-KTSSDA32.png)

The *Import Quantities* dialog appears.
13. Click the **Import** button. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3b3a6855-aee8-43c4-8fd4-9caff23e8466.png) The *Import From Tab Separated Value File* dialog appears.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-6A8G1NDQ.png)
14. Locate and select the file you want to import, then click **Open**. The *Import Quantities* dialog returns.
15. As necessary, click the appropriate **If quantity exists** radio button. Your options are: **Ignore** and **Overwrite existing quantity with value from the file**. This determines what Quantify will do if a quantity exists for a part number that is also in the import file.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-ENC43JS7.png)
16. Click **Import**. If Quantify cannot find part numbers, they will not be included in the import. Quantify will display the unmatched part numbers in the *View Errors* dialog.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-05RZ1YNB.png)

> **Note:** If the same part number is referenced more than once in the import file, the quantity for this item will be set to the last entry in the import file.