How to Truncate or Add a Suffix to Field Values During Import

The TRUNCATE formula type allows you to shorten text fields to a specific number of characters during import. You can also use the SUFFIX formula type to replace or customize the ending symbol (for example, change the default "..." to something else).

1. Creating a Truncate Formula

To set up text truncation, go to the Custom Fields tab in Step 2 of the import setup and create a new custom field.

In this example, we’ll truncate the product Description field.

• Field name: description_truncate
• Condition: Any
• Formula type: Truncate

Now select the field you want to shorten (in this case, [Description]) and specify the number of characters to keep. For example, TRUNCATE TO 10 will keep only the first 10 characters of the description:

2. Assign the Custom Field for Import

Next, navigate to the Information tab and select the new custom field (description_truncate) for the “Product Description” option:

3. Customize the Ending Using SUFFIX

If you want to replace the default ending symbol, use the SUFFIX formula type. For example, replace “...” with “!!!” as shown below:

After import, your field will look like this:

This feature is especially useful for keeping product descriptions concise or adding a custom marker at the end of a truncated field.