undefined - Bulk Import Product Data - illustration 06a6cdda-2e0c-4345-a3de-6be30f5393ad

Bulk Import Product Data

Introduction

Product imports may be a one-off task when you first start using QuoteCloud, or a regular exercise to constantly update product data and pricing from a 3rd party system.  Using a Comma Separated Values (CSV) file is a common (manual) method of copying data from one database to another. This guide explains how to import product data using a CSV file.

Data Import Process

To perform a product data import follow the steps below:

Step 1: Navigate to Content Libraries and then select the Products option (see illustration below).

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration 0718d4e6-d50c-4cef-8117-e8619e61e76a

Step 2: Click on the three dots to bring up the Import All Products button.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration bdbae4f2-b7e4-4d22-b51a-086888c6aa91

Step 3: Click on the Select File button, now select a file from your computer hard drive or network drives, or simply drag and drop your data

The CSV file will need to be in a specific format; if you do not know the correct format, you can download a sample import file using the Download Sample CSV File. This sample file will give you the correct order of data columns in your import file. 

Please make sure that the product import file you have prepared matches the sample you can download.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration d3b1edb7-a079-4e8f-ab02-af310d118a1f

Step 4: You will be prompted to Map Data Items. You can use your previously saved settings, manually match, or click Auto Matching. You can save these settings later in this process.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration 41c1fdf2-d8e8-4834-8744-d87272a5159a

Step 5: Choose whether you would like to leave as is, delete, or override your previous data upon import.

Click Yes, Import Now to start importing.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration 93f0986a-df19-4129-be68-52924855ef11

Your product data is successfully imported into QuoteCloud. A message displays with a success notification and the number of records imported.

If there is a problem with your import file, then QuoteCloud will attempt to advise you of the problem, and you can alter your file data and try again.

If you continue to have issues importing your product data, you can contact the QuoteCloud Support Team. Click on the Account menu, and then select Email Support.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration 81bcc9d8-b8d6-47af-9f62-48ab459d2e46

To help streamline your import process in the future, you are given the option to save your data mapping. 

To do this, enter a name that clearly articulates what the mapping is used for in the New mapping name field, then click Save. 

If you don't need to save the mapping, simply click Cancel and you will be taken back to the Audience screen.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Bulk Import Product Data - illustration 1fd31221-a2ae-4f52-a922-a072ba273750

Related User Guide Topics

Add a Product to your Product Catalogue
Add a Product to your Product Catalogue
12 Mar 2022
By using a Product Catalogue, Sales Consultants can be confident that they will be using the latest information and the correct price data in their sales quotes. Learn how to add products to a product catalogue in this user guide topic.
Bulk Import Product Data
Bulk Import Product Data
13 Mar 2022
Usng the block import you can import all your product data at at once. Learn how this works.
What is a Product Catalogue?
What is a Product Catalogue?
13 Mar 2022
The product catalogue feature in QuoteCloud helps your sales team quickly add standard products you sell to a sales quote. Learn more here.
Creating Sub-Folders in the Product Catalogue
Creating Sub-Folders in the Product Catalogue
12 Mar 2022
By using a Product Catalogue, Sales Consultants can be confident that they will be using the latest information and the correct price data in their sales quotes. Categorising products into easy to understand grouping helps sales consultants navigate to the product the want to add to a sales quote, learn how this is setup.
How to Add a Hyperlink to a Product Image in a Sales Quote Price Table
How to Add a Hyperlink to a Product Image in a Sales Quote Price Table
13 Mar 2022
Including images in sales quotes not only helps provide your client with a visual reference of the products/services but also allows hyperlinking to useful external links such as more descriptive product pages on your website, case studies, testimonials, etc.