topic Re: Cannot create mapping to Status field in Netsuite in Data Hub

Cannot create mapping to Status field in Netsuite

davidho — Wed, 09 Aug 2023 08:46:53 GMT

Hello,

I would like to create a mapping between the Lifecycle Stage field in Hubspot and the Status field in Netsuite for my companies, but the Status field doesn't show up in the list when I try to create a mapping. Does anyone have any experience with this?

Re: Cannot create mapping to Status field in Netsuite

BérangèreL — Thu, 10 Aug 2023 07:20:20 GMT

Hi @davidho,

Thank you for reaching out to the Community!

I understand that you are using this integration "NetSuite", right?

Let's see if we can get some of our community members to share their experiences.

Hi @PSatterly, @DinithiAbeysiri and @BrightCap, do you have any insights on this to help @davidho, please?

Thank you and have a great day!

Best,
Bérangère

Re: Cannot create mapping to Status field in Netsuite

BrightCap — Thu, 10 Aug 2023 11:19:52 GMT

I would create a custom field in NetSuite, map it to that, and update the status from that field via a workflow in NetSuite.

Re: Cannot create mapping to Status field in Netsuite

PSatterly — Thu, 10 Aug 2023 12:39:32 GMT

Hello! Yes, we use this integration, and I found a workaround for the Lifecycle stage! It's a bit complicated, but it does work.

So first, I edited all of the Lifecycle statuses in Hubspot to match the same names we use in Netsuite. (Ex. PROSPECT-Qualified Prospect and so on). You can edit the names of the Lifecycle stages in Hubspot, adding however many that are needed.

Next, I created a custom single-line text mapping from the Lifecycle stage in Netsuite to Hubspot and named it "LS Stage (NS)". We only use this on the Company (Customer in NS), so I only mapped on the Company sync.

I then created a Company based workflow for each Lifecycle Stage to map the single-line text to the radio select in Hubspot. Here are the different workflows mapping each of the Lifecycle statuses:

Here is a breakdown of one of the workflows. I basically created one workflow and then copied the rest, updating to the next status:

The thing to note is that we use this on the Company (Customer) level only in Netsuite. So for us, we rely on the native setting "Copy Lifecycle status to Customer" to update the contacts based on the customer stage. This only works in one direction, so if you ever change your customers from the stage Customer back to a Prospect at any point in Netsuite, you will have to create a reverse workflow to change it back in Hubspot. It wasn't a difficult workflow to set up, but since it is something we frequently do, it was necessary for us.

Happy to answer any other questions you may have! This took a lot of troubleshooting to get here, but it does work perfectly for us now.

Re: Cannot create mapping to Status field in Netsuite

davidho — Mon, 21 Aug 2023 12:45:52 GMT

Thank you for the detailed answer, but in our company Hubspot is the source of truth, so therefore the lifecycle stage should migrate from Hubspot to Netsuite, not the other way around.

Re: Cannot create mapping to Status field in Netsuite

WinnieHien — Tue, 26 Sep 2023 15:58:45 GMT

Hi David, we now support NetSuite Status in the integration for the Contact (Individual Customer) sync and Company (Company Customer) sync.

This is brand new as of this month!

Here's a 5 minute loom on how to set-up NetSuite Status sync in HubSpot.

Re: Cannot create mapping to Status field in Netsuite

CDumontBois — Mon, 15 Jan 2024 22:00:29 GMT

Hi Winnie!

Can you confirm that I need the Operations Hub Starter plan in order to access custom fields?

Re: Cannot create mapping to Status field in Netsuite

WinnieHien — Fri, 19 Jan 2024 20:12:59 GMT

Hi. Great question.

Yes, Operations Hub Starter is required for custom fields.

Now, let's define what custom vs default fields mean for Data Sync apps (i.e. NetSuite).

Default fields in NetSuite are fields such as first name, last name, and email.

It has a specific definition:

It must be a default field in NetSuite
It must be a default field in HubSpot
It must be consistently mapped, with little room for debate.

Fields that fit this for example on the contact record are first name, last name, and email. There maybe a handful more. These are available for free with Operations Hub Free.

Custom field mappings are everything else.

Take the HubSpot lifecycle stage field - that's default in HubSpot, but you could map it to NetSuite Status (default) or to a custom NetSuite Lifecycle stage field. Because there's an element of user choice in this, we wouldn't consider it default and you'd need to upgrade to Operations Hub Starter to have access.

Clarification point - Dropdown select, radio buttons, and checkboxes are not considered "custom field mappings". These mappings are a type of field mapping. We’re still working hard on adding support for all dropdown fields.

Recommendation: Check the fields you need are available before you upgrade to Operations Hub Starter+. You can create a developer test account that gives you access to the full tiers for testing. An alternative chatting with your sales rep about trialing Operations Hub Starter before you commit.

Hope that helps! I can give general guidance, but a question like “does X field map in the integration” is best done by trying it out. The install flow is pretty quick!

Re: Cannot create mapping to Status field in Netsuite

CDumontBois — Fri, 19 Jan 2024 21:31:03 GMT

Thanks this is super helpful!

Re: Cannot create mapping to Status field in Netsuite

PMcConnell0 — Thu, 06 Mar 2025 02:57:55 GMT

Hi Winnie,
Is there a way to sync to a Netsuite Lead Source? We have marketing lead source in Netsuite and I have tried everything and can't seem to get it to sync. We have created a custom field in Netsuite (which has worked in other sync's) but this one won't allow it. I have make sure naming conventions and fields are the same but no luck.

Re: Cannot create mapping to Status field in Netsuite

WinnieHien — Thu, 06 Mar 2025 21:40:58 GMT

Hi there,

I'm no longer the PM of the NetSuite integration so I'm not sure of the updates that might have happenned in the last 1.5 years.

@FransLeys, might know the answer to that or you could try writing into HubSpot support and asking them to dig into what product updates have come out lately for the Data Sync feature around syncing dropdown select fields.

Wishing you luck!

Winnie

Re: Cannot create mapping to Status field in Netsuite

FransLeys — Mon, 10 Mar 2025 19:29:40 GMT

@PMcConnell0 You'll want to write into support so they (or the product experts that that customer support can reach out to) can take a deeper look at your exact Netsuite instance to see how those fields are behaving...