Macro Editor allows you to export different values for different groups of products based on specific rules. Here are some basic examples of how to use the Macro editor.
Attribute merge
You can merge any selected attributes and strings. For example, optimization of URL for better SEO.
Example 1:
Use multiple attributes as input to the macro:
'Vendor' - attribute value 'ADIDAS'
'Size' - attribute value 'L'
'Price final include tax' - attribute value '55'
'Store currency' - attribute value 'EUR'
Define the following operations:
'remove empty elements'
'convert collection into text'
join with set to ' - '
As a result, you get the following:
ADIDAS - L - 55.00 - EUR
Example 2:
Use multiple attributes as input to the macro:
'Vendor' - attribute value 'ADIDAS'
'Size' - attribute value 'L'
Add text - ' - only - '
'Price final include tax' - attribute value '55'
'Store currency' - attribute value 'EUR'
Define the following operations:
'remove empty elements'
'convert collection into text'
join with set to ' - '
'append sufix'
'remove empty elements'
'convert collection into text'
join with set to ' - '
As a result, you get the following:
ADIDAS - L - only - 55.00 - EUR
For more details, please check the following:
Increase Price by 20 %
You can increase the price by a specific percentage. There is a predefined macro available.
Required result: Increase the final price by 20 % for all products.
For more details, please check the following:
Increase price by 25
You can increase the price by a specific amount.
Required result: Increase the final price by 25 for all products.
For more details, please check the following:
Using Rules
You can apply different rules for different groups of products. For example, increase the final price by 20% if the final price is less than 100.
Rule #1: Increase the final price by 20% for products below 100
Rule #2: Export the final price for the rest of the products
Using Multiple Rules
You can apply different rules for different groups of products.
Rule #1: Increase the final price by 25 % for products below the final price of 20
Rule #2: Increase the final price by 15 % for products above the final price of 20 and below 40
Rule #3: Export the final price for the rest of the products
Return the first non-empty value
You can check several attribute values and export the first non-empty value to the profile. Select TAKE MULTILE. List all attributes you'd like to check - e.g. 'Description', 'Category description', and 'Tags'.
Set operation to 'first non-empty item'.
For more details, please check the following:
Return value after first TRUE condition
You can check several conditions and export a value for the first 'true' condition.
Rule #1: For the product SKU values that contain 'AD', return the final price increased by 20 %
Rule #2: For the product SKU values that contain 'CD', return the final price increased by 10 %
Rule #3: Export the final price for the rest of the products
Set up capital letters in the title
You can set each letter in the Title value to be a capital letter easily
For more details, please check the following:
Fix EAN code value
The EAN code value should be a 13-digit number. You can add a '0' at the beginning of the EAN code if it is removed during the import.
Convert price and round up
You can convert the price to different currencies and round it up to the whole number.
For more details, please check the following: