Admin Order Search using Customer Name does not return all matching orders · woocommerce/woocommerce#56445

(4 comments) (1 reaction) (0 assignees)PHP (10.294 stars) (10.695 forks)batch import

BugGood First IssueOrder ManagementRubiktype: community contribution

Description

Prerequisites

I have carried out troubleshooting steps and I believe I have found a bug.
I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

Describe the bug

When using the search box on the admin orders screen for a customer's full name, the search results seem to only include orders that have a non-zero total. Zero dollar orders are excluded.

If you search for only a last name, all orders, including zero dollar orders are returned.

Expected behavior

Search results should include zero-dollar orders when searching by full or last name.

Actual behavior

Search results for a full customer name do not include any orders that have a total of zero dollars.

Steps to reproduce

Find a customer with both zero and non-zero orders.
Use the admin search box to search for their full name.
Use the admin search box to search for only their last name.

WordPress Environment

WordPress address (URL): https://justcauseapparel.comSite address (URL): https://justcauseapparel.comWC Version: 9.7.1Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.Action Scheduler Version: ✔ 3.9.0Log Directory Writable: ✔WP Version: 6.7.2WP Multisite: –WP Memory Limit: 8 GBWP Debug Mode: –WP Cron: ✔Language: en_USExternal object cache: –

Server Environment

Server Info: ApachePHP Version: 8.1.10PHP Post Max Size: 80 MBPHP Time Limit: 60PHP Max Input Vars: 15000cURL Version: 7.74.0OpenSSL/1.1.1w

SUHOSIN Installed: –MySQL Version: 10.6.9-MariaDBMax Upload Size: 80 MBDefault Timezone is UTC: ✔fsockopen/cURL: ✔SoapClient: ✔DOMDocument: ✔GZip: ✔Multibyte String: ✔Remote Post: ✔Remote Get: ✔

Database

