Woocommerce Analytics is not working

Hi Team,

We have migrated the Woocommerce site to a new server. we have imported all the products, users, and orders. Now we have faced the issue on the woocommerce analytics. the data did not load.

So we have cleared the historical cache from woocommerce Tools. then we had to import the historical import from the analytics setting as per the documentation. It takes more time for 10 orders but not imported.

We tried to downgrade the woocommerce plugin to 8.8.3 from 8.8.5. But it’s working for us. so please let me know the solution to fix this issue.

Please refer to the woocommerce status

WordPress Environment

WordPress address (URL): https://mysite.com.au
Site address (URL): https://mysite.com.au
WC Version: 8.8.3
REST API Version: ? 8.8.3
Action Scheduler Version: ? 3.7.4
Log Directory Writable: ?
WP Version: 6.5.5
WP Multisite: –
WP Memory Limit: 4 GB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: – Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 2 GB
PHP Time Limit: 9000
PHP Max Input Vars: 1000
cURL Version: 8.7.1
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 5.7.44
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.5.2
WC Database Prefix: wp_
Total Database Size: 515.16MB
Database Data Size: 410.59MB
Database Index Size: 104.57MB
wp_woocommerce_sessions: Data: 67.11MB + Index: 4.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 2.48MB + Index: 2.50MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 6.52MB + Index: 12.55MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_cartflows_ca_cart_abandonment: Data: 1.52MB + Index: 0.05MB + Engine InnoDB
wp_cartflows_ca_email_history: Data: 0.19MB + Index: 0.23MB + Engine InnoDB
wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.05MB + Index: 0.58MB + Engine InnoDB
wp_cr_local_forms: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_cr_reminders_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_noptin_automation_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_noptin_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_noptin_subscriber_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_noptin_tasks: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_options: Data: 60.08MB + Index: 1.48MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.27MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 74.55MB + Index: 16.06MB + Engine InnoDB
wp_posts: Data: 124.22MB + Index: 2.42MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides: Data: 0.36MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_termmeta: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.27MB + Index: 0.16MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_trustindex_google_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 0.39MB + Index: 0.31MB + Engine InnoDB
wp_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_wacv_abandoned_cart_record: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wacv_cart_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wacv_email_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wacv_guest_info_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_orders: Data: 0.20MB + Index: 0.14MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.52MB + Index: 3.02MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.41MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_above_the_fold: Data: 0.31MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rocket_cache: Data: 0.14MB + Index: 0.19MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.38MB + Index: 0.63MB + Engine InnoDB
wp_wsal_metadata: Data: 32.56MB + Index: 44.94MB + Engine InnoDB
wp_wsal_occurrences: Data: 27.56MB + Index: 8.03MB + Engine InnoDB
wp_wt_iew_action_history: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 1.50MB + Index: 0.58MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.48MB + Index: 0.33MB + Engine InnoDB
wp_zip_tokenisation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB Post Type Counts

acf-field: 1
acf-field-group: 1
attachment: 3382
cms_block: 7
custom_css: 1
custom-css-js: 7
customize_changeset: 2
elementor_font: 18
elementor_library: 15
elementor_snippet: 5
mc4wp-form: 1
nav_menu_item: 42
page: 17
post: 22
product: 1046
product_variation: 653
revision: 4217
shop_coupon: 61
shop_order_placehold: 488
wacv_email_template: 4
wc_afrsm: 10
wc_afrsm_zone: 1
woodmart_layout: 1
woodmart_sidebar: 1
woodmart_size_guide: 1
woodmart_slide: 3
wp_navigation: 1
yith_wcan_preset: 3 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ?Error messages should not be shown to visitors. Active Plugins (46)

Pixel Manager for WooCommerce: by SweetCode – 1.43.0
Action Scheduler – Disable Default Queue Runner: by Prospress Inc. – 1.0.0
Advanced Custom Fields PRO: by WP Engine – 6.3.0.1
Afterpay Gateway for WooCommerce: by Afterpay – 3.8.5
Bulk Meta Editor: by Aries Dajay – 1.0.1
Buy one get one free: by PI Websolution – 1.10.47
Customer Reviews for WooCommerce: by CusRev – 5.49.3
Duplicate Page: by mndpsingh287 – 4.5.3
GTM4WP – A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20.2
Elementor Form Validation: by MetaWeb – 2.0.0
Elementor Pro: by Elementor.com – 3.21.3
Elementor: by Elementor.com – 3.21.8
Facebook for WooCommerce: by Facebook – 3.2.3
Hide Admin Notices: by PontetLabs – 2.1
humm for WooCommerce: by humm – 3.1.3
Imagify: by Imagify – Optimize Images & Convert WebP & Avif – 2.2.2
Jetpack: by Automattic – 13.4.3
Klaviyo: by Klaviyo
Inc. – 3.3.5

