Importing files into our system is straightforward if you follow the guidelines and steps outlined below. This document will help you ensure a smooth and successful import process.
Sample File for importing or updating opportunities: Sample file
Prepare Your Data
Supported File Types
Ensure your file is in .csv format.
File Preparation Requirements
Sheet: Only one
Size: Smaller than 30 MB
Headers: Include a header row with at least one column corresponding to a field in the system
Please note that Opportunity import is not a reversible action
Mandatory Fields
1. For Creating Opportunities: Contact ID, Opportunity name and Pipeline ID/name.
Default values:
If the Stage ID/name is absent, it defaults to the first stage under that pipeline.
If the Opportunity Value is absent, it defaults to 0.
If the Opportunity status is absent, it defaults to “Open”.
If the Opportunity lost reason is added and is valid, the Opportunity Status will be updated to "Lost"
Opportunity ID, Pipeline ID/name and Stage ID/name can be fetched by exporting opportunities.
Contact ID can be fetched by exporting contacts in the same sub-account.
2. For Updating Opportunities: Opportunity ID (can be fetched by exporting opportunities)
Understanding Import Options
When importing objects, you have three options to choose from:
Create Opportunities: Use this option to upload only new records into the system.
Update Opportunities: Select this option to update information for existing records.
Create and Update Opportunities: Choose this option for a combination of adding new records and updating existing ones.
Structuring Your File
Field Formatting
Date Picker:
Acceptable formats: mm/dd/yyyy (e.g., 10/28/2020), yyyy/mm/dd (e.g., 2020/10/28), mm-dd-yyyy (e.g., 10-28-2020), yyyy-mm-dd (e.g., 2020-10-28).
Multiple Options, Checkbox, Textbox List:
Acceptable formats: Value 1, Value 2, Value 3 (e.g., Blue, Yellow, Green). You can also use ; or . as separators.
Radio, Single Option:
Acceptable formats: Value 1 (e.g., Blue).
Opportunity Owner:
Format: FirstName LastName (e.g., Logan Paul).
Tags:
Acceptable formats: Value 1, Value 2, Value 3 (e.g., Blue, Yellow, Green). You can also use ; or . as separators.
Phone Number:
Format in E.164 (e.g., +1 1234567890). For US numbers, formats like 123-456-7890 or (123) 456-7890 are also acceptable.
Numerical:
Acceptable formats: 1.23, 1234, .123.
Monetary:
Acceptable formats: 1234, 1,234,234.33.
Opportunity Followers:
Acceptable format: FirstName LastName, FirstName2 LastName2 (e.g. Adam Smith, David Lee)
Importing Your File
Steps to Import:
Turn on Opportunities Import under "Labs" > Subaccounts
Go to Opportunities
On the top right under 3 dots, click on "Import Opportunities"
Upload Your File: Click the 'Import' button and upload your file. Also select whether you would like to "Create", "Update" or "Create and Update"
Map Your Fields: Ensure each column in your file is correctly mapped to the corresponding field in the system. Adjust the mappings if necessary.
A few things to note:Checking the "Don't update Empty Values" checkbox will not update any field if the imported file has empty values and the field does have some value for the opportunity
If you decide to not import certain field, you can choose to keep it unmapped and check the box on the bottom to proceed. -"Please ensure all mandatory fields are mapped. To proceed, either map all fields or choose Don't import data for unmapped columns"
6. Review and Confirm: Review the data preview to ensure everything looks correct. Confirm the import to proceed.
Note that it is mandatory to check the box on the bottom and accept the disclaimer to start importing.
You can also add tags to the corresponding contacts for these opportunities on this screen.
7. Monitor the Import: Check the import progress under Opportunities > Bulk Actions. If any errors occur, refer to the error messages provided for guidance on fixing them.
8. Monitor stats, errors and warnings by clicking on the "Show Stats" button for any import.
Troubleshooting Common Errors
Error: Invalid option selected for multiselect or dropdown field
Solution: Check your import file for incorrect values in multiselect or dropdown fields by comparing them with the options in the system. Update the value in your file to match an existing option or add it as a custom option in the system. Then re-import the file.Error: Invalid Contact ID
Solution: Verify that the Contact ID exists in the system or remove the ID if not updating an existing contact.Error: Could Not Parse Date
Solution: Ensure date fields are in one of the acceptable formats: mm/dd/yyyy, yyyy/mm/dd, mm-dd-yyyy, yyyy-mm-dd.Error: Duplicate Unique Property Value
Solution: Ensure there are no duplicate values in fields marked as unique, such as emails or IDs.Error: File Not Found
Solution: Verify that your file is the correct type and format. Re-upload the file.Error: Required Fields Missing
Solution: Ensure all mandatory fields (e.g., Opportunity Name for opportunities, Email/Phone/Name for contacts) are included and correctly formatted.
Additional Tips
Double-check your file before importing to avoid errors.
If you encounter any issues during the import process, refer back to this guide or reach out to our support team for assistance.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article