Skip to main content

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 comma (,) to 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:

  1. Go to Data View from the site's main menu.

  2. Choose the needed export channel or the intermediate stage in the drop-down menu on the left.

  3. Select Edit in the attribute's column where you want to apply the rule box.

  4. Select the Add Box drop-down menu.

  5. Search for and select the Make Valid Price rule box.

  6. Select a decimal separator in the Decimal Separator drop-down menu.

  7. Select the default value for the lines that don't contain numbers.

    Make Valid Price rule box

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.