Importing line items

Smart CRM & Sales Hub Tips, Tricks & Best Practices
, ,
1

Hi! I know a lot of people here have this issue, but it seems that every one has a different solution for his specific case.
When I try to import Deals and Line Items using the products in my library, Hubspot says that it doesn’t find the line items ID Record, but I use the same ID Record as my products.

Since there are no other kind of ID records and the Products ID that I’m using are correct, how should I solve this? Do I need a workaround o I’m just skipping some steps? Thanks

2

Hello @ACreti
From what I’ve learned inside ports, the blocker is that a Product and a Line Item are two different objects:

  • Product ID → lives in the Product Library (static catalogue).
  • Line Item ID → is created each time that product is added to a deal, quote, etc.

So when you import deals + line items you have to hand HubSpot:

  1. Which deal this line item belongs to → Deal Record ID
  2. Which product it should reference → Product ID (or SKU)
  3. Leave the Line Item Record ID column blank if you’re creating new line items. Only populate it if you’re updating an existing line item that already lives on the deal. HubSpot will generate fresh IDs during the import.
  4. Map every required pricing column (Quantity, Price, Term, Billing Frequency…). A missing term or unmatched enum will also throw the “ID not found” error—common gotcha. community.hubspot.com

Step-by-step that usually works

• Export your products first (Settings › Objects › Products › Export) so you can copy the correct Product IDs into the CSV.

• Download HubSpot’s sample “Deals and new line items” file; use its exact headers. It shows the one-file method (one row per deal/line-item) if you only need a single line item per deal. For multiple line items per deal, follow the two-file method. knowledge.hubspot.com

• In the import wizard choose “Multiple objects” » Deals & Line Items. Point to your file(s), make sure Deal Record ID → Deal ID and Product ID → Product ID map green. Record ID (Line Item) should say “Will create new.”

• After upload, HubSpot creates a fresh Line Item record for every row, ties it to the deal, and links it back to the product. If you need to tweak them later, export the deals again to grab the new Line Item Record IDs, edit offline, then re-import with those IDs filled. Full object-update rules live in the import KB. knowledge.hubspot.com

Hope that helps.

3

Hi, thanks! I notify to you that it doesn’t accept Product ID. If I ignore it and use the other Product properties, it takes the line items correctly.
Now, it creates a deal for every line even if they’re the same deals, so I’m gonna try import the deals first and the line items later, using the Deals ID

4

Hello @ACreti ,

When importing line items into HubSpot, remember that Products and Line Items are different things. Products come from your product library and have a Product Record ID. Line Items are the actual entries attached to deals and get their own IDs once created.

The key: When importing line items, use the Product Record ID in the “Product” field, not a Line Item ID (which doesn’t exist yet). HubSpot will create the Line Item IDs during import.

Also, if you’re using a “Term” field, format it like this: P12M (for 12 months), not just “12” or “12 months.”

Make sure to map your fields correctly and select “Create and update line items” during import. This will fix the “ID not found” error and get your deals and line items imported smoothly.

Check the similar Line Item Import Issues thread in the HubSpot Community –
https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Import-of-Line-Items-Issue/m-p/892667

https://community.hubspot.com/t5/CRM/Issue-when-importing-Deals-Line-Items-and-Contacts/m-p/1046840

https://community.hubspot.com/t5/CRM/Importing-Line-Items-to-Existing-Deals/m-p/1003030

https://community.hubspot.com/t5/CRM/Use-existing-Product-Library-for-Line-Item-Import-on-Deals/td-p/1084736

https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Import-of-Line-Items-Issue/m-p/892667

Hope this helps.

5

Hi, thanks! I notify to you that it doesn’t accept Product ID. If I ignore it and use the other Product properties, it takes the line items correctly.

6

Hi @ACreti

You’re trying to import Line Items using Product IDs (from your Product Library), but HubSpot is asking for Line Item IDs, which are created only after a Line Item is associated with a deal.

So: Product ID → identifies a Product in your Product Library.

Line Item ID → is not the Product ID; it’s a separate ID generated by HubSpot when you create a Line Item (usually via UI or API).

If you’re importing Deals with Line Items, here’s the step-by-step method that works:

Step 1: Import Deals first

  • Import your Deals using a CSV file.
  • Make sure each Deal has a unique Deal ID (or assign one yourself using an “External ID”).
  • HubSpot will return internal Deal IDs after the import.

Step 2: Import Line Items and associate with Deals

  • Prepare a second CSV with Line Items using these columns:
  1. Line Item Name
  2. Quantity
  3. Price (or Unit Price)
  4. Product ID (from Product Library not Line Item ID)

  • Deal ID (from Step 1)

  • Import this into Line Items and associate with Deals during the import.

  • In the HubSpot import flow, select:

  1. Import → Multiple objects
  2. Select Deals + Line Items
  3. In the mapping step, map your Product IDs to the Product ID field, not Line Item ID.

Important: You must associate Line Items with Deals at import you cannot link them afterward through a single import.

7

Hi, thanks!
I marked it as a solution in case someone else need this, but I add that Hubspot doesn’t include Products in this kind of import:

Immagine.png
Immagine.png1296×533 87.2 KB