OpenCart 2.3 - Search orders by phone number
As part of the project, additional functionality was implemented for the OpenCart 2.3 admin panel, which allows for quickly finding orders by the customer's phone number.
The standard functionality of the system is limited to searching by order ID and name, which complicates the work of managers when processing inquiries. Therefore, a convenient solution for searching specifically by phone — one of the most common customer identifiers — was developed.
What was done:
- A search field by phone number was added to the order list in the admin panel
- Processing of the entered number was implemented (support for different formats)
- Changes were made to the controller and model for correct data filtering
- The SQL query was optimized for fast searching even with a large number of orders
- Compatibility with the standard functionality of OpenCart filters was ensured
The standard functionality of the system is limited to searching by order ID and name, which complicates the work of managers when processing inquiries. Therefore, a convenient solution for searching specifically by phone — one of the most common customer identifiers — was developed.
What was done:
- A search field by phone number was added to the order list in the admin panel
- Processing of the entered number was implemented (support for different formats)
- Changes were made to the controller and model for correct data filtering
- The SQL query was optimized for fast searching even with a large number of orders
- Compatibility with the standard functionality of OpenCart filters was ensured
Kyiv 
Available for hire
Offer work