Validate prices and convert strings to integers
Make prices valid and convert strings to integers in Data View in Productsup.
Introduction
The Make Valid Price rule box lets you clean up your price data in Data View to meet the requirements of some export channels. For example, you may need to change the price decimal separator from a comma (,
) to a dot (.
) or remove currency symbols or other text.
Certain rule boxes let you make your prices valid for export in bulk.
Apply the Make Valid Price rule box
To make your prices valid:
Go to Data View from the site's main menu.
Choose the needed export channel or the intermediate stage in the drop-down menu on the left.
Select Edit in the attribute's column where you want to apply the rule box.
Select the Add Box drop-down menu.
Search for and select the Make Valid Price rule box.
Select a decimal separator in the Decimal Separator drop-down menu.
Select the default value for the lines that don't contain numbers.
The Make Valid Price rule box result:
Before | After |
---|---|
12,43 | 12.43 |
10,00 EUR | 10.00 |
10 | 10.00 |
INVALID |
In the last case, the column contains text instead of a number. As the default value is Empty Column, the platform replaces 'INVALID' with an empty value.