Hello SC, I'm super new to Square. We are using Square for my kids' school's Booster Club concession sales. We just had a big conference track event this past weekend and used Square for the first time. In addition to credit cards, we also accepted cash and school account billings. I imported student data (only first and last names, unique student ID, grade) into the directory so that we could capture student info for those transactions. Now after the event, I'm exporting the transactions csv and realize that I should've imported the "unique student ID" into the "reference ID" field because that is the only other field in the transaction csv (other than name) pulled from the customer profile. I had the student ID imported into the Company field.
I need to update all the customer profiles so that the reference ID field is populated with the student ID. I tried importing a new file (with just 1 customer) and it just created a duplicate profile. I read that the system will only flag duplicates with the same email address or phone number. I don't have that information. How do I do this in bulk without creating duplicate profiles?
I also manually merged the duplicate profiles for that 1 customer mentioned above and it did merged them, but since the "reference ID" field was already populated with the student's grade, the student ID could not be merged.
Thank you in advance!!
