Increase Character Limit for NetSuite Fields Adjustment

When syncing fields in your storefront, character limit errors may occur. This article outlines methods to resolve these errors by adjusting NetSuite fields or truncating data.

How Do You Adjust NetSuite Field Character Limits?

If you're encountering character limits, you can adjust your NetSuite field to accommodate a larger number of characters. To do this:

1. Change the Field Type: If you are mapping a custom field, you may need to change its type to one that supports a higher character limit.
2. Update Mappings: After adjusting the field type, ensure you update the NetSuite Connector mappings to utilize the freshly configured field. For insight on field character limits based on different field types, refer to the section titled Field Type Descriptions for Custom Fields.

How to Truncate Field Values?

An alternative approach to handling character limit issues is truncating the values before they reach NetSuite. This method does not require modifications within NetSuite itself and can be implemented via the NetSuite Connector:

Steps to Truncate Field Values:

1. Log in to app.farapp.com.
2. Select the connector for the relevant account.
3. Navigate to Mappings > Orders.
4. Click on the Order tab.
5. Identify the mapping that triggers the character limit error, such as the Memo field.
6. Change the Mapping Type to Logic from the dropdown menu.
7. Click on Logic Mapping - Click to View/Edit.
8. In the Edit Logic Mapping window:
   • Set Value Type to Calculate Value.
   • In the first dropdown of Set Value To, select Order Header Value.
   • Choose the appropriate storefront field in the second dropdown.
   • From the third dropdown, select Substring to manage how data is pulled from the storefront.
   • Choose Fixed Value in the fourth dropdown, and enter 0 in the next field.
   • Again, choose Fixed Value in the sixth dropdown, then input the maximum allowed field length based on your NetSuite configuration. You can usually find this information in the corresponding error message.
9. Click Save Changes and then select Save.

Key Takeaways:

• Adjusting NetSuite fields can help resolve character limit issues when syncing data.
• Changes in the field type may significantly influence the character limits.
• Truncating values through the NetSuite Connector provides a workaround without direct modifications in NetSuite.

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