Orders List only show the last 400 orders

Hi @lucein ,

We appreciate you for reaching out!

It sounds frustrating to not see those older orders after everything was working fine. Since your Order data storage is still set to Legacy, that could be the issue. Check if the plugin that’s not HPOS-compatible has any updates or fixes from the developer.

In the meantime, try clearing your WooCommerce transients under WooCommerce > Status > Tools. You can also check if Analytics → Orders shows the correct data, which you can download as a CSV for a clearer view.

If these steps don’t work, please send us the system status report under WooCommerce > Status > Get system report. This will help us learn more about your site and review your current setup. Once you’ve done that, you can paste the text in here using the “<code>” block.

Looking forward to getting this sorted out.

Hi @reynierc,

I did go in and cleared the Woocommerce Transients with the status Tools, with no success.

I then went into Analytics and was able to see older orders listed there and if I query the DB directly I can see orders in the db table.

On top of the old order not being accessible in the Orders list. We now have random current orders that are in the database. But do not show up in the Analytics or Orders List.

To me it seems like some kind of indexing issue.

here is the system status report that you wanted.

<br>### WordPress Environment ###<br><br>WordPress address (URL): https://tnvc.com<br>Site address (URL): https://tnvc.com<br>WC Version: 9.0.2<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 3 GB<br>WP Debug Mode: ?<br>WP Cron: ?<br>Language: en_US<br>External object cache: –<br><br>### Server Environment ###<br><br>Server Info: Apache<br>PHP Version: 8.2.16<br>PHP Post Max Size: 80 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 3000<br>cURL Version: 7.88.1<br>OpenSSL/3.0.14<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.35<br>Max Upload Size: 80 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ?<br><br>### Database ###<br><br>WC Database Version: 9.0.2<br>WC Database Prefix: wp_<br>Total Database Size: 5249.21MB<br>Database Data Size: 2994.07MB<br>Database Index Size: 2255.14MB<br>wp_woocommerce_sessions: Data: 26.13MB + Index: 0.76MB + Engine MyISAM<br>wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_attribute_taxonomies: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_order_items: Data: 22.06MB + Index: 9.28MB + Engine MyISAM<br>wp_woocommerce_order_itemmeta: Data: 211.83MB + Index: 101.14MB + Engine MyISAM<br>wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokens: Data: 0.51MB + Index: 0.23MB + Engine MyISAM<br>wp_woocommerce_payment_tokenmeta: Data: 3.46MB + Index: 2.23MB + Engine MyISAM<br>wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>tnvc_wc_id: Data: 0.03MB + Index: 0.00MB + Engine MyISAM<br>tnvcspecs-old: Data: 1.10MB + Index: 0.03MB + Engine MyISAM<br>wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 29.06MB + Index: 28.13MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 15.02MB + Index: 11.03MB + Engine InnoDB<br>wp_admin_columns: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_af_download_url: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_aioseo_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_apex_notification_bar: Data: 0.16MB + Index: 0.00MB + Engine MyISAM<br>wp_apexnb_subscriber: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_ariadminer_connections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cfgp_cache: Data: 3.05MB + Index: 1.02MB + Engine InnoDB<br>wp_cfgp_rest_access_token: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_cfgp_seo_redirection: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 2.02MB + Index: 2.03MB + Engine InnoDB<br>wp_comments: Data: 142.69MB + Index: 89.28MB + Engine InnoDB<br>wp_contact_form_7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_cptch_images: Data: 0.03MB + Index: 0.00MB + Engine MyISAM<br>wp_cptch_packages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_email_customizer_plus_templates: Data: 2.05MB + Index: 0.00MB + Engine InnoDB<br>wp_ewwwio_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_fbv_attachment_folder: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_gdpr_cc_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_addon_feed: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_entry: Data: 3.62MB + Index: 0.31MB + Engine MyISAM<br>wp_gf_entry_meta: Data: 6.42MB + Index: 3.68MB + Engine MyISAM<br>wp_gf_entry_notes: Data: 0.18MB + Index: 0.07MB + Engine MyISAM<br>wp_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_revisions: Data: 0.02MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_view: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gpui_sequence: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_loginpress_limit_login_details: Data: 7.52MB + Index: 0.00MB + Engine InnoDB<br>wp_loginpress_social_login_details: Data: 1.05MB + Index: 0.11MB + Engine MyISAM<br>wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_mail_bank_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_mailchimp_carts: Data: 1.50MB + Index: 0.07MB + Engine MyISAM<br>wp_mailchimp_jobs: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>wp_mc4wp_log: Data: 13.52MB + Index: 0.00MB + Engine InnoDB<br>wp_mo2f_user_device_details: Data: 0.03MB + Index: 0.00MB + Engine InnoDB<br>wp_monsterinsights_ai_insights_chats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_monsterinsights_pageinsights_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_monsterinsights_user_journey: Data: 45.58MB + Index: 0.00MB + Engine InnoDB<br>wp_moppm_user_report_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_options: Data: 229.53MB + Index: 12.13MB + Engine InnoDB<br>wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_po_plugins: Data: 0.99MB + Index: 0.19MB + Engine MyISAM<br>wp_podsrel: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_postmeta: Data: 783.00MB + Index: 654.00MB + Engine InnoDB<br>wp_posts: Data: 68.59MB + Index: 31.14MB + Engine InnoDB<br>wp_prli_clicks: Data: 0.05MB + Index: 0.19MB + Engine InnoDB<br>wp_prli_clicks_rotations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_prli_keywords: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_prli_link_metas: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_prli_link_rotations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_prli_links: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_prli_post_keywords: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_prli_post_urls: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_prli_report_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_prli_reports: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_proplayer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_proplayer_playlist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_404: Data: 8.41MB + Index: 1.20MB + Engine MyISAM<br>wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM<br>wp_redirection_logs: Data: 0.07MB + Index: 0.02MB + Engine MyISAM<br>wp_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM<br>wp_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_sliders: Data: 0.28MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_sliders7: Data: 0.17MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_sliders_bkp: Data: 0.23MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_slides: Data: 2.09MB + Index: 0.01MB + Engine MyISAM<br>wp_revslider_slides7: Data: 3.19MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_slides_bkp: Data: 0.75MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_rsssl_csp_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_rsssl_xmlrpc: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_instagram_feeds_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_sbi_instagram_posts: Data: 0.20MB + Index: 0.00MB + Engine MyISAM<br>wp_searchwp_index: Data: 9.96MB + Index: 5.37MB + Engine MyISAM<br>wp_searchwp_log: Data: 72.26MB + Index: 43.55MB + Engine MyISAM<br>wp_searchwp_status: Data: 0.05MB + Index: 0.05MB + Engine MyISAM<br>wp_searchwp_tokens: Data: 0.84MB + Index: 1.18MB + Engine MyISAM<br>wp_sessions_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_snippets: Data: 0.11MB + Index: 0.00MB + Engine MyISAM<br>wp_term_relationships: Data: 0.30MB + Index: 0.54MB + Engine MyISAM<br>wp_term_taxonomy: Data: 0.10MB + Index: 0.06MB + Engine MyISAM<br>wp_termmeta: Data: 0.44MB + Index: 0.66MB + Engine InnoDB<br>wp_terms: Data: 0.06MB + Index: 0.11MB + Engine MyISAM<br>wp_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_usermeta: Data: 221.78MB + Index: 250.73MB + Engine InnoDB<br>wp_users: Data: 12.52MB + Index: 13.55MB + Engine InnoDB<br>wp_vi_wbe_history: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_avatax_tax_codes: Data: 0.33MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 7.52MB + Index: 7.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_addresses: Data: 26.56MB + Index: 32.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.31MB + Index: 0.38MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 17.55MB + Index: 9.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 22.56MB + Index: 24.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 13.52MB + Index: 10.55MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 1.52MB + Index: 3.03MB + Engine InnoDB<br>wp_wc_orders: Data: 35.58MB + Index: 32.64MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 427.00MB + Index: 640.95MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.28MB + Index: 0.25MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.38MB + Index: 0.45MB + Engine MyISAM<br>wp_wc_rate_limits: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_wcsp_group_category_pricing_mapping: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wcsp_role_category_pricing_mapping: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wcsp_user_category_pricing_mapping: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.22MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 2.28MB + Index: 0.00MB + Engine InnoDB<br>wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilemods: Data: 0.22MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 5.02MB + Index: 4.05MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 1.02MB + Index: 0.23MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 3.02MB + Index: 0.58MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfpklist_template_data: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wfreversecache: Data: 3.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsecurityevents: Data: 1.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 2.02MB + Index: 2.05MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wmfo_fraud_attempts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wmfo_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woo_shippment_provider: Data: 0.09MB + Index: 0.01MB + Engine MyISAM<br>wp_woobe_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woobe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_bundled_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_bundled_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woot_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woot_tables_columns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woot_tables_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woot_vocabulary: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wpbe_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpbe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpmailsmtp_debug_events: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_email_tracking_events: Data: 1.02MB + Index: 2.03MB + Engine InnoDB<br>wp_wpmailsmtp_email_tracking_links: Data: 2.02MB + Index: 1.02MB + Engine InnoDB<br>wp_wpmailsmtp_emails_log: Data: 247.02MB + Index: 2.11MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmelon_advbedit_temp: Data: 0.11MB + Index: 0.08MB + Engine MyISAM<br>wp_wpns_backup_report: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpns_files_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wsal_generated_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wsal_metadata: Data: 124.66MB + Index: 193.69MB + Engine InnoDB<br>wp_wsal_occurrences: Data: 84.63MB + Index: 21.08MB + Engine InnoDB<br>wp_wsal_periodic_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wsal_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wspu_shipping_labels: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_abandonment_coupon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_sc_coupon_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wusp_group_product_price_mapping: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wusp_role_pricing_mapping: Data: 0.02MB + Index: 0.03MB + Engine MyISAM<br>wp_wusp_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wusp_subrules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wusp_user_pricing_mapping: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcbm_badge_rules_associations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 1.52MB + Index: 0.88MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.23MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.11MB + Index: 0.13MB + Engine InnoDB<br>wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.25MB + Index: 0.20MB + Engine InnoDB<br>wp_yoast_seo_meta: Data: 0.26MB + Index: 0.30MB + Engine MyISAM<br>wp_zip: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>acf-field: 148<br>acf-field-group: 16<br>amn_mi-lite: 2<br>attachment: 11744<br>bnfw_notification: 8<br>cookielawinfo: 6<br>custom_css: 1<br>customize_changeset: 1<br>cwginstocknotifier: 8810<br>envira: 1<br>gift_card: 265<br>is_search_form: 1<br>mc4wp-form: 2<br>mi_exceptions: 137<br>nav_menu_item: 204<br>oembed_cache: 83<br>page: 57<br>pewc_field: 153<br>pewc_group: 120<br>pewc_product_extra: 12445<br>post: 10<br>pretty-link: 1<br>product: 1299<br>product_variation: 3452<br>revision: 92<br>shop_coupon: 86<br>shop_order: 110409<br>shop_order_refund: 719<br>shopp_product: 1001<br>soliloquy: 1<br>static-block: 3<br>ufaq: 70<br>um_directory: 1<br>um_form: 3<br>wafs: 1<br>woc_hour: 1<br>woo_discount: 1<br>woo_mb_template: 11<br>wp_block: 1<br>wp_global_styles: 1<br>wp_navigation: 1<br>wpcf7_contact_form: 1<br>wpex_card: 1<br>wpex_templates: 1<br>yith-wcbm-badge: 2<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ?<br><br>### Active Plugins (104) ###<br><br>Gravity Perks: by Gravity Wiz – 2.3.12<br>Gravity Forms: by Gravity Forms – 2.8.18<br>Min Max Control (PRO): by CodeAstrology Team – 3.0.0<br>WooCommerce In-Stock Coupon restriction: by Prism I.T. Systems – 0.0.1<br>ACF Content Analysis for Yoast SEO: by Thomas Kr?ftner<br>ViktorFroberg<br>marol87<br>pekz0r<br>angrycreative<br>Team Yoast – 3.1<br><br>ACF-VC Integrator: by Frederik Rosendahl-Kaa – 1.8.6<br>Admin Columns Pro: by AdminColumns.com – 6.4.11<br>Advanced Custom Fields PRO: by WP Engine – 6.3.10<br>Advanced Shipment Tracking Pro: by zorem – 4.6.6<br>Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.5.1<br>Better Notifications for WP: by Made with Fuel – 1.9.7<br>Booster Plus for WooCommerce: by Pluggabl LLC – 7.2.3<br>Bulky - Bulk Edit Products for WooCommerce Premium: by VillaTheme – 1.3.5<br>Geo Controller: by INFINITUM FORM – 8.7.5<br>Classic Editor: by WordPress Contributors – 1.6.5<br>Classic Widgets: by WordPress Contributors – 0.3<br>Cloudflare: by Cloudflare<br>Inc. – 4.12.8<br><br>Code Snippets: by Code Snippets Pro – 3.6.5.1<br>Custom Order Numbers for WooCommerce Pro: by Tyche Softwares – 1.12.0<br>Display Posts: by Bill Erickson – 3.0.2<br>Home Product Selections: by Prism I.T. Systems – 1.0<br>Woocommerce Product Message Restriction: by Prism I.T. Systems – 1.0.0.0<br>EWD Premium Helper: by Etoile Web Design – 0.0.32<br>FileBird Lite: by Ninja Team – 6.3.2<br>MonsterInsights - eCommerce Addon: by MonsterInsights Team – 8.5.5<br>GDPR Cookie Compliance: by Moove Agency – 4.15.3<br>MonsterInsights Pro: by MonsterInsights – 9.2.0<br>GP Unique ID: by Gravity Wiz – 1.5.14<br>Product Meta: by  – 1.0.2<br>Gravity Forms Google Analytics Add-On: by Gravity Forms – 2.3.0<br>Gravity Forms Mailchimp Add-On: by Gravity Forms – 5.5.0<br>iThemeland Free Gifts For WooCommerce: by iThemelandco – 2.3.0<br>WPBakery Page Builder: by Michael M - WPBakery.com – 7.8<br>Login Logout Menu: by WPBrigade – 1.5.2<br>LoginPress Pro: by WPBrigade – 3.2.1<br>LoginPress: by LoginPress – 3.2.2<br>Mailchimp for WooCommerce: by Mailchimp – 4.4<br>MC4WP: Mailchimp for WordPress: by ibericode – 4.9.17<br>Maintenance: by WebFactory Ltd – 4.15<br>MC4WP: Mailchimp for WordPress Premium: by ibericode – 4.10.4<br>Melapress Login Security Premium: by Melapress – 1.3.1<br>MonsterInsights - AI Insights Addon: by MonsterInsights Team – 1.0.1<br>MonsterInsights - Page Insights Addon: by MonsterInsights Team – 1.6.0<br>MonsterInsights - User Journey Addon: by MonsterInsights Team – 1.1.5<br>WooCommerce Product Add-Ons Ultimate: by Plugin Republic – 3.21.3<br>Products Compare for WooCommerce: by BeRocket – 3.6.0<br>Redirection: by John Godley – 5.5.0<br>PublishPress Revisions: by PublishPress – 3.5.15<br>Slider Revolution Bubblemorph AddOn: by ThemePunch – 6.7.2<br>Slider Revolution Exploding Layers Add-On: by ThemePunch – 6.7.2<br>Slider Revolution Distortion Effect AddOn: by ThemePunch – 6.7.2<br>Slider Revolution Lottie AddOn: by ThemePunch – 6.7.2<br>Slider Revolution Particles Effect: by ThemePunch – 6.7.4<br>Slider Revolution Transitionpack Add-On: by ThemePunch – 6.7.5<br>Slider Revolution: by ThemePunch – 6.7.19<br>SearchWP Live Ajax Search: by SearchWP<br>LLC – 1.8.2<br><br>SearchWP WooCommerce Integration: by SearchWP – 1.3.12<br>SearchWP: by SearchWP – 4.3.16<br>SearchWP Customizations: by Rogue Point Inc. – 1.0.0<br>Show User Registration Date: by Carlos Martínez Romero – 1.0.0<br>Simple Cloudflare Turnstile: by Elliot Sowersby<br>RelyWP – 1.27.0<br><br>Simple Image Sizes: by Rahe – 3.2.3<br>SVG Support: by Benbodhi – 2.5.8<br>Templatera: by WPBakery – 2.2.0<br>Total Theme Core: by WPExplorer – 1.9<br>Ultimate FAQ Accordion Plugin: by Etoile Web Design – 2.3.0<br>UpdraftPlus - Backup/Restore: by TeamUpdraft<br>DavidAnderson – 2.24.6.26<br><br>Elegant Tabs for WPBakery Page Builder: by InfiWebs – 3.6.7<br>CTX Feed Pro: by WebAppick Author – 7.4.12<br>WebP Express: by Bj?rn Rosell – 0.25.9<br>Custom WooCommerce Logs: by  – 1.0<br>Ajax add to cart for WooCommerce: by QuadLayers – 2.4.1<br>WooCommerce Backorder Manager Pro: by jeffrey-wp – 3.1<br>Checkout Field Editor for WooCommerce: by ThemeHigh – 2.0.4<br>Discount Rules Core: by Flycart – 2.6.6<br>Min Max Quantity & Step Control for WooCommerce: by CodeAstrology Team – 6.4<br>Woo Stickers by Webline: by Weblineindia – 1.2.3<br>WooCommerce Advanced Free Shipping: by Jeroen Sormani – 1.1.7<br>Avalara AvaTax: by Avalara – 2.8.4<br>Checkout Field Editor for WooCommerce (Pro): by ThemeHigh – 3.6.3<br>Woo Conditional Shipping and Payments: by Woo – 2.0.3<br>WooCommerce Email Customizer Plus: by Flycart – 2.0.0<br>Filter WooCommerce Orders by Coupon: by SkyVerge – 1.1.0<br>WooCommerce Authorize.Net Gateway: by SkyVerge – 3.10.7 (update to version 3.10.8 is available)<br>WooCommerce Hear About Us: by SiteOptimo – 1.5.2<br>WooCommerce PayPal Payments: by WooCommerce – 2.9.1 (update to version 2.9.3 is available)<br>WooCommerce FedEx Shipping: by WooCommerce – 4.1.1 (update to version 4.1.2 is available)<br>WooCommerce UPS Shipping: by WooCommerce – 3.7.2<br>WooCommerce USPS Shipping: by WooCommerce – 5.0.1<br>WooCommerce: by Automattic – 9.0.2 (update to version 9.3.3 is available)<br>Wordfence Security: by Wordfence – 7.11.7<br>Yoast SEO Premium: by Team Yoast – 23.7<br>Yoast SEO: by Team Yoast – 23.7<br>WP Add Mime Types: by Kimiya Kitani – 3.1.1<br>WP Mail SMTP Pro: by WP Mail SMTP – 4.1.1<br>Widget Disable: by required – 3.0.1<br>Yoast SEO: WooCommerce: by Team Yoast – 16.4<br>Smart Coupons for WooCommerce Pro: by WebToffee – 2.4.4<br>Related Products for WooCommerce: by WebToffee – 1.5.7<br>YITH WooCommerce Brands Add-On: by YITH – 2.28.0<br>YITH WooCommerce Category Accordion Premium: by YITH – 2.13.0<br>YITH WooCommerce Customize My Account Page Premium: by YITH – 4.13.0<br>YITH WooCommerce Gift Cards Premium: by YITH – 4.18.0<br>YITH WooCommerce Product Bundles Premium: by YITH – 2.11.0<br><br>### Inactive Plugins (45) ###<br><br>Admin Menu Editor: by Janis Elsts – 1.12.4<br>Advanced Database Cleaner: by Younes JFR. – 3.1.5<br>Apex Notification Bar: by AccessPress Themes – 2.1.8<br>Better Search Replace: by WP Engine – 1.4.7<br>Booster Plus for WooCommerce: by Pluggabl LLC – 7.1.8<br>Bulk Product Sync for WooCommerce: by N-Media – 8.3<br>Bulk Product Sync with Google Sheets PRO: by N-Media – 7.6<br>Bulky - Bulk Edit Products for WooCommerce Premium: by VillaTheme – 1.3.4<br>Code Snippets Pro (Premium): by Code Snippets Pro – 3.6.5<br>Custom Taxonomy Order: by Marcel Pol – 4.0.0<br>Download Plugins and Themes from Dashboard: by WPFactory – 1.9.3<br>ELEX Authorize.Net Payment Gateway for WooCommerce: by ELEXtensions – 2.1.3<br>Email Customizer for WooCommerce and WordPress - Spark Email Editor: by emaileditorplus – 1.0.1<br>Extra Charges To Payment Gateway For WooCommerce (Standard): by hemsingh1 – 2.0.2.1<br>FooBar WordPress Notifications: by FooPlugins – 2.1.32<br>Friendly User Agent for WooCommerce: by Blaze Concepts – 1.3.0<br>Inactive Logout: by Inactive Logout – 3.4.4<br>LiteSpeed Cache: by LiteSpeed Technologies – 6.5.1<br>LoginPress - Social Login: by WPBrigade – 3.0.0<br>LoginPress Pro: by WPBrigade – 3.1.3<br>Menu Management Enhancer: by Chris Mavricos<br>SevenSpark – 1.2<br><br>Plugin Notes Plus: by Jamie Bergen – 1.2.8<br>Plugin Organizer: by Jeff Sterup – 10.1.10<br>PrettyLinks: by Pretty Links – 3.6.8<br>Query Monitor: by John Blackbourn – 3.16.4<br>Sequential Order Numbers for WooCommerce: by SkyVerge – 1.10.1<br>Slider Revolution Holiday Snow: by ThemePunch – 6.7.3<br>Slider Revolution Slicey Add-On: by ThemePunch – 6.7.2<br>Slider Revolution Typewriter Effect: by ThemePunch – 6.7.2<br>Temporary Login Without Password: by StoreApps – 1.8.3<br>UberMenu 3 - The Ultimate WordPress Mega Menu: by Chris Mavricos<br>SevenSpark – 3.8.4<br><br>User Role Editor: by Vladimir Garagulya – 4.64.2<br>WOLF - WordPress Posts Bulk Editor and Manager Professional: by realmag777 – 2.0.8.3<br>WooCommerce: by Automattic – 9.0.1 (update to version 9.3.3 is available)<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooCommerce Advanced Bulk Edit: by George Iron & Yas G. – 5.4.4.4<br>WooCommerce Advanced Bulk Edit: by George Iron & Yas G. – 5.4.4.3.1<br>WooCommerce Anti Fraud: by OPMC Australia Pty Ltd – 5.9.2 (update to version 6.0.1 is available)<br>WooCommerce Legacy REST API: by WooCommerce – 1.0.4<br>WooCommerce Payment Gateway Based Fees: by InoPlugs – 4.2 (update to version 5.0 is available)<br>WP 2FA - Two-factor authentication for WordPress (Premium): by Melapress – 2.6.4<br>WP Activity Log (Premium): by Melapress – 5.2.1<br>WP Crontrol: by John Blackbourn – 1.17.0<br>WP Migrate: by WP Engine – 2.6.13<br>Yoast Test Helper: by Team Yoast – 1.18<br><br>### Must Use Plugins (3) ###<br><br>Plugin Organizer MU: by Jeff Sterup – 10.1.10<br>Stop long comments: by WPEngine – 0.0.4<br>suppress-deprecated-warings-log.php: by  –<br><br>### Settings ###<br><br>API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: bundle (bundle)<br>external (external)<br>gift-card (gift-card)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br>yith_bundle (yith_bundle)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: –<br><br>### Logging ###<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 315 MB<br><br>### WC Pages ###<br><br>Shop base: #2581 - /shop/<br>Cart: #2582 - /cart/<br>Checkout: #2583 - /checkout/<br>My account: ? Page does not contain the [woocommerce_my_account] shortcode.<br>Terms and conditions: #79 - /terms/<br><br>### Theme ###<br><br>Name: Total Child<br>Version: 1.1<br>Author URL: https://totalwptheme.com<br>Child Theme: ?<br>Parent Theme Name: Total<br>Parent Theme Version: 5.19a<br>Parent Theme Author URL: https://www.wpexplorer.com/<br>WooCommerce Support: ?<br><br>### Templates ###<br><br>Archive Template: Your theme has a woocommerce.php file<br>you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.<br><br>Overrides: Total/woocommerce/archive-product.php<br>Total/woocommerce/checkout/form-checkout.php<br>total-child-theme/woocommerce/checkout/payment-method.php<br>Total/woocommerce/loop/loop-start.php<br>Total/woocommerce/loop/orderby.php<br>Total/woocommerce/loop/pagination.php<br>total-child-theme/woocommerce/myaccount/dashboard.php<br>Total/woocommerce/single-product/meta.php<br>Total/woocommerce/single-product/rating.php<br>total-child-theme/woocommerce/single-product/related.php<br>total-child-theme/woocommerce/single-product/tabs/description.php<br>Total/woocommerce/single-product/tabs/tabs.php<br>Total/woocommerce/single-product/title.php<br><br><br>### Authorize.Net Credit Card ###<br><br>Environment: Production<br>Tokenization Enabled: ?<br>Debug Mode: Off<br>Webhooks Enabled: ?<br><br>### WooCommerce PayPal Payments ###<br><br>Onboarded: ?<br>Shop country code: US<br>WooCommerce currency supported: ?<br>Advanced Card Processing available in country: ?<br>Pay Later messaging available in country: ?<br>Webhook status: –<br>PayPal Vault enabled: –<br>ACDC Vault enabled: –<br>Logging enabled: ?<br>Reference Transactions: ?<br>Used PayPal Checkout plugin: ?<br>Subscriptions Mode: Disabled<br>PayPal Shipping Callback: –<br>Apple Pay: ?<br>Google Pay: ?<br>Fastlane: –<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-11-02 10:00:37 -04:00<br>Options: ?<br>Notes: 166<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Canceled: 539<br>Oldest: 2024-10-01 17:26:07 -0400<br>Newest: 2024-11-01 15:56:47 -0400<br><br>Complete: 49,525<br>Oldest: 2024-10-01 17:23:57 -0400<br>Newest: 2024-11-01 17:23:32 -0400<br><br>Failed: 3,926<br>Oldest: 2021-05-20 16:29:51 -0400<br>Newest: 2024-10-29 18:43:48 -0400<br><br>Pending: 9<br>Oldest: 2024-11-01 17:28:32 -0400<br>Newest: 2024-11-07 13:14:52 -0500<br><br><br>### Status report information ###<br><br>Generated at: 2024-11-01 17:24:30 -04:00<br>

