Make prices valid and convert strings to integers
Make prices valid and convert strings to integers in Productsup.
For export channels, you need to export prices with a dot/period separator, not a comma.
You can use the make valid price box to clean up your prices and convert them to dot-separated, as well as removing any text (such as currency).
Add the make valid price box
Select your decimal separator
Input the default value, should your input not be able to be transformed to a valid price (i.e. because there are no numbers in the input)
Using the settings in the box above, your prices would be transformed in the following manner:
Before | After |
|---|---|
12,43 | 12.43 |
10,00 EUR | 10.00 |
10 | 10.00 |
INVALID |