Custom Fields Formula  Type Features

Using Custom Fields feature you can create custom fields with specific values.

We added a new feature Formula Type. Using this feature you can create a field with the value that can include:

• Simple string
• Mathematical formula
• Search and replace some text in your field during import

String type means that your custom field will have value like it is. It can be some additional fields with static data that you need to import.

Mathematical formula means that you can process some mathematical calculations.

For example, you need to import product prices from your file and increase the price of 20% in your store.

For this, you need to create your custom field price with such formula: 

In our case, the field "Pre-tax retail price" is a field with a price in our file.

Find & Replace type means that you need to find some text in the import field and replace it on another text.

For example, we need to field in the field "Product name" text "Green" and replace it to "Red".

Find & Replace formula has such structure: [your_field_name] => TEXT_FOR_SEARCH => TEXT_FOR_REPLACE

So in our example formula will be so: