Last Updated: March 23 2023
How to Bulk Import Quotes
In simPRO you can import a quotes list to create multiple quotes in the system with one upload. When a quotes list is successfully imported, you can access your newly created quotes using the Quotes menu.
In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:
To prepare to import quotes into simPRO:
- Download and add data to simPRO's Bulk Quotes Import Template for:
- Alternatively, you can create your own import list and leave out any fields that do not apply to your quotes. Mandatory columns in the import file are:
- Customer ID / Customer Name: The Customer Name must be identical to how it is defined in simPRO. It is recommended to copy and paste the names from simPRO to reduce error and import successfully. The Customer ID is available in the customer card file in simPRO and must be a numerical value.
- Site ID / Site Name: The Site Name must be identical to how it is defined in simPRO. It is recommended to copy and paste the names from simPRO to reduce error and import successfully. The Site ID is available in the customer / site card file in simPRO and must be a numerical value.
- Section Name, if importing a project quote.
- Quote Type should also be specified as either Service or Project. Alternatively, it defaults to the Service type.
- Cost Centre Name: You must enter the cost centre name as it is set up in simPRO.
- Multiple Project Tags can be specified by separating each one with a comma. However, make sure the tags do not have a comma in their name.
- To specify Due Date, format must be dd/mm/yyyy.
- Enter the Customer and Supplier Contact names in 'First Name Last Name' format.
- Save your file in your system as a compatible file type: CSV, TXT or ZIP. Consult your spreadsheet software documentation for file saving instructions, if required.
- Separate your data using the same or similar headings as specified in the Quote Import Template.
- Ensure information is accurate, up-to-date and spelled correctly.
- Remove any special characters (such as ? # $ % @ !) as these may not import correctly.
- Save your file again.
simPRO can recognise and import all headings and information listed in the Quote Import Template.
After preparing your quotes import list, work through the following steps to import your list into simPRO.
To adjust quote import settings, go to Utilities > Import > Quotes > Bulk Import.
The options available include:
|First Record Is||Select Header Record if the first row contains column titles, or select Data Record if the first row contains specific data.|
|If Custom List Value Not Found||If any of the entries are a drop-down list in simPRO and your file contains any additional values or 'custom list values' not available in the relevant list, select Create New List Option to add the additional value to the drop-down list in your recurring job templates. Select Reject and Warn to ignore the field and receive a warning when the recurring job list is uploaded that the field was not created.|
To select an import file:
- Go to Utilities > Import > Quotes > Bulk Import.
- Adjust quotes import file, then click Choose File / Browse.
- Locate your quotes import file and click Open.
- Click Next.
After selecting a quotes import file, manually match or review your list columns with the fields available in simPRO. You may have both simPRO and your list open at the same time.
To match import columns:
- Select your import file as above.
- Use the drop-down lists to match your import file columns with the fields available in simPRO.
- To leave a field out of the import, select Ignore.
- Click Import Quotes.
If you have a large list of quotes, you can navigate away and work in other areas of simPRO, then return to the import page to check on your import. You can only perform one import at a time.
After uploading an import file, the Quotes Import Complete page displays a breakdown of your import, including quotes Added / Updated / Ignored.
Click Continue to perform another import.
After a successful import, it is recommended you manually check the quotes to ensure data has been imported correctly. To do this, go to Quotes > Open Quotes, click an imported quote record, and check for errors. Manually amend if required.
If your file contains errors, an error message displays on the Quotes Import Complete page, and the table displays the number of errors found.
Click the blue link to download a CSV file of import errors. The Error Text column explains why entries failed. Amend your quotes import list accordingly and restart the import process.