Rules for replacing text when loading products from price lists
Text replacement rules allow you to change the values coming from the price list to the text you need. This is an automated subsystem "Find and Replace". This setting subsystem is used to correct, replace, delete text in incoming values from the price list. The subsystem allows you to bring the names of goods, article and any other data to a single form.
Description of grid fields
- Field
The name of the field to which the substitutions are applied. The field is selected by clicking on the "+" button.
- To find
The text to search for in the specified field. It is possible to search for empty text, to do this, specify the macro substitution {EMPTY} or {EMPTY} in this field.
- Replace.
Replacement text. You can use macro coasters, for example {Price list: Manufacturer}.
- Delete text
When the flag is set, the text specified in the "Find" field will be deleted.
- Case sensitive
When searching for text, be case-sensitive.
- Consider spaces in text
Spaces at the beginning and end will be preserved, for example, find "text1" and replace it with "text1".
- Regular expression used
The search field uses a regular expression.
- Delete Cyrillic
Removing Cyrillic in the text.
- Delete special. symbols
Deleting a special characters in the text (for example Ё!"№;%:?*-+).
- Search by entry
When activated, a content search is performed, not an exact search, a search within a sentence.
- Block start and end text
Allows you to apply replacement for blocks, such as deleting blocks of text specified in brackets. This feature will be useful for creating shorter product names when loading them from the price list. If the end-of-block character is not specified, then the text will be deleted from the start-of-block character.
For example, in the price list there are such names of goods:
- BOSCH HMT 72M420 (Micro oven, Power 800 W, color: white, volume 17 l, mechanical control)
- LG MB-3744US (micro oven)
- LG MH-6327DRS (---) (micro oven)
You can get these names after setting this mode:
- BOSCH HMT 72M420
- LG MB-3744US
- LG MH-6327DRS - Preprocessing Formula
Allows you to set a preliminary text formula before replacing, for example, you can convert all characters to uppercase, for this you need to specify UPPER({field_name}).
- Processing order
How to apply the replacement rule.
- Base directory category
Associate a replacement rule with a category in the base directory.
- Note
A description of how the replacement rule works, such as what purpose it is created for.
- Activity
Activity status (apply or not).
Additional filter
Allows you to set a filter for products from the price list, in order to limit the application of the replacement rule only for certain positions, for example, only to one section.
You can set up global replacement rules for all price lists, to do this, open the menu References / Price list processing / Text replacement rules
Monitoring the prices of competitors on the Internet