Troubleshooting Character Limit Errors in NetSuite

When syncing some fields in your storefront, you may face a character limit error. You can resolve this error using one of the following methods:

• Adjusting NetSuite field to increase the character limit

• Truncating the value

Adjusting NetSuite Field to Increase the Character Limit

If you are mapping to a custom field, change the field type to field with a higher character limit. Then update the NetSuite Connector mappings to point to the new field. For more information about field character limits for different field types, read Field Type Descriptions for Custom Fields.

Truncating the Field Value

In this method, create a logic mapping in NetSuite Connector. This method does not require any changes in NetSuite. This method lets you truncate the values coming from the storefront so that they never exceed the field lengths determined by NetSuite.

To truncate the field value in NetSuite Connector:

1. Log in to app.farapp.com.

2. Select the connector and then select the relevant account.

3. Go to Mappings > Orders.

4. Click the Order tab.

5. Locate the mapping that is running into character limit error. For example, the Memo field.

6. From the dropdown list in the Mapping Type column for the mapping, select Logic.

   The field in the <Marketplace or cart> Field / Fixed Value column changes to Logic Mapping – Click to View/Edit.

7. Click Logic Mapping – Click to View/Edit.

8. Make the following settings in the Edit Logic Mapping window:

   1. From the Value Type field, select Calculate Value.

   2. From the first dropdown list in the Set Value To field, select Order Header Value.

   3. From the second dropdown list, select the storefront field from which you want to pull data.

   4. From the third dropdown list, select Substring.

      Substring is the mapping rule that tells NetSuite Connector what to do with the data that is coming from the storefront. This selection, adds four more fields to the Set Value To field.

   5. From the fourth dropdown list, select Fixed Value.

   6. In the fifth field, enter 0.

   7. From the sixth dropdown list, select Fixed Value.

   8. In the seventh field, enter the maximum field length from the field in NetSuite.

      If you do not know the length, check the error message for this error.

9. Click Save Changes.

10. Click Save.

Related Topics

Troubleshooting Common NetSuite Issues in NetSuite Connector

Troubleshooting Common NetSuite Configuration Issues

General Notices