let me know if there is anything else you need.

Hi Lucein,

Thank you for providing the details and System Status Report!

It sounds like the order data may indeed have an indexing issue, especially if certain orders are visible in Analytics or the database but not in the Orders list. Here are a few steps that might help troubleshoot this further:

1. Database Optimization and Reindexing: Given the large size of your database, it’s possible the order index has become fragmented. Running a database optimization can help. You can use the built-in WooCommerce tools to regenerate lookup tables under WooCommerce > Status > Tools > Regenerate order table indexes.
2. Conflict Testing: Since HPOS is set to Legacy due to plugin incompatibility, it could be worth testing by temporarily deactivating the non-compatible plugin (if possible) and switching to HPOS. This would help isolate whether the compatibility setting could be a contributing factor.
3. Order Status Check: Ensure that the orders you’re looking for haven’t been filtered out by any order status settings. Occasionally, filtering settings or caching might restrict the display to only specific types, such as “Completed” orders, etc.
4. Check WooCommerce Updates: WooCommerce 9.3.3 is now available, and updating may bring patches that could help with data indexing issues in the Orders list. Given the critical nature of your orders, be sure to back up your site fully before updating.

If the issue persists, please let us know.

Best regards,

Riyaz

Hello Riyaz,

1. Regenerate Index tables.
I don’t see an option of Regenerate Order Table indexes. the only options for Regenerate that I have are: https://www.evernote.com/shard/s16/sh/10fb4b1c-4825-42d3-a080-c5e0048125e2/SyHdHe3OuRIIGCp5Uf-YnhR-CQG-JFCRdSoCbUL779lxEwiAqieE3xKA6w

a. Product lookup tables
b. Regenerate shop thumbnails
c. Regenerate the product attributes lookup table

2. Disabling the plugin for HPOS storage.
I deactivated the plugin and made sure the orders showed as synced. I enabled it and also turned on HPOS full text search indexes for orders.

The missing order is now showing and the past orders are now showing well after getting HPOS enabled.

New issue now, that HPOS is enabled.

The Products list is only showing 2 products even though we have over 1000. also if I try to filter the product listing or edit some products from their links in an order.

I get the message: There has been a critical error on this website. Please check your site admin email inbox for instructions. with no email being sent.

the only changes has been is HPOS has been enabled. How can I get this fix this issue?

Hi Lucein,

Could you please open a ticket at WooCommerce.com so that we can investigate further? I think this requires further investigation, which we can carry out there. Please copy the link from this forum to your ticket, so that we can match them up.

Regards,

Nic