Pulling products out of product library on deals created via integration.

[jj12stars]

Hi all,

I have another software company that is being integrated with Hubspot. New orders come into this software (Pressero) and I need it to create new deals in Hubspot, pulling products from our product library (because we have lots of custom fields that I need on the line items in order to sync them into our ERP). They are having a really hard time - line items are being added as custom line items, therefore not pulling in all the custom fields we need.

Here's the message the developer sent: It seems like the underlying issue here is that I cannot get the Product ID value out of Hubspot. That appears to be the value that the line items need to be associated to, but the Hubspot API never returns it.

Any ideas on how to solve this?

Thank you!

[FrancoQ · Accepted solution]

Hey @jj12stars @BérangèreL this is a common issue
If we create the line item without hs_product_id, it becomes a custom line item, which doesn't pull from the product library.

Product IDs are not returned on deal or line item objects by default you need to query the product library separately to retrieve them.

During deal creation (from Pressero),

• First search the product library (via SKU, name, etc.) to find the matching product and get its id.
• Then create a line item using that hs_product_id.
• Finally, associate the line item with the deal.

[jj12stars]

Good morning, all. Thank you for your suggestions! Hubspot must have just done an update to the API (according to the guy working on the integration). I don't know what changed, but it is now working as expected. This is what he told me: The integrations platform had an update this morning with a fix for the Product ID always returning blank from Hubspot.

Thank you all for chiming in. I think I'm good!

[FrancoQ · Accepted solution]

Hey @jj12stars @BérangèreL this is a common issue
If we create the line item without hs_product_id, it becomes a custom line item, which doesn't pull from the product library.

Product IDs are not returned on deal or line item objects by default you need to query the product library separately to retrieve them.

During deal creation (from Pressero),

• First search the product library (via SKU, name, etc.) to find the matching product and get its id.
• Then create a line item using that hs_product_id.
• Finally, associate the line item with the deal.

[jj12stars]

@BérangèreL It seems as though we should be able to look up using a unique identifier other than the product id. Do you know if that is possible?

[RubenBurdin · Accepted solution]

If you have another unique identifier configured as a product property, yes, you can look up products using that property as a unique ID. Otherwise, you need to use the product record ID.

As FrancoQ mentioned before, the process is to first look up the product by ID and then post the line item, while including the product record ID in it. This should be doable easily by your development team, they could even just pull all products into a database table and look up the product record ID there.

You can also use third-party tools if needed, such as n8n.io or similar, using the Pressero API and the HubSpot API.

If you store your data in a database, you could also use our product, stacksync.com, to sync the line items from your database into HubSpot, while also syncing products from HubSpot to the database in the same time.

[BérangèreL]

Hi @jj12stars, thanks for your reply!

I have found for you this integration "Sync ERP data with ERP Bridge" that might help you connect Pressero and HubSpot?

Just to make sure that I understand correctly, you are trying to create a line item via API. Please let me know if that's not the case.

I'd love to put you in touch with our Top Experts: Hi @sylvain_tirreau, @FrancoQ and @RubenBurdin do you have suggestions to help @jj12stars, please?

Have a lovely day and thanks so much in advance for your help!
Bérangère

[BérangèreL]

Hi @jj12stars, I hope that you are well!

Great question, thanks for asking the HubSpot Community!

For information, here is the Products endpoint that might be of interest.

I have found this thread where the solutions from @MD17 and @Phil_Vallender on this post "Get the product ID" might help you find the Product ID in the tool.

But I understand that you'd like to get this data via API, so I'd love to invite our Top Experts to this discussion: Hi @sylvain_tirreau, @zach_threadint and @Anton do you have suggestions to help @jj12stars, please?

Have a wonderful day and thanks so much in advance for your valuable contributions!
Bérangère