Old (oder than 2024) orders not displayed in woocomerce dashboard

Hi

I have recently noticed that my older orders are not being displayed on order tab of woocomerce. I can see only two rders of the current year 2024 but if you see below in the screenshot of my database, I have the orders from the previous years as well

Please find below the system status report:

WordPress Environment<br><br>WordPress address (URL): https://seisense.org<br>Site address (URL): https://seisense.org<br>WC Version: 9.1.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<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: – Server Environment<br><br>Server Info: LiteSpeed<br>PHP Version: 8.2.20<br>PHP Post Max Size: 512 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 5000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.3.39-MariaDB-cll-lve<br>Max Upload Size: 512 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.1.2<br>WC Database Prefix: wpfz_<br>Total Database Size: 14.75MB<br>Database Data Size: 11.54MB<br>Database Index Size: 3.21MB<br>wpfz_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_woocommerce_downloadable_product_permissions: Data: 0.06MB + Index: 0.13MB + Engine InnoDB<br>wpfz_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_woocommerce_order_itemmeta: Data: 0.17MB + Index: 0.17MB + Engine InnoDB<br>wpfz_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpfz_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpfz_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_actionscheduler_actions: Data: 0.38MB + Index: 0.27MB + Engine InnoDB<br>wpfz_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_actionscheduler_logs: Data: 0.28MB + Index: 0.14MB + Engine InnoDB<br>wpfz_aioseo_crawl_cleanup_blocked_args: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_aioseo_crawl_cleanup_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_aioseo_notifications: Data: 0.11MB + Index: 0.06MB + Engine InnoDB<br>wpfz_aioseo_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wpfz_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB<br>wpfz_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpfz_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_options: Data: 4.27MB + Index: 0.14MB + Engine InnoDB<br>wpfz_postmeta: Data: 2.52MB + Index: 0.23MB + Engine InnoDB<br>wpfz_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wpfz_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_revslider_sliders: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_sliders_bkp: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_slides: Data: 0.16MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_slides_bkp: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_usermeta: Data: 1.52MB + Index: 0.39MB + Engine InnoDB<br>wpfz_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wpfz_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wpfz_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wpfz_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wpfz_wc_download_log: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wpfz_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_wc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wpfz_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wpfz_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpfz_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpfz_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpfz_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpfz_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB Post Type Counts<br><br>attachment: 121<br>client: 5<br>nav_menu_item: 54<br>offer: 3<br>page: 14<br>post: 2<br>product: 7<br>product_variation: 21<br>shop_coupon: 1<br>shop_order: 2<br>slide: 1<br>template: 1<br>wpcf7_contact_form: 2<br>yaymail_template: 11 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (8)<br><br>All in One SEO: by All in One SEO Team – 4.6.6<br>Contact Form 7: by Takayuki Miyoshi – 5.9.7<br>Force Regenerate Thumbnails: by Exactly WWW – 2.1.4<br>Slider Revolution: by ThemePunch – 6.6.19<br>WooPayments: by WooCommerce – 7.9.1<br>WooCommerce: by Automattic – 9.1.2<br>WP-Optimize - Clean, Compress, Cache: by David Anderson<br>Ruhani Rabin<br>Team Updraft – 3.4.2<br><br>YayMail - WooCommerce Email Customizer: by YayCommerce – 3.5.3 Inactive Plugins (0) 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: 0<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<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: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 21 KB WC Pages<br><br>Shop base: #8 - /shop/<br>Cart: #9 - /cart/ - Contains the [woocommerce_cart] shortcode<br>Checkout: #10 - /checkout/ - Contains the [woocommerce_checkout] shortcode<br>My account: #11 - /my-account/<br>Terms and conditions: #377 - /terms-of-use/ Theme<br><br>Name: Betheme<br>Version: 27.5.2.1<br>Author URL: https://muffingroup.com/<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme<br>WooCommerce Support: ? 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: betheme/woocommerce/archive-product.php<br>betheme/woocommerce/cart/cart-totals.php<br>betheme/woocommerce/cart/cart.php<br>betheme/woocommerce/cart/cross-sells.php<br>betheme/woocommerce/cart/mini-cart.php<br>betheme/woocommerce/cart/proceed-to-checkout-button.php<br>betheme/woocommerce/checkout/form-checkout.php<br>betheme/woocommerce/content-product.php<br>betheme/woocommerce/content-single-product.php<br>betheme/woocommerce/global/form-login.php<br>betheme/woocommerce/loop/loop-end.php<br>betheme/woocommerce/loop/loop-start.php<br>betheme/woocommerce/loop/no-products-found.php<br>betheme/woocommerce/loop/pagination.php<br>betheme/woocommerce/myaccount/downloads.php<br>betheme/woocommerce/notices/error.php<br>betheme/woocommerce/notices/success.php<br>betheme/woocommerce/single-product/add-to-cart/external.php<br>betheme/woocommerce/single-product/meta.php<br>betheme/woocommerce/single-product/product-image.php<br>betheme/woocommerce/single-product/product-thumbnails.php<br>betheme/woocommerce/single-product/related.php<br>betheme/woocommerce/single-product/sale-flash.php<br>betheme/woocommerce/single-product/tabs/description.php<br>betheme/woocommerce/single-product/tabs/tabs.php<br>betheme/woocommerce/single-product/title.php<br>betheme/woocommerce/single-product/up-sells.php<br>betheme/woocommerce/single-product-reviews.php WooPayments<br><br>Version: 7.9.1<br>Connected to WPCOM: Yes<br>WPCOM Blog ID: 223657791<br>Account ID: acct_1Nraxd2HZhw92MHY<br>Payment Gateway: Enabled<br>Test Mode: Disabled<br>Enabled APMs: card<br>WooPay: Not eligible<br>Apple Pay / Google Pay: Enabled (cart,checkout)<br>Fraud Protection Level: basic<br>Multi-currency: Enabled<br>Auth and Capture: Enabled<br>Documents: Disabled<br>Logging: Disabled 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>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>printful<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-07-19 04:53:41 +03:00<br>Options: ?<br>Notes: 115<br>Onboarding: completed Action Scheduler<br><br>Complete: 134<br>Oldest: 2024-06-17 21:40:23 +0000<br>Newest: 2024-07-18 11:49:36 +0000<br><br>Failed: 659<br>Oldest: 2023-02-15 05:23:20 +0000<br>Newest: 2024-07-18 10:04:22 +0000<br><br>Pending: 4<br>Oldest: 2024-07-18 11:50:09 +0000<br>Newest: 2024-07-19 04:15:48 +0000 Status report information<br><br>Generated at: 2024-07-18 14:50:14 +03:00<br>

Looking forward to your support.

Thanks

The page I need help with: [log in to see the link]