WC Database Version: 9.7.1WC Database Prefix: wp_Total Database Size: 2810.95MBDatabase Data Size: 1953.00MBDatabase Index Size: 857.95MBwp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDBwp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDBwp_woocommerce_order_items: Data: 5.52MB + Index: 2.52MB + Engine InnoDBwp_woocommerce_order_itemmeta: Data: 72.61MB + Index: 53.16MB + Engine InnoDBwp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDBwp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDBwp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_woocommerce_payment_tokens: Data: 0.41MB + Index: 0.14MB + Engine InnoDBwp_woocommerce_payment_tokenmeta: Data: 1.52MB + Index: 1.95MB + Engine InnoDBwp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDBall_upcs: Data: 2.52MB + Index: 0.00MB + Engine InnoDBalphabroder: Data: 8.52MB + Index: 0.00MB + Engine InnoDBalpha_pricing_temp: Data: 8.52MB + Index: 0.00MB + Engine InnoDBasn: Data: 3.52MB + Index: 0.00MB + Engine InnoDBattributelog: Data: 0.09MB + Index: 0.00MB + Engine InnoDBbarco: Data: 1.52MB + Index: 0.00MB + Engine InnoDBbulk_order_items: Data: 0.41MB + Index: 0.08MB + Engine InnoDBbulk_order_items_archive: Data: 2.52MB + Index: 0.00MB + Engine InnoDBcareismatic_raw: Data: 5.52MB + Index: 0.00MB + Engine InnoDBcloseout: Data: 0.09MB + Index: 0.00MB + Engine InnoDBcloseout_tempdata: Data: 31.56MB + Index: 0.00MB + Engine InnoDBcost: Data: 20.55MB + Index: 0.00MB + Engine InnoDBdeposco_availability: Data: 6.52MB + Index: 0.00MB + Engine InnoDBdeposco_inventory: Data: 16.52MB + Index: 0.00MB + Engine InnoDBedwards_inventory_temp: Data: 2.52MB + Index: 0.00MB + Engine InnoDBehab_users_temp: Data: 0.31MB + Index: 0.00MB + Engine InnoDBenhabit_23_combined: Data: 1.52MB + Index: 0.00MB + Engine InnoDBenhabit_first: Data: 1.52MB + Index: 0.00MB + Engine InnoDBenhabit_hrd: Data: 0.06MB + Index: 0.00MB + Engine InnoDBenhabit_locations: Data: 0.08MB + Index: 0.00MB + Engine InnoDBenhabit_logoresend: Data: 0.02MB + Index: 0.00MB + Engine InnoDBenhabit_missing: Data: 0.06MB + Index: 0.00MB + Engine InnoDBenhabit_orders: Data: 1.52MB + Index: 0.00MB + Engine InnoDBenhabit_resend: Data: 0.02MB + Index: 0.00MB + Engine InnoDBenhabit_resend2: Data: 0.02MB + Index: 0.00MB + Engine InnoDBenhabit_second: Data: 1.52MB + Index: 0.00MB + Engine InnoDBenhabit_second_round: Data: 1.52MB + Index: 0.00MB + Engine InnoDBenhabit_shipments: Data: 0.08MB + Index: 0.00MB + Engine InnoDBenhabit_third_round: Data: 0.16MB + Index: 0.00MB + Engine InnoDBenhabit_timestamps: Data: 0.34MB + Index: 0.00MB + Engine InnoDBenhabit_troubleshoot: Data: 1.52MB + Index: 0.00MB + Engine InnoDBexternal_discontinued: Data: 1.52MB + Index: 0.00MB + Engine InnoDBinterim_eligibility: Data: 0.08MB + Index: 0.00MB + Engine InnoDBjcs_transmit_log: Data: 5.52MB + Index: 0.00MB + Engine InnoDBparkley: Data: 0.13MB + Index: 0.00MB + Engine InnoDBpayroll_usage: Data: 0.02MB + Index: 0.00MB + Engine InnoDBprice_overrides: Data: 3.52MB + Index: 0.00MB + Engine InnoDBquickbooks_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDBquickbooks_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDBquickbooks_oauth: Data: 0.02MB + Index: 0.00MB + Engine InnoDBquickbooks_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDBquickbooks_recur: Data: 0.02MB + Index: 0.03MB + Engine InnoDBquickbooks_ticket: Data: 0.02MB + Index: 0.02MB + Engine InnoDBquickbooks_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDBreorders: Data: 0.02MB + Index: 0.00MB + Engine InnoDBreplacement_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDBresurgens_anniversary: Data: 0.05MB + Index: 0.00MB + Engine InnoDBrushgme_addresses: Data: 0.02MB + Index: 0.00MB + Engine InnoDBrushgme_orders: Data: 0.27MB + Index: 0.00MB + Engine InnoDBsanmar_gtin: Data: 21.55MB + Index: 0.00MB + Engine InnoDBsanmar_raw: Data: 273.80MB + Index: 0.00MB + Engine InnoDBsite_feed: Data: 5.52MB + Index: 0.00MB + Engine InnoDBspload: Data: 5.52MB + Index: 0.00MB + Engine InnoDBspload_parents: Data: 0.22MB + Index: 0.00MB + Engine InnoDBstipend: Data: 0.31MB + Index: 0.00MB + Engine InnoDBstipend_usage: Data: 0.20MB + Index: 0.00MB + Engine InnoDBtemp_colorlookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDBtemp_packslips: Data: 0.02MB + Index: 0.00MB + Engine InnoDBtmp_discontinued: Data: 0.19MB + Index: 0.00MB + Engine InnoDBupc_issues: Data: 5.52MB + Index: 0.00MB + Engine InnoDBvanderbilt_peds: Data: 0.02MB + Index: 0.00MB + Engine InnoDBvanderbilt_stipend: Data: 0.08MB + Index: 0.00MB + Engine InnoDBvendor_feed: Data: 58.59MB + Index: 0.00MB + Engine InnoDBwp_actionscheduler_actions: Data: 17.02MB + Index: 22.13MB + Engine InnoDBwp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_actionscheduler_logs: Data: 13.02MB + Index: 9.03MB + Engine InnoDBwp_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_commentmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDBwp_comments: Data: 8.52MB + Index: 8.09MB + Engine InnoDBwp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDBwp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDBwp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDBwp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDBwp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_frm_fields: Data: 1.48MB + Index: 0.05MB + Engine InnoDBwp_frm_forms: Data: 0.08MB + Index: 0.02MB + Engine InnoDBwp_frm_items: Data: 2.52MB + Index: 1.59MB + Engine InnoDBwp_frm_item_metas: Data: 9.52MB + Index: 11.55MB + Engine InnoDBwp_frm_payments: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_frm_subscriptions: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_hubwoo_log: Data: 62.08MB + Index: 0.00MB + Engine InnoDBwp_jcs_deletelist: Data: 0.22MB + Index: 0.00MB + Engine InnoDBwp_jcs_discontinued: Data: 0.42MB + Index: 0.00MB + Engine InnoDBwp_jcs_imported: Data: 1.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_inventory: Data: 12.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_sp_log: Data: 4.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_suppression: Data: 0.08MB + Index: 0.00MB + Engine InnoDBwp_jcs_temp_all_products: Data: 1.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_temp_discontinued: Data: 3.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_temp_inventory_log: Data: 0.16MB + Index: 0.00MB + Engine InnoDBwp_jcs_temp_inventory_updates: Data: 3.52MB + Index: 0.00MB + Engine InnoDBwp_jcs_temp_new_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_jet_smart_filters_indexer: Data: 1.52MB + Index: 0.00MB + Engine InnoDBwp_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_mailchimp_carts: Data: 4.02MB + Index: 0.00MB + Engine InnoDBwp_mailchimp_jobs: Data: 44.08MB + Index: 0.00MB + Engine InnoDBwp_mb_relationships: Data: 0.02MB + Index: 0.05MB + Engine InnoDBwp_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_list_customertype: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_list_inventorysite: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_list_salesrep: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_list_shipmethod: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_list_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_map_promo_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_map_shipping_product: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_map_wq_cf: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_mw_wc_qbo_desk_qbd_vendors: Data: 0.11MB + Index: 0.00MB + Engine InnoDBwp_options: Data: 46.09MB + Index: 3.20MB + Engine InnoDBwp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDBwp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_pmxi_images: Data: 0.17MB + Index: 0.00MB + Engine InnoDBwp_pmxi_imports: Data: 0.27MB + Index: 0.00MB + Engine InnoDBwp_pmxi_posts: Data: 0.31MB + Index: 0.19MB + Engine InnoDBwp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_postmeta: Data: 394.95MB + Index: 392.14MB + Engine InnoDBwp_posts: Data: 67.44MB + Index: 23.83MB + Engine InnoDBwp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDBwp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDBwp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDBwp_relevanssi: Data: 5.41MB + Index: 9.11MB + Engine InnoDBwp_relevanssi_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_relevanssi_stopwords: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDBwp_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDBwp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_revslider_sliders: Data: 0.11MB + Index: 0.02MB + Engine InnoDBwp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_revslider_slides: Data: 0.30MB + Index: 0.02MB + Engine InnoDBwp_revslider_slides_bkp: Data: 0.09MB + Index: 0.00MB + Engine InnoDBwp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_shortpixel_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_shortpixel_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_shortpixel_postmeta: Data: 33.58MB + Index: 32.61MB + Engine InnoDBwp_shortpixel_queue: Data: 6.48MB + Index: 1.09MB + Engine InnoDBwp_termmeta: Data: 0.28MB + Index: 0.38MB + Engine InnoDBwp_terms: Data: 0.13MB + Index: 0.17MB + Engine InnoDBwp_term_relationships: Data: 7.52MB + Index: 6.52MB + Engine InnoDBwp_term_taxonomy: Data: 0.19MB + Index: 0.19MB + Engine InnoDBwp_usermeta: Data: 24.56MB + Index: 20.05MB + Engine InnoDBwp_users: Data: 3.52MB + Index: 4.53MB + Engine InnoDBwp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wc_avatax_tax_codes: Data: 0.36MB + Index: 0.00MB + Engine InnoDBwp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_wc_customer_lookup: Data: 2.52MB + Index: 1.92MB + Engine InnoDBwp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDBwp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDBwp_wc_order_coupon_lookup: Data: 0.30MB + Index: 0.38MB + Engine InnoDBwp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_wc_order_product_lookup: Data: 6.52MB + Index: 7.97MB + Engine InnoDBwp_wc_order_stats: Data: 2.48MB + Index: 3.28MB + Engine InnoDBwp_wc_order_tax_lookup: Data: 0.20MB + Index: 0.20MB + Engine InnoDBwp_wc_product_attributes_lookup: Data: 16.17MB + Index: 9.31MB + Engine InnoDBwp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wc_product_meta_lookup: Data: 15.55MB + Index: 36.02MB + Engine InnoDBwp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_woocommerce_gc_activity: Data: 0.11MB + Index: 0.06MB + Engine InnoDBwp_woocommerce_gc_cards: Data: 0.14MB + Index: 0.09MB + Engine InnoDBwp_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDBwp_wpml_mails: Data: 387.59MB + Index: 0.00MB + Engine InnoDBwp_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDBwp_wps_index: Data: 118.67MB + Index: 170.89MB + Engine InnoDBwp_wps_key: Data: 9.52MB + Index: 10.52MB + Engine InnoDBwp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDBwp_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_yoast_indexable: Data: 19.36MB + Index: 9.25MB + Engine InnoDBwp_yoast_indexable_hierarchy: Data: 1.08MB + Index: 1.25MB + Engine InnoDBwp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDBwp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDBwp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

