Migrated DB now searching order doesn’t work

Hey @sethbahookey,

That’s an interesting situation. Is the search failing for all orders (new and imported) or only the ones that were imported to the new site? If searching new orders works correctly, then it could be an issue in the relationship between the simple products and the variable ones. They may not match up correctly via SKU or ID and could cause issues connecting orders to products.

If you don’t have a new order to test, create a quick manual order with some of the new products in it. Then search for that in the admin and see if it works.

Let us know what you find out there,

Hi @3sonsdevelopment

Thank you for responding! No the search is just fine for any new orders that are coming through so just the old orders from the woocommerce plugin I purchased.

Do you know how the search on the backend works? Unfortunately I can never seem to find any legit dev docs that explain any functionality, and then when I think I find something it’s usually just someone trying to sell me a plugin that I have no interest in lol

I think I may have discovered something to pinpoint this a little better. I have one customer that had a purchase on the old site, and there are several purchases from them on the new site. When I type in that person’s name it only brings up the new orders, but the old order does not show; however, if I search by that user’s email address, then all orders show.

So I’m thinking it has something to do with the way the search works, the person’s name is all over the old order. Any ideas on why the old order isn’t showing up in the search when I go by there name?

Thanks!!

Hi @sethbahookey,

That is a puzzling situation indeed. The WooCommerce order search just uses the search that’s built into the WordPress core. When you search from a list of orders, pages, posts and so on, it simply searches from inside that post type. The core search feature is a bit lacking, to be honest. There are lots of extensions to improve it, but they mostly are for the front-end of the site.

Since the new orders will show up, but the old ones won’t it makes me think something is not right with the old ones in the database. It could be that the encoding is different for those entries or something else. Whatever it is, it is keeping these old, imported entries from being returned as results.

In years past, I’ve used the Search WP plugin to enhance the search on the front-end of a site. It can also be applied to the admin too. It creates its own search index. That might help overcome any of these issues without making edits to the database directly.

That might be something to look at and consider.

Hi @3sonsdevelopment

Interesting, thanks for the quick response! I’m not a guru with SQL, but I’m definitely handy with it and would be totally fine with playing in the database (I have a proper workflow setup so I wouldn’t be cowboy coding). Do you know what the search is looking for in the database? If I could figure that piece out I could just single out the older orders and make an update statement. I’d like to try and do this with minimal plugins ??

Hi @sethbahookey,

If you don’t mind working with it, then here’s what I would do. Make a backup of the database. Then I would locate a row for one of the orders that is displaying properly in results and one from the same customer that isn’t. Then compare the two and look for anything that’s different between the two. If you can locate what the difference is, you’ll be able to craft an update to address it.

If you give that a try, let me know what you find out. I’d be curious to know what the trouble ended up being.

Cheers,

Hi @sethbahookey,

Since it’s been a while since we’ve heard from you, hopefully, that means you were able to get the order search issue fixed. If you still have trouble, please open up a new topic and we’ll be happy to help out.

Best,