Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Table of Contents

Open questions

Business Questions

  1. Is there a business rule that demands that only verified phone numbers can be used in customer search?

Business Answers

Tech Questions

  1. Why do two different Interfaces for lookupByPhone records exist? (one in user-service and another in intl-packages)

  2. Does accessing user-service phone lookup records from intl-packages violate the current architecture?

Tech Answers

  1. This is legacy from US, and neither of them are used today, since sign up via phone is disabled in international.

  2. Yes, we should create a new endpoint in user-service to search by phone number.

Business problem

This feature aims to implement the option to search for customers by phone in RBI Admin tool. This was a business request from Iberia (

Jira Legacy
serverSystem JIRA
serverId255417eb-03fa-3e2f-a6ba-05d325fec50d
keyIREQ-961
), given that customer support doesn’t always have the user’s email when trying to find them.

Tech Discovery

Architecture AS-IS

Today, Admin Tool only has the option to search customers by email or Cognito ID. The search by email is exemplified by the following sequence diagram.

The most direct solution is using intl-packages, which already exposes a method to search users by phone number and DynamoDB queries for userLookupByPhone records associating phone numbers to Cognito IDs. However, there is a divergence between the records created using intl-packages and the ones created by user-service, as can be seen below:

intl-packages:

Code Block
languagejs
{
  pk: phoneNumber,
  pk2: cognitoId,
  sk: current/user-lookup-by-phone
  sk2: current/user-lookup-by-phone/{date} 
}

user-service:

Code Block
languagejs
{
  pk: phone#${phoneNumber},
  pk2: phone_user#${cognitoId},
  sk: v0_UserPhone,
  sk2: v0_UserPhoneUserPhoneLookUp,
}

The user-service record is created when a user verifies their phone number via SMS. As far as we can tell, no one is using intl-packages lookup records since its only reference is its own test.

Note

Orders made using Call Center won’t appear in the customer history, since they are registered under the Call Center operator account.

Proposed solution n. 1

Add the option in intl-packagesto search users by phone number, and change user-service API to create/update lookupByPhoneNumber records whenever there are changes in the customer's phone number. We could take advantage from the development done for SA market in

Jira Legacy
serverSystem JIRA
serverId255417eb-03fa-3e2f-a6ba-05d325fec50d
keyIPN-31
.

However, this would still require existing customer to update their phone number for the search to work. This problem could be solved if we automatically update the user’s phone number with purchases. This can be done every time or only if they haven’t registered a phone.

Info

PROS: The operator of the Admin tool can search by phone.

Note

CONS:

  • There will be a phone number that is not officially validated and it can generate cases where the operator will input a phone number that is not the one expected from the user,

making the search not valid
  • because there is the possibility of multiple users with the same phone existing .

  • Require an script for legacy data migration to update user phone number in case it is mandatory for the search by phone of older users to work.

  • Only one customer can be associated to a phone number. If the user tries to order using an already registered number, an error will appear on the screen.

Rule on when and how to save the phone number need to be defined

Proposed solution n. 2

[Preferred]

Using the Call Center solution to search orders by delivery phone. The search will return a list of orders using the given phone number, and they might come from multiple customer. One solution is to present this list of customers for the support team to decide which one they want to use.

image-20240116-132956.png

This solution has the added bonus that if a phone number is associated to several phone number, that is probably a possible sign of a problem or even fraud.

Info

PROS: The operator of the Admin tool can see all customers associated with a phone number.

Note

CONS:

  • The search

will is slower, and causes
  • might be slower.

  • Causes more friction from the user point of view.

  • Search will only work for delivery orders.

  • The phone number might no be verified.