Truncating Field Values in NetSuite Connector Setup

When syncing fields in your storefront, you may encounter character limit errors. This can impede the data flow to NetSuite. To address this, you have two primary methods: increasing the character limit of the relevant NetSuite field or truncating the value at the storefront side.

Adjusting NetSuite Field to Increase the Character Limit

If you are working with a custom field, you can increase the character limit by changing the field type to one that allows a higher length. Once modified, ensure to update your NetSuite Connector mappings to align with the new field configuration. Refer to the documentation on Field Type Descriptions for Custom Fields for more information on possible field types and their associated limits.

Truncating the Field Value

To truncate values effectively without modifying the NetSuite setup, you can create a logic mapping within the NetSuite Connector. This approach allows you to trim values directly from the storefront to ensure they do not exceed the character limits set in NetSuite.

Steps to Truncate Field Value in NetSuite Connector:

1. Log in to app.farapp.com.
2. Select the relevant connector and account.
3. Navigate to Mappings > Orders.
4. Click on the Order tab.
5. Find the mapping that is encountering the character limit error, such as the Memo field.
6. In the Mapping Type column, change the dropdown selection to Logic. This action will prompt a change in the Field / Fixed Value column, now displaying Logic Mapping - Click to View/Edit.
7. Click on Logic Mapping - Click to View/Edit.
8. In the Edit Logic Mapping window, set up the following parameters:
   • Value Type: Select Calculate Value.
   • Set Value To:
     • First Dropdown: Select Order Header Value.
     • Second Dropdown: Choose the storefront field you want to extract data from.
     • Third Dropdown: Select Substring to outline how the incoming data should be managed. This will reveal additional fields within the Set Value To options.
     • Fourth Dropdown: Set to Fixed Value.
     • Fifth Field: Enter 0.
     • Sixth Dropdown: Choose Fixed Value.
     • Seventh Field: Enter the maximum allowed length for the corresponding NetSuite field, which can often be referenced in the error message encountered earlier.
9. Click Save Changes.
10. Finally, click Save to finalize the truncating logic.

This process ensures that data synced from your storefront remains compliant with NetSuite’s character constraints, enabling smoother operations and reduced error occurrences.

Key Considerations

• Always check field character limits based on the field type, especially when dealing with non-English characters, which may take up more space than English letters.
• Ensure that any mapping changes are thoroughly tested to confirm that they function correctly without disrupting other integrations.

With proper configuration, truncating field values can significantly enhance the efficiency of data management between your storefront and NetSuite.

Source: This article is based on Oracle's official NetSuite documentation.