rishs

There are so man completed orders like almost 1100 orders but i cant see them at the top and i cant see them until i hit filter option. (https://ibb.co/nXX8bp9) This image is for to show how many are there in total its shows this when i click on filter option. And only there are 2 trash orders and 10 failed orders 23 processing and remaining all are completed orders.

Link for System Status Report
https://pastebin.com/XBshRG3B

i tried with both Storefront & Twenty Twenty-Five themes in staging site it still doesn’t work. https://www.awesomescreenshot.com/video/45759638?key=2fcbac8103b23991187c20ca65265240

https://www.awesomescreenshot.com/video/45759684?key=3263d8c08d570a54ecaa5da24d7b7c51

Please check the attached links to get and idea how it shows. “Grapefruit” is not even first word its somewhere down. Can you please help me fix this

/**

• Fix WooCommerce admin product search — make it search by exact title and SKU.
  */
  add_filter(‘posts_search’, function ($search, $query) {
  global $wpdb; // Only modify search in WooCommerce products admin list
  if (!is_admin() || !$query->is_main_query()) {
  return $search;
  } if (!isset($_GET[‘post_type’]) || $_GET[‘post_type’] !== ‘product’) {
  return $search;
  } $term = isset($_GET[‘s’]) ? trim($_GET[‘s’]) : ”;
  if ($term === ”) {
  return $search;
  } $like_term = ‘%’ . $wpdb->esc_like($term) . ‘%’;
  $exact_term = $wpdb->esc_like($term); // Build SQL to match product title OR exact SKU
  $search = $wpdb->prepare(“
  AND (
  {$wpdb->posts}.post_title LIKE %s
  OR {$wpdb->posts}.ID IN (
  SELECT post_id
  FROM {$wpdb->postmeta}
  WHERE (meta_key = ‘_sku’ AND meta_value LIKE %s)
  )
  )
  “, $like_term, $exact_term); return $search;
  }, 10, 2);
  
  
  But it working when i kept this PHP code in the code snippets.https://ibb.co/PvSXzpgm

• This reply was modified 7 months, 2 weeks ago by rishs.
• This reply was modified 7 months, 2 weeks ago by rishs.

I will try to do it and get back to you

• This reply was modified 7 months, 2 weeks ago by rishs.

I’m searching here in woo commerce > products > product search and i think this problem is there from starting we recently added new products so its hard to find after searching product name.( https://ibb.co/YBS4D6Ls) Image Link

https://pastebin.com/r5i3BU7h