To be successfully imported through a CSV file, the column headings for these preferences should be:
- Price Min*
- Price Max*
* The following upper and lower case variations are also accepted: Min Price, Max Price.
If these are not successfully matched during the Verify stage of an upload, you can manually match them.
To be successfully imported through a CSV file, the data for Minimum and/or Maximum price should be written as numbers only, for example: 1250000
It should exclude:
- Text, e.g: One Million
- Commas, e.g: 1,250,000
- Decimal points, e.g: 1250000.50
- Spaces, e.g: 1 250 000
Dollar signs, e.g $1250000 are supported.
If the data in your file is not compatible, you will either see the incompatibility error, and be asked to ignore or correct the column, or the individual data cell will be skipped (e.g: just the Price max preference for the applicable contact/s will be unrecorded, not the contact/preference in entirety).
When both Min and Max values are recorded
Additionally, if both Min and Max values are recorded, the Max must exceed the Min value.
If it does not, both cells will be skipped.
If both Min and Max values are recorded, but there is an error in one, e.g: text is used, only the cell with the error will be skipped, and the valid value will be imported.
You can download details of your skipped cells, correct the formatting in your CSV file and re-upload it to successfully record this data.