Order search by phone returns all orders

  • Resolved miroruse

    (@miroruse)


    10 months ago

    Hi, since updating the woocommerce plugin to ver. 8.5.1 in a few absolutely different websites (theme & plugins) an interesting problem came out.

    When a sale managers searches orders entering client’s phone number and the email address is the same (the sale manager takes order via calls and enters his e-mail address as client’s) the result is the list of all orders associated with shop manager’s e-mail address irrespective of the phone number searched.

    For example, I’m a shop manager and my e-mail is [email protected]. I have processed 5000 orders in the website using [email protected], but entering the respective client’s phone number. If I search the phone number of a client, the result is 5000 orders which all share the same e-mail.

    Before the update, the result returned only orders containing the required phone number (irrespective of the e-mail used).

    After the update, it is much harder to find anything by phone number only, as obviously the e-mail is taken into consideration, not the phone number.

    Tricky stuff. Any thoughts?

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello miroruse,

    Thank you for contacting WooCommerce support.

    I see that you’ve run into an issue with the search functionality for orders post updating to WooCommerce version 8.5.1.

    Specifically, when you search for orders using the client’s phone number while the email address associated with those orders is the same as the shop manager’s, the results unexpectedly display all orders tied to the shop manager’s email instead of filtering by the phone number.

    This is certainly an unusual problem. To help you more effectively and try to replicate the issue on my end, I will need a bit more information:

    1. Could you please provide a screenshot of the page where you enter the phone number to search along with a screenshot of the search results you get? This will offer a clearer view of the problem. You can upload the images to?https://snipboard.io/?and share the links with us here.

    2. Additionally, to provide accurate assistance, please send me a copy of your site’s System Status Report. You can find this report by following these steps:
    ???– Navigate to WooCommerce > Status in your WordPress dashboard.
    ???– Click on ‘Get system report’.
    ???– Then click on ‘Copy for support’ to copy the report.
    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    Once I have this information, we will be better equipped to understand what’s happening and find the right solution for you. ??

    Best regards.

    Thread Starter miroruse

    (@miroruse)

    Hi Zubair Zahid,

    The screenshot is available here

    The report here

    You got me right. It seems to me that somehow the email and the phone number are going together now, not like separate fields.

    Miro

    • This reply was modified 10 months ago by miroruse.

    Hey, @miroruse!

    Thank you for the screenshot and the report.

    Just to confirm if we understood correctly, this issue is happening on multiple sites, is that correct? Or only on https://fashionchoice.bg?

    If it is on multiple sites, do you have any plugins (besides Woo Core) that are active on all sites with the issue?

    The reason I’m asking is that it is possible another plugin is causing this conflict.

    It would be good to do a conflict test to confirm this and, if it is this, find which plugin is doing this.

    To test, you’ll first want to change the theme on your site to Storefront, then check to see if the issue is still present. If that resolves the issue, you’ll want to get in touch with your theme’s developer and see if they have an update or fix for you.

    If changing the theme doesn’t help, you’ll want to deactivate all plugins except for WooCommerce and take a look. If that fixes the problem, re-enable the other plugins one by one (gradually), checking after each, to see where the issue is coming from.

    — Be sure you have a good backup in place of your full site and database. You can ask your host for backup functionality or you can consider using a service like Jetpack. If something goes wrong, you will be able to restore it.

    — Also, you can consider using a plugin like Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it is helpful to disable plugins without affecting your current site visitors.

    — It is important to consider as well a staging functionality in case you would not like to touch your production site (you can ask your host if they offer this service), or you can use WP Staging for quickly spinning up a new test site.

    You can find more about this in this guide.

    Please let us know about your findings.

    Looking forward to your reply.

    Have a wonderful day!

    Thread Starter miroruse

    (@miroruse)

    Hey, thanks for the reply. It happens to a total of 5 website, where 3+2 are idential. They are totally different in themes and plugins.

    Anyway, I did a duplicator copy of one of the websites (excl. the wp-uploads), deactivated all plugins but woocommerce, changed the theme to Storefront and the problem persists.

    As I have already messaged you, there wasn’t such a problem in the previous verision.

    To make things “worse” now all of a sudden the search is working correctly on all websites. Why? I have no idea. It wasn’t working during my previous tests and I did nothing. The shop assistant told me that sometimes the search is working and sometimes not. I will keep you informed.

    Thread Starter miroruse

    (@miroruse)

    Well, I checked again and I figured out that new orders from that last up to 16 hours ago experience that problem. No problem with older orders. The order status is not important.

    anastas10s

    (@anastas10s)

    Hi there @miroruse ??

    Thank you for reaching back, with further details on this.

    I checked again and I figured out that new orders from that last up to 16 hours ago experience that problem. No problem with older orders. The order status is not important.

    I went ahead with testing this, with a test installation having only WooCommerce version 8.5.1 installed, after creating two orders with same customer data, except the phone. It all worked as expected, and the orders were filtered based on the phone number.

    Moving forward, as the site already has over 120k orders, I’d recommend looking into CRM solutions like Jetpack CRM. That would enable taking things further.

    I hope this is helpful! Please let us know if you have any further questions or concerns.
    We will be happy to help you further.

    Thread Starter miroruse

    (@miroruse)

    Thank you for the advice. I’m closing the topic.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Order search by phone returns all orders’ is closed to new replies.