Best answer

How to sync Salesforce addresses to NetSuite as a list

Forum|Forum|2 months ago
August 13, 2025
6 replies
32 views

TavDev
Beginner
8 replies

I am trying to sync address info from a Salesforce Account to a NetSuite Customer. The Salesforce addresses (Billing and Shipping) have their own fields on the Account record (see below.) I need to pivot these so they are sent to NetSuite as an address list with two addresses. What would be the best method to solve for this? Looking at Line Itemizer and it takes comma delimited values and outputs a list. Not sure how I would get these into comma delimited values if that’s the best solution.

Thanks

Best answer by Troy Tessalone

@TavDev

Give this a try…

Action: Formatter > Utilities > Line Itemizer

Formatter help: https://zapier.com/apps/formatter/integrations#help

See screenshots for how to configure.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Troy Tessalone
Zapier Orchestrator & Solution Partner
34001 replies
Forum|Forum|2 months ago
August 13, 2025

Hi @TavDev

For us to have more info, post screenshots showing the NetSuite Zap step fields you are trying to configure in EDIT mode so we can see the field types.

NOTE: You can map 1+ dynamic variables in a Zap field.

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

T

TavDev
Author
Beginner
8 replies
Forum|Forum|2 months ago
August 13, 2025

Thanks, @Troy Tessalone.

The NetSuite fields are below. I’ve done basically the same work to create an Order in NS and the Line Itemizer worked great. The difference though is that data was coming in as multiple records and not a single record to be mapped to many. That screenshot is included as well.