...
With these changes, the search by phone will return a list of customers instead of a single one and avoid the problem of manual record deletion that solution 1 requires. However, the support tool front end will have to be adapted so that customer support can choose which one they want to check given the list of customers associated with that phone number.
The front end design will have to be aligned with UI/UX team.
Pros and cons
Pros
Search will work with both phone numbers included in the order or in the user account
Doesn’t require phone verification
Doesn’t require migration scripts, the search will work as long as the user has made one order after the feature release
Allows the association of multiple phone numbers with multiple customers
...
and was able to find the two customers when searching for the phone number +123123123:
...
Task breakdown
[intl-user-service]
Update the lookup record structure to enable associating multiple phones and users
Develop create lookup records endpoint
Develop find by phone endpoint
[intl-packages]
Develop a method in intl-users that creates lookup records in via the new user endpoint
Update the searchByPhone method to use the new User endpoint
[intl-admin-app]
Update customer query to also search by phone
Develop customer selection page
Update universal search to include search by phone, and redirect the user to the customer selection page if more the one customer is found