There seems to be a bug in your latest update.
The ‘Search Orders’ in Woocommerce > Orders stops working with the latest update, i.e. the search returns nothing regardless of whether an order ID, customer email address, or customer name is used.
As I switch back to version 8.1.6, the ‘Search Orders’ functionality is working fine again.
Please check your update version(s).
I confirm this bug, I can’t search customers anymore in Japanese language (used to work), now it only works if a customer has a western name,
Prior to upgrading a client site to woocommerce 3.0, SEARCH ORDERS worked wile SEARCH EVERYTHING active. AFTER upgrade search orders went to hell. Not only did it return ZERO results, it actually was generating a mySQL query error similar to…
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘))) AND ( ( wp_postmeta.meta_key = ‘_customer_user’ AND wp_postmeta.meta_val’ at line 1]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ((())) AND ( ( wp_postmeta.meta_key = ‘_customer_user’ AND wp_postmeta.meta_value = ‘4’ ) ) AND wp_posts.post_type = ‘shop_order’ AND ((wp_posts.post_status = ‘wc-pending’ OR wp_posts.post_status = ‘wc-processing’ OR wp_posts.post_status = ‘wc-on-hold’ OR wp_posts.post_status = ‘wc-completed’ OR wp_posts.post_status = ‘wc-cancelled’ OR wp_posts.post_status = ‘wc-refunded’ OR wp_posts.post_status = ‘wc-failed’ OR wp_posts.post_status = ‘wc-credit-release’ OR wp_posts.post_status = ‘wc-credit-hold’ OR wp_posts.post_status = ‘wc-export-error’ OR wp_posts.post_status = ‘wc-shipping’ OR wp_posts.post_status = ‘wc-back-order’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20
Painstakingly, we de-activated/re-activated every plugin individually and SEARCH EVERYTHING v8.1.9 appears to be creating the conflict in the woo v3.0.1 search order function, (config: WP v 4.6.4, php v5.6.30 and mysql v5.6.35).
Just to add to this, the Customers filter on the WC orders page breaks, but works if you click ‘Filter’ again.
This is the URL you get the first time you filter by customer:
Then, if I click the Filter button again, it changes to this and works:
Seems to be the ‘s’ GET parameter which breaks it, as removing it from the URL fixes the issue. Might help you figure out what’s blowing stuff up.
This is also happening in our site. We’ve disabled the plugin until it’s resolved.
I just wanted to provide a quick update on the plugin issues above.
Our Engineering team is currently in the process of building out and updating our suite of plugins in an effort to consolidate our technologies as well as enhance the overall user experience. As such, our most relevant solution may be an upcoming rollout.
Please feel free to check back in for any new technological updates at any time and do not hesitate to follow up with any further questions.
Although I haven’t used this particular Search Everything plugin, I can confirm that this issue is a result of the major v3.0 WooCommerce update, and acknowledged as a known ‘issue’.
We had the exact same issue with a large suite of sites, so I built a plugin to repair the issue: https://wordpress.org/plugins/order-search-repair-for-woocommerce/
Order Search Repair scans all orders that are not currently searchable and either updates them, or gives you the SQL top make a direct update to the database yourself.
@rudeone Feel free to give my plugin mentioned above a try and see if it solves the issue for you.
FYI @indextwo. This isn’t from WC 3.0. We’re running an older 2.xx version 😉
@imkane Ah! Then that plugin is definitely not for you! It was specifically built to fix the WC2x -> WC3x order search issue. It will most likely throw a hissy fit if you ran it on an older version.
@sovrn any updates on this? It’s now been 3 months since originally reported and we still can’t search WooCommerce orders in the backend, may have to consider changing search plugins if not solved soon.
@sovrn this is still impacting us as well. Do we have an ETA on a fix?
Unfortunately, we do not currently have an ETA on a fix. Our development team is working on multiple projects that, for the current quarter, have taken precedence over the consolidation update.
I will make sure to reach out within this thread as soon as I have any further information or timeline regarding the plugin and functionalities. We sincerely apologize for the inconvenience!
- The topic ‘Woocommerce ‘Search Orders’ stops working after the plugin update’ is closed to new replies.