afterpay_quote: 4attachment: 20903cause: 24elementor_library: 58elementor_snippet: 3frm_form_actions: 38frm_styles: 1global_product_addon: 3group: 55jet-engine: 2jet-smart-filters: 7location: 837mb-post-type: 1mb-settings-page: 1meta-box: 14multi-logo: 1nav_menu_item: 99oembed_cache: 10page: 44popup: 2popup_theme: 8post: 20product: 948product_variation: 64443revision: 2703shop_coupon: 4200shop_order: 21351shop_order_refund: 354wc_order_email: 1wc_order_status: 42wp_font_face: 33wp_font_family: 12

Security

Secure connection (HTTPS): ✔Hide errors from visitors: ✔

Active Plugins (58)

Better Search Replace: by WP Engine – 1.4.10WordPress Backup & Security Plugin - BlogVault: by Backup by BlogVault – 5.92Classic Editor: by WordPress Contributors – 1.6.7Classic Widgets: by WordPress Contributors – 0.3Woo Coupons Pay for Shipping: by Azharul Haque Lincoln – 1.0.0Custom Post Type UI: by WebDevStudios – 1.17.2Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5Elementor Pro: by Elementor.com – 3.27.5Elementor: by Elementor.com – 3.27.6Enable Media Replace: by ShortPixel – 4.1.5Formidable Google Sheets: by Strategy11 – 1.0.4Formidable Forms Pro: by Strategy11 – 6.18.1Formidable Stripe: by Strategy11 – 3.1.6Formidable Surveys: by Strategy11 – 1.1.4Formidable Forms: by Strategy11 Form Builder Team – 6.19reCaptcha by BestWebSoft: by BestWebSoft – 1.80JCA Payment Gateway: by Greenville Webworks – 1.0JCS Custom Email Templates: by Greenville Webworks – 1.0JCS Group Login Logic: by Greenville Webworks – 1.1JCS Reports: by Greenville Webworks – 1.0JCS Site Functions: by Greenville Webworks – 1.0JCS Sync: by Greenville Webworks – 1.0JetEngine: by Crocoblock – 3.6.4.1JetSmartFilters: by Crocoblock – 3.6.3JetWooBuilder For Elementor: by Crocoblock – 2.1.18JSM Show User Metadata: by JS Morisset – 4.6.2Mailchimp for WooCommerce: by Mailchimp – 5.2MB Core: by MetaBox.io – 1.19.1Media Deduper Pro: by Cornershop Creative – 1.5.1Meta Box: by MetaBox.io – 5.10.8miniOrange SAML SSO Multiple IDP: by miniOrange – 25.2.7Redirection: by John Godley – 5.5.2Relevanssi: by Mikko Saari – 4.24.3Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.9.9Taxonomy Images: by Michael FieldsBen Huson – 1.0

