All Collections
Customers
Importing Customers
Importing Customers

How to upload and delete imports and template download

K
Written by Kim
Updated over a week ago

Importing Customers


You can easily import your customers into ShowroomHQ via a .CSV spreadsheet file. There are 4 steps in the import process: Upload, Verify, Preview, and Import

Click on the image to play tutorial or to view it full screen.

  1. Go to the Customer List > "Import Customers" (Note that if you do not see this option please contact us and we can help you get that set up).

  2. Click "Import Customers" 

  3. Choose your data file (.CSV file) 

  4. Import Customer as an 'account'/'lead'/'prospect' OR choose whether the list is entirely made up of just 'accounts' or just 'leads'  

  5. Does the first line of your file contain column names? Select "Yes" if it does.

  6. Duplicate records : Skip/overwrite or duplicate the customers upon import

  7. Advanced options are available with the options for 'Delimiter character' , 'Escape character' , 'and 'Enclosure character'

  8. Click "Upload" 

  9. Verify > the import tool should match up most of the fields automatically. However, if the title of the columns are not the same as the field names in ShowroomHQ you may have to manually map the fields yourself.

    *Note that you can add multiple locations and contacts from this page by clicking "Add another location mapping information" or "Add another contact mapping information". 

  10. Click "Next" 

  11. Preview > this step will ensure that the fields have been mapped correctly and there are no errors. If there are errors in the import, they will be listed by customer. If there are no errors, and all look good click "Next" 

  12. Your customer list will begin importing

  13. Import Complete > any errors with the import will appear here with a file that can be downloaded to review any changes that need to be made

Deleting A Bulk Import


If you have made a mistake, or want to remove an import, do not make any changes to any of the records that you have just imported. If you do, the system will not allow a reverse on the import.

You can bulk delete an import by following the below steps:

  1. Go to Company Settings

  2. Import > Select the import that you wish to remove

  3. Click "Delete records"

As always if you run into any issues with this, please shoot us a message and we can walk you through it - support@showroomhq.com .

Customer Import Template


You can download the import templates by following the link: Download Customer Import Template. Please follow the instructions provided in the file.

Did this answer your question?