Hello all,
- A user did a CSV import and uploaded incorrect data into customer records. Namely into the Group Pricing sub-list.
- CSV advanced options had LOG SYSTEM NOTES FOR CUSTOM FIELDS checked, but i assume as this is a standard NS field this did not apply?
- They had made a backup of the original data, but the backup was made using the same incorrect assumptions and is useless.
- I created a search to check for old values using the below criteria.
- System notes>context = CSV
- System notes>Date = this month to date
- Search results did not show the Group pricing level old or new value
- . Can you think of something else?
What we need, illustrative example:
+----------------------+----------------+---------------------+
| Customer Internal ID | Pricing Group | Group Pricing Level |
+----------------------+----------------+---------------------+
| 123456 | SunStone | less 62% |
| 123457 | Hydronic Range | less 55% |
| 123457 | SunStone | less 55% |
+----------------------+----------------+---------------------+
Thanks for reading