Ultimate Addons for Elementor Pro: by Brainstorm Force – 1.38.1User Switching: by John Blackbourn – 1.9.1WC Duplicate Order: by Jamie Gill – 1.7WooCommerce Manual Payment: by bfl – 2.8.5Preview E-mails for WooCommerce: by Digamber Pradhan – 2.2.13WooCommerce.com Update Manager: by Automattic – 1.0.3Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 2.1.4Variation Swatches for WooCommerce: by Emran Ahmed – 2.2.0Avalara AvaTax: by Avalara – 2.10.2WooCommerce Google Analytics Pro: by SkyVerge – 1.12.0 (update to version 2.2.0 is available)WooCommerce Order Status Manager: by SkyVerge – 1.15.5WooCommerce Product Add-ons: by WooCommerce – 3.0.11 (update to version 7.7.0 is available)WooCommerce Product Reviews Pro: by SkyVerge – 1.19.3WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.21.4WooCommerce Shipment Tracking: by WooCommerce – 2.5.6WooCommerce URL Coupons: by SkyVerge – 2.16.0WooCommerce: by Automattic – 9.7.1WordPress Importer: by wordpressdotorg – 0.8.3Yoast SEO: by Team Yoast – 24.6WP Mail Logging: by WP Mail Logging Team – 1.14.0WP Mail SMTP: by WP Mail SMTP – 4.4.0WP Rollback: by WP Rollback – 2.0.7WPMU DEV Dashboard: by WPMU DEV – 4.11.8

