Weekly we receive sales updates from our supplier through an .csv file. It contains deals, contacts and line items. We have managed to import the combination Deal + Contact, but meet issues when we also add import of the line item. All information is in one spreadsheet, with columns. One line per deal.
The issue is related to Product ID vs Records ID. We have Products in HubSpot, and I have done an export to received Product ID. To my surprise the export does not provide a Product ID, but a Record ID.
In this video from HubSpot, it seems to me as they have exported Product ID, but I can not do this as you see: (5) Post | LinkedIn
This is actually not the issue - I beleive. What is the issue is when I map the metadata in the import. Here are some pictures which describes the issue. As far as I can see, the exported Record ID (picture above) has a match in the pictures below. But it does not seems HS will recognize this.
I do understand this is because HS requires the Record ID as a uniqe indicator, but I do not understand why it does not match the number I have exported from HS an added to the spreadsheet I try to import.
It looks like the issue is with how HubSpot is recognizing the IDs in your import. Here’s what might be going on:
HubSpot often uses Record IDs internally instead of Product IDs. Make sure that in your import sheet, you’re mapping to Record ID if that’s what HubSpot is expecting.
Double-check the column mapping during the import. When you get to the step that asks to map your columns, ensure that the Product IDs in your CSV are being matched to HubSpot’s Record ID field, not to the Product ID field.
If you’ve already exported the Record IDs from HubSpot, make sure the values in your import file match exactly (no extra spaces or changes). Even a small difference can cause a mismatch.
If it’s still not working, try doing a test import with just a few rows and the Record IDs to see if that goes through.
The issue you’re facing with importing line items into HubSpot stems from the confusion between the Product ID and Record ID. When you export products from HubSpot, what you receive is the Record ID, not the Product ID, and this distinction is important during the import process.
To fix this, you need to use the Record ID when importing line items. HubSpot expects the Record ID, not the Product ID, to correctly map your data. So, when you’re mapping columns from your CSV file during the import, make sure to assign the Record ID column to the product field in HubSpot.
Additionally, check that the Record ID from your exported product list matches the corresponding column in your CSV file. If HubSpot doesn’t recognize the Product ID, it’s because it’s expecting the Record ID to correctly link the line items.
