Articles in this section

Sync customer's email address with special characters from Shopify to NetSuite

Issue:

The email addresses with special characters are not synced to NetSuite successfully. 

Shopify validates emails based on:

  • A valid form with an @ symbol and a domain
  • A valid, active domain.

So other than this, what the Shopify order provides in JSON must be checked for special characters cause it might interfere when you sync the data to NetSuite.

On the other side, NetSuite accepts email addresses without quotation marks, commas, colons, spaces, or greater than or less than signs. 

Resolution:

Add curly brackets on the email field from field mappings could fix the problem. 

  1. Log in to your integrator.io account.
  2. Click Shopify - NetSuite integration app.
  3. Go to Flows > Order section.
  4. Next to Shopify customer to NetSuite customer (add or update) flow, click Mappings.
  5. Look for the email field and add { } like the image below
    email.png
  6. Click Save & close.
Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
Date Votes
  • Will this work on other fields also? Like Shipping fields? 

    0

Please sign in to leave a comment.