Inactive Plugins (11)

Core Rollback: by Andy Fragen – 1.3.7Disable Emails: by WebAware – 1.8.2MWB HubSpot for WooCommerce: by MakeWebBetter – 1.6.1Query Monitor: by John Blackbourn – 3.17.2Server IP & Memory Usage Display: by ApasionadosApasionados del Marketing – 2.1.0

ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 6.1.3WooCommerce Gift Cards: by SomewhereWarm – 1.8.0 (update to version 2.4.1 is available)WooCommerce PayPal Payments: by WooCommerce – 2.9.6WooCommerce Stripe Gateway: by Stripe – 9.3.1WP Hooks Finder: by Muhammad Rehman – 1.3.2WP Maintenance: by Florent Maillefaud – 6.1.9.6

Dropin Plugins ()

advanced-cache.php: advanced-cache.php

Settings

Legacy API Enabled: –Force SSL: –Currency: USD ($)Currency Position: leftThousand Separator: ,Decimal Separator: .Number of Decimals: 2Taxonomies: Product Types: external (external)grouped (grouped)simple (simple)variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)exclude-from-search (exclude-from-search)featured (featured)outofstock (outofstock)rated-1 (rated-1)rated-2 (rated-2)rated-3 (rated-3)rated-4 (rated-4)rated-5 (rated-5)

Connected to WooCommerce.com: ✔Enforce Approved Product Download Directories: –HPOS feature enabled: –Order datastore: WC_Order_Data_Store_CPTHPOS data sync enabled: –

Logging

Enabled: ✔Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2Retention period: 30 daysLevel threshold: –Log directory size: 91 MB

WC Pages

Shop base: #9 - /catalog/Cart: #10 - /cart/ - Contains the woocommerce_cart shortcodeCheckout: #11 - /checkout/ - Contains the woocommerce_checkout shortcodeMy account: #12 - /my-account/ - Contains the [woocommerce_my_account] shortcodeTerms and conditions: ❌ Page not set

Theme

Name: Just Cause ScrubsVersion: 1.0.1Author URL: https://greenvillewebworks.comChild Theme: ✔Parent Theme Name: Hello ElementorParent Theme Version: 2.6.1 – 3.3.0 is availableParent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dashTheme type: Classic themeWooCommerce Support: ✔

Templates

