I am writing to report an urgent issue with the multi-object import tool that is preventing me from uploading critical historical data.
I have spent the entire day troubleshooting this single import. We have tried everything: - Rebuilding the source file from scratch multiple times. - Ensuring all required properties are included (Deal Name, Pipeline, Deal Stage, Unit Price, etc.). - Verifying 100% match for all associated Company and Product names. - Clearing browser cache, logging in/out, and trying different browsers.
After all this effort, we have reached a state where the mapping is now **100% PERFECTLY CORRECT**, as required by your system. I have attached a screenshot that proves this.
Despite the mapping being perfect, the error messages are still displayed, and the "Next" button at the bottom of the page remains inactive. I am completely blocked and cannot proceed.
This is clearly a bug in the import tool. I need your team to please investigate my account and provide a solution to get this data imported.
@WElsehey for line items, you have mapped SKU, unit price, and quantity - but HubSpot requires "Product" or "Name" on top of that. The green check marks simply label that all available mappings are correct. But that doesn't change that mappings are still missing. In your import file, you need to add at least one additional column for name / product.
If I'm missing the name / product mapping in the screenshot, please point it out to me.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
This is almost always one of two things: 1) A required Line item field is still missing. For line items, you must import either: - Name + Quantity + Unit price, or - Product reference (Product ID or SKU) + Quantity. If you mapped SKU, Unit price, and Quantity, you still need to make sure the “Product” association is actually mapped using Product ID or SKU. Mapping a column to the generic “SKU” property alone is not sufficient unless it is mapped to the Line item’s Product association (the UI label often reads “Product” and then lets you choose Product ID or SKU). If you’re not linking to a Product, you must include a Line item Name column. 2) The wizard is blocking on a hidden validation state (e.g., one object is still set to Create and update, a column with errors is set to Don’t import, duplicate/hidden header characters, etc.). When any object panel has an unresolved red requirement, the Next button remains disabled even if you see green check marks on other mappings.
It is not a bug and the screenshot you have attached is actually telling you which properties need to be matched in order to update records.
When you import anything into HubSpot you can always select of you want to:
Create and update
Just create
Just update
Based on your screenshots you have selected to "create and update", which requires a unique identifier which is either always the record id and/or an additional unique identifier (contact = email, company = domain, or anything else you have set as unique property).
So unless you match these you can proceed with your import.
I would always recommend the following for an initial major import:
importing objects like deals and companies separately as "create only" imports and individual imports
Export them so you get the HubSpot record IDs
Match these back to your data in original import file
Import the line items (by matching the deal record id
Re-import companies & deals by matching record ids - that will create the associations in HubSpot
Frank
Found my comment helpful? Great! Please mark it as a solution to help other community users.
I think there has been a misunderstanding of the core issue. I am not trying to **update** existing records. This is my **initial, first-time import** to **create** new historical deal records in what is essentially an empty portal. My goal is to create new records, not update old ones.
The problem is not a failure to match unique IDs for an update. The problem is that the import tool is **blocked** at the mapping stage.
As my screenshots clearly show, I have perfectly mapped all the **required properties for CREATION** (Deal Name, Pipeline, Deal Stage, Company Name, SKU, Quantity, Unit Price).
However, even with this 100% correct mapping for a "create" operation, the **"Next" button remains inactive (grayed out)**, and the generic error messages do not disappear. I am physically unable to proceed to the next step.
As shown in your screenshot you are importing all objects with a "create and update XZY" selection which in turn prompts you to match "record ids" for all of your 3 objects you are trying to import - it is all there in the screenshots. Not sure how else to explain it...
Found my comment helpful? Great! Please mark it as a solution to help other community users.
You seem to be missing required line item properties - that's why you can't proceed. Resolve the red warnings and you should be able to.
See the Line item section at the top:
"Map all of Name | Quantity | Unit price OR Map all of Product | Quantity"
You're missing either the "Name" or "Product".
In other words, this is not a bug. It may not be the most intuitive UI and guidance in this step but you're simply missing additional required properties.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
I understand why you believe I am missing required properties, as you are looking at the initial error message. However, this conclusion is incorrect. The core of my problem, which was detailed with multiple screenshots in my original post, is what happens **after** I map all those required properties correctly.
To be clear: I have already mapped all the required properties for Deals, Companies, and Line Items (`Deal Name`, `Pipeline`, `Deal Stage`, `Company Name`, `SKU`, `Quantity`, and `Unit Price`). **Please see the attached screenshot again**, which shows a 100% perfectly correct mapping.
The problem is that **even with this perfect mapping, the error messages at the top do not disappear, and the 'Next' button remains inactive**. We are completely blocked.
I must emphasize the context here. I have spent my entire day—over 9 hours now—on this single, fundamental task. My goal is to evaluate the HubSpot Free CRM to build a strong case for my company to purchase a paid Sales Hub plan. This bug is the very first impression my company has of the HubSpot platform.
You can understand our hesitation. If we are facing an unresolvable bug on a core feature in the free version after spending a full day troubleshooting, how can we be confident that things will be better if we pay money? What happens if we become paying customers and face a similar blocking issue?
With all due respect, the issue is not a simple missed property. It appears to be a bug in the importer's validation. Could you please look at the evidence of the **correctly mapped screen** and advise why the 'Next' button would still be inactive?
@WElsehey for line items, you have mapped SKU, unit price, and quantity - but HubSpot requires "Product" or "Name" on top of that. The green check marks simply label that all available mappings are correct. But that doesn't change that mappings are still missing. In your import file, you need to add at least one additional column for name / product.
If I'm missing the name / product mapping in the screenshot, please point it out to me.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer