You can bulk import all of your products and services into GleanQuote instead of entering them one by one or you can use bulk import to update product fields (like price, cost, etc), rather than creating new product records.
You cannot import bundled products, product options (you can bulk import option sets to products), or volume pricing. These will need to entered one product at a time.
Custom product fields can be imported by including them as a column in the import CSV.
Use the Price Calculation Method field to specify if your products are Editable Price, Cost Plus Markup, or Cost Plus Margin. The default value is Fixed Price
Use the Billing Frequency field to specify Daily, Weekly, Bi-Weekly, Semi-Monthly, Monthly, Quarterly, Yearly, Every 2 Years, or Every 3 Years billing frequencies for products. The default value is One-Time.
Use the Editable Cost field (values of Yes or No) to specify if you want the cost to be editable on the quote editor. Default is No.
Use the Option Set field to specify the name of the option set(s) you want to associate with products. You can enter more than one option set - just separate each one by commas. They will be added to the product in the order you list the names.
Use the Image URL field to specify the URL of an image (or any other product media file type) to associate with products. This URL must be a publicly accessible URL. You can include more than one URL per product in the bulk import. Just separate each URL with a space.
You can bulk import Sales Tips and UpSell/DownSell/CrossSell items for each product.
Here is an example CSV for Uploading Products (Basic info)
To get started, navigate to the Product list view and click the orange Bulk Import button.
You will need a CSV file of your products/services that is less than 5MB in size. The format of the CSV is shown in the image below. The minimum columns should be Name, Model, Price, and Supplier. Make sure that you have all of the Suppliers defined in the GleanQuote Supplier section before importing your products. Each row should be a separate product.
Note, for tags and multi-select drop down fields, if there is more than one value, then separate them by commas and each value will be added to the product field.
Once you have uploaded your CSV file, you will be able to map the fields in the CSV to GleanQuote fields.
You can map CSV fields to more than one GleanQuote field by clicking the Map to Additional Field link.
The Duplicate Data drop down enables you to determine how Duplicate Data is handled for each field. Options are Do Not Overwrite, Overwrite, Overwrite if Blank. For tags and mulit-select fields, there is an additional option of Add to Existing Values.
If you have extra columns in the CSV that are not needed for the import, you can toggle the Exclude from Import toggle to ignore them.
Name, Model, Price and Supplier are required fields and must be mapped to a GleanQuote field.
On the next step, you will be able to correct any mapping errors. For instance, if you typed a value for a field that does not exist, you will be able to Add as New Value or Add as No Data or Select the value you meant to type in the CSV. In this instance, for the field Tags, one of the products had a value of On Sale typed in the CSV when it should have been On Sales. You can map it to the correct value as we did in this example. Also, the value Great Buy did not exist as a tag, so you can Add as a New Value here and a new tag will be created with the value of Great Buy.
Next, you will be able to review your mapping with a data from the first product in your CSV file.
After clicking the Accept and Import button, a confirmation screen will display letting you know that the import will take place in the background.
When your import is complete, you should receive an email and/or an in-app notification (depending on your notification settings in your user settings) letting you know the import is complete.
You should then be able to view your newly imported products from the product list view.