Overrides: justcause/woocommerce/archive-product.php version 3.4.0 is out of date. The core version is 8.6.0justcause/woocommerce/cart/cart-empty.php version 3.5.0 is out of date. The core version is 7.0.1justcause/woocommerce/cart/cart.php version 3.8.0 is out of date. The core version is 7.9.0justcause/woocommerce/checkout/form-billing.phpjustcause/woocommerce/checkout/form-coupon.phpjustcause/woocommerce/checkout/review-order.phpjustcause/woocommerce/checkout/thankyou.php version 3.2.0 is out of date. The core version is 8.1.0justcause/woocommerce/emails/email-header.php version 4.0.0 is out of date. The core version is 9.7.0justcause/woocommerce/emails/email-order-details.php version 3.3.1 is out of date. The core version is 9.7.0justcause/woocommerce/myaccount/dashboard.phpjustcause/woocommerce/myaccount/form-login.php version 4.1.0 is out of date. The core version is 9.7.0justcause/woocommerce/myaccount/orders.php version 7.8.0 is out of date. The core version is 9.5.0justcause/woocommerce/myaccount/view-order.phpjustcause/woocommerce/single-product/price.phpjustcause/woocommerce/single-product/product-attributes.php version 3.6.0 is out of date. The core version is 9.3.0justcause/woocommerce/single-product/product-image.php version 3.5.1 is out of date. The core version is 9.7.0justcause/woocommerce/single-product/related.php version 3.9.0 is out of date. The core version is 9.6.0justcause/woocommerce/single-product/stock.php

Outdated Templates: ❌

					Learn how to update					 |
				
					
				
				
					Clear system status theme info cache

Admin

Enabled Features: activity-panelsanalyticsproduct-block-editorcouponscore-profilercustomize-storecustomer-effort-score-tracksimport-products-taskexperimental-fashion-sample-productsshipping-smart-defaultsshipping-setting-tourhomescreenmarketingmobile-app-banneronboardingonboarding-taskspattern-toolkit-full-composabilityproduct-custom-fieldsremote-inbox-notificationsremote-free-extensionspayment-gateway-suggestionsprintfulshipping-label-bannersubscriptionsstore-alertstransient-noticeswoo-mobile-welcomewc-pay-promotionwc-pay-welcome-pagelaunch-your-storeadd-to-cart-with-options-stepper-layout

Disabled Features: product-data-viewsexperimental-blockscoming-soon-newsletter-templateminified-jsproduct-pre-publish-modalsettingsasync-product-editor-category-fieldproduct-editor-template-systemblueprintreactify-classic-payments-settingsuse-wp-horizonblockified-add-to-cart

Daily Cron: ✔ Next scheduled: 2025-03-17 19:37:46 -05:00Options: ✔Notes: 19Onboarding: completed

Action Scheduler

Canceled: 122Oldest: 2025-02-17 15:58:40 +0000Newest: 2025-03-07 18:51:24 +0000

Complete: 23,502Oldest: 2025-02-14 12:45:14 +0000Newest: 2025-03-17 07:02:32 +0000

Failed: 12,564Oldest: 2019-12-02 18:14:25 +0000Newest: 2025-03-13 12:32:34 +0000

Pending: 4Oldest: 2025-03-17 15:19:55 +0000Newest: 2025-03-18 03:16:00 +0000

Status report information

Generated at: 2025-03-17 07:33:57 -05:00`

Isolating the problem

I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
This bug happens with a default WordPress theme active, or Storefront.
I can reproduce this bug consistently using the steps above.

Guia do colaborador

Pilha de tecnologia: sqlmysql
Domain: backend
Tipo Issue: bug
Difficulty: 2
Tempo estimado: 1-3 hours
Status da atividade: active
Clarity: clear
Prerequisites: Basic knowledge of WordPressSQL query basicsWooCommerce order data structure
Simpatia para novatos: 55
Direção de pesquisa: Investigate the admin order search logic in WooCommerce, specifically the part that builds the search query. The bug suggests that when searching by full name, a condition filters out orders with total zero. Compare the query used for full name search versus last name search. Look in files like includes/admin/class wc admin list table orders.php or related meta queries. Check for any filters that modify the search clause.