Skip to main content
All CollectionsQuote-to-Order Workflow
Importing Products to a Quote from a CSV/Excel File
Importing Products to a Quote from a CSV/Excel File

Reduce rekeying and speed up the quote creation process by importing products to a Quote from a CSV or Excel file!

Isobel Honour avatar
Written by Isobel Honour
Updated over a week ago

Importing products from a CSV/Excel file can dramatically reduce rekeying for your Sales team when creating Quotes or orders for customers. If your customers provide you with lists of the products they want to purchase from you with the desired quantities, or better yet in a CSV/Excel format, then this option will be extremely helpful when creating Quotes.

Step 1: Download an example CSV/Excel File

Before starting to use the import option, we recommend downloading an example CSV/Excel file so you can see the required format. To download an example copy, click on the three dots in the right-hand corner and select the 'Import Products from Excel/CSV' option. 

You will then be able to click on the 'Download an example' option, which will download an example CSV for you to take a look at. 

The example CSV has two columns; Product ID and Quantity. These are required in order to import the correct products onto the Quote. 

Step 2: Drag and Drop the File

The quickest way to upload a completed CSV/Excel file is to drag and drop the file within the 'Drag Excel or comma-separated value (CSV) files here' section on the Quote. 

Step 3: Review the Product IDs & Quantities

Once you have dragged and dropped the required file into the CRM, the system will try to identify the product IDs and quantities. All product IDs and quantities will be listed for you to review, where you can then deselect any that are no longer required. The CRM will also automatically un-tick any product IDs that are invalid. Once happy with your selection, click 'Import Products' and the selected products will be added to the Quote. 

For more information on creating Quotes, take a look at our article

Did this answer your question?