Applies to Product - Dynamics 365 Commerce
What’s happening?
Searching for a customer by name does not return all customers with that name in the POS system.
Reason:
This is related to the SQL-based search functionality, which is an older feature that is not designed to handle all customer records effectively. The search mechanism limits the results to a certain number of top records, and if the customer's address book does not match the store's customer address book, they will not appear in the search results.
Resolution:
- It is recommended to leverage Azure Search for better results.
- Input more characters in the search query, such as both first name and last name, to increase the likelihood of finding the desired customer.
- Use the default search option, keeping in mind that performance may be slower depending on the number of customers in the database.
- If the search results do not contain the desired customers, provide more specific search keywords instead of increasing the maximum number of records returned, as this may affect performance.