MainWP Child: by MainWP – 5.0.1.1
Noptin – WordPress Newsletter Plugin: by Noptin Newsletter – 3.4.0
Pinterest for WooCommerce: by WooCommerce – 1.3.24
Product page Delivery calculator for WooCommerce: by PI Websolution – 1.3.49.12
Slider Revolution: by ThemePunch – 6.6.20
Safe SVG: by 10up – 2.2.4
Auto Coupons for WooCommerce: by RLDD – 3.0.15
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.27
Advanced Flat Rate Delivery For WooCommerce: by theDotstore – 4.2.5
Notification for WooCommerce: by Andy Ha (villatheme.com) – 1.2.17
Product Feed PRO for WooCommerce: by AdTribes.io – 13.3.2
WooCommerce Notification Premium: by Andy Ha (villatheme.com) – 1.5.1
WooCommerce PayPal Payments: by WooCommerce – 2.7.1 (update to version 2.8.1 is available)
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.2
WooCommerce Delivery & Tax: by WooCommerce – 2.5.7 (update to version 2.6.0 is available)
WooCommerce: by Automattic – 8.8.3 (update to version 9.0.2 is available)
Woodmart Core: by – 1.0.42
Yoast SEO: by Team Yoast – 22.8
WP All Export Pro: by Soflyy – 1.8.8
WP Mail SMTP: by WP Mail SMTP – 4.0.1
Widgets for Google Reviews: by Trustindex.io – 11.8.4
WP Rocket: by WP Media – 3.16
WP Rollback: by WP Rollback – 2.0.7
WP Activity Log: by Melapress – 5.0.0
WP All Export – WooCommerce Export Add-On Pro: by Soflyy – 1.0.9
Sequential Order Numbers for WooCommerce: by WebToffee – 1.6.2
YITH WooCommerce Ajax Product Filter: by YITH – 5.1.0
Zip – WooCommerce: by Zip – 2.3.18 Inactive Plugins (0) Dropin Plugins ()

advanced-cache.php: advanced-cache.php Must Use Plugins (1)

Elementor Safe Mode: by Elementor.com – 1.0.0 Settings

API Enabled: –
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: 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 screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: – Logging

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 267 KB WC Pages

Shop base: #47 – /shop/
Cart: #9 – /cart/
Checkout: #10 – /checkout/
My account: #11 – /my-account/
Terms and conditions: ? Page not set Theme

Name: Woodmart Child
Version: 1.0.0
Author URL: https://xtemos.com
Child Theme: ?
Parent Theme Name: Woodmart
Parent Theme Version: 7.4.3
Parent Theme Author URL: https://themeforest.net/user/xtemos
WooCommerce Support: ? Templates

Overrides: woodmart/woocommerce/archive-product.php version 3.4.0 is out of date. The core version is 8.6.0
woodmart/woocommerce/cart/cart-item-data.php
woodmart/woocommerce/cart/cart.php
woodmart/woocommerce/cart/cross-sells.php
woodmart-child/woocommerce/cart/mini-cart.php
woodmart/woocommerce/checkout/form-checkout.php
woodmart/woocommerce/checkout/thankyou.php
woodmart/woocommerce/content-product-cat.php
woodmart/woocommerce/content-product.php
woodmart/woocommerce/content-single-product.php
woodmart/woocommerce/content-widget-product.php
woodmart/woocommerce/global/breadcrumb.php
woodmart/woocommerce/global/form-login.php
woodmart/woocommerce/global/quantity-input.php
woodmart/woocommerce/loop/add-to-cart.php
woodmart/woocommerce/loop/loop-end.php
woodmart/woocommerce/loop/loop-start.php
woodmart/woocommerce/loop/no-products-found.php
woodmart/woocommerce/loop/orderby.php
woodmart/woocommerce/loop/pagination.php
woodmart/woocommerce/loop/sale-flash.php
woodmart/woocommerce/myaccount/form-login.php
woodmart/woocommerce/product-searchform.php
woodmart/woocommerce/single-product/add-to-cart/grouped.php
woodmart/woocommerce/single-product/add-to-cart/variable.php
woodmart/woocommerce/single-product/meta.php
woodmart/woocommerce/single-product/product-attributes.php
woodmart-child/woocommerce/single-product/product-image.php
woodmart/woocommerce/single-product/product-thumbnails.php
woodmart-child/woocommerce/single-product/rating.php
woodmart/woocommerce/single-product/related.php
woodmart/woocommerce/single-product/sale-flash.php
woodmart/woocommerce/single-product/tabs/description.php
woodmart/woocommerce/single-product/tabs/tabs.php
woodmart/woocommerce/single-product/title.php
woodmart/woocommerce/single-product/up-sells.php
woodmart-child/woocommerce/single-product-reviews.php
woodmart/woocommerce/single-product.php

Outdated Templates: ?

                    Learn how to update

WooCommerce PayPal Payments

Onboarded: ?
Shop country code: AU
WooCommerce currency supported: ?
Advanced Card Processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: ?
PayPal Vault enabled: –
ACDC Vault enabled: –
Logging enabled: –
Reference Transactions: ?
Used PayPal Checkout plugin: –
Subscriptions Mode: Disabled Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
product-pre-publish-modal
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
product-custom-fields
settings
async-product-editor-category-field
launch-your-store

Daily Cron: ? Next scheduled: 2024-07-03 04:05:24 +10:00
Options: ?
Notes: 86
Onboarding: – Action Scheduler

Complete: 6,564
Oldest: 2024-04-15 12:08:56 +1000
Newest: 2024-07-02 15:27:43 +1000

Pending: 25,327
Oldest: 2024-05-15 22:25:55 +1000
Newest: 2024-07-02 18:30:13 +1000

Failed: 24
Oldest: 2024-02-13 15:07:34 +1100
Newest: 2024-05-15 21:45:16 +1000

Canceled: 1,415
Oldest: 2024-05-15 22:33:51 +1000
Newest: -0001-11-30 10:04:52 +1004 Status report information

Generated at: 2024-07-02 19:22:55 +10:00