Help Needed for WooCommerce Analytics

  • Resolved 22wpexpert

    (@22wpexpert)


    1 year, 10 months ago

    Hi

WooCommerce Analytics import stuck on “finalizing” https://prnt.sc/iNzs9xkNlXxt

For checking the confiction,I have deactivated all the plugins and used the WP default theme and cleared the analytics cache, Woocommerce and DB version is same but no luck.

Please help me on this:

WordPress Environment

WordPress address (URL): https://www.buysbest.co.uk/testsite
Site address (URL): https://www.buysbest.co.uk/testsite
WC Version: 7.6.1
REST API Version: ? 7.6.1
WC Blocks Version: ? 9.8.5
Action Scheduler Version: ? 3.5.4
Log Directory Writable: ?
WP Version: 6.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

Server Environment

Server Info: Apache/2.4.55 (Unix) OpenSSL/1.0.2k-fips
PHP Version: 7.4.33
PHP Post Max Size: 120 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.28-MariaDB
Max Upload Size: 12 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

Database

WC Database Version: 7.6.1
WC Database Prefix: wpstg0_
Total Database Size: 4028.58MB
Database Data Size: 2367.90MB
Database Index Size: 1660.68MB
wpstg0_woocommerce_sessions: Data: 32.56MB + Index: 1.52MB + Engine InnoDB
wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_order_items: Data: 12.52MB + Index: 3.52MB + Engine InnoDB
wpstg0_woocommerce_order_itemmeta: Data: 71.61MB + Index: 78.17MB + Engine InnoDB
wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_payment_tokenmeta: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_actions: Data: 76.63MB + Index: 40.14MB + Engine InnoDB
wpstg0_actionscheduler_claims: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
wpstg0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_logs: Data: 46.58MB + Index: 22.06MB + Engine InnoDB
wpstg0_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_ajaxsearchpro: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_ajaxsearchpro_priorities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_ajaxsearchpro_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_alm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_asp_index: Data: 48.61MB + Index: 103.44MB + Engine InnoDB
wpstg0_asp_synonyms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_bv_ip_store: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_comments: Data: 62.59MB + Index: 49.13MB + Engine InnoDB
wpstg0_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpstg0_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_litespeed_img_optm: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
wpstg0_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_newsletter: Data: 3.52MB + Index: 1.77MB + Engine InnoDB
wpstg0_newsletter_emails: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_newsletter_sent: Data: 9.52MB + Index: 10.03MB + Engine InnoDB
wpstg0_newsletter_stats: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wpstg0_newsletter_user_logs: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
wpstg0_options: Data: 26.44MB + Index: 1.34MB + Engine InnoDB
wpstg0_postmeta: Data: 375.39MB + Index: 211.55MB + Engine InnoDB
wpstg0_posts: Data: 51.56MB + Index: 17.06MB + Engine InnoDB
wpstg0_shopmagic_automation_outcome: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_shopmagic_automation_outcome_logs: Data: 7.52MB + Index: 0.28MB + Engine InnoDB
wpstg0_shopmagic_cart: Data: 4.52MB + Index: 1.47MB + Engine InnoDB
wpstg0_shopmagic_guest: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_shopmagic_guest_meta: Data: 37.56MB + Index: 16.52MB + Engine InnoDB
wpstg0_shopmagic_marketing_lists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_termmeta: Data: 0.50MB + Index: 0.59MB + Engine InnoDB
wpstg0_terms: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wpstg0_term_relationships: Data: 4.52MB + Index: 3.52MB + Engine InnoDB
wpstg0_term_taxonomy: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wpstg0_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_usermeta: Data: 70.14MB + Index: 64.20MB + Engine InnoDB
wpstg0_users: Data: 7.52MB + Index: 7.55MB + Engine InnoDB
wpstg0_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_category_lookup: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_customer_lookup: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_product_lookup: Data: 7.52MB + Index: 9.06MB + Engine InnoDB
wpstg0_wc_order_stats: Data: 5.52MB + Index: 5.55MB + Engine InnoDB
wpstg0_wc_order_tax_lookup: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wpstg0_wc_product_attributes_lookup: Data: 3.52MB + Index: 4.52MB + Engine InnoDB
wpstg0_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_product_meta_lookup: Data: 1.52MB + Index: 1.03MB + Engine InnoDB
wpstg0_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_reserved_stock: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
wpstg0_woocommerce_prl_deploymentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_prl_deployments: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_prl_frequencies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_prl_tracking_clicks: Data: 93.64MB + Index: 85.86MB + Engine InnoDB
wpstg0_woocommerce_prl_tracking_conversions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_woocommerce_prl_tracking_views: Data: 2.52MB + Index: 1.83MB + Engine InnoDB
wpstg0_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpstg0_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wpstg0_wps_index: Data: 3.52MB + Index: 6.55MB + Engine InnoDB
wpstg0_wps_key: Data: 0.34MB + Index: 0.30MB + Engine InnoDB
wpstg0_wps_object_term: Data: 4.52MB + Index: 12.09MB + Engine InnoDB
wpstg0_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpstg0_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_yoast_indexable: Data: 6.52MB + Index: 1.95MB + Engine InnoDB
wpstg0_yoast_indexable_hierarchy: Data: 0.30MB + Index: 0.39MB + Engine InnoDB
wpstg0_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_yoast_prominent_words: Data: 2.52MB + Index: 5.55MB + Engine InnoDB
wpstg0_yoast_seo_links: Data: 1.52MB + Index: 1.98MB + Engine InnoDB
wpstg0_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 80.61MB + Index: 39.08MB + Engine InnoDB
wp_actionscheduler_claims: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 53.58MB + Index: 23.06MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ajaxsearchpro: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ajaxsearchpro_priorities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ajaxsearchpro_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_alm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_asp_index: Data: 58.63MB + Index: 96.13MB + Engine InnoDB
wp_asp_synonyms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bv_ip_store: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 62.09MB + Index: 51.92MB + 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_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_img_optm: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter: Data: 3.52MB + Index: 1.75MB + Engine InnoDB
wp_newsletter_emails: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_sent: Data: 9.52MB + Index: 10.03MB + Engine InnoDB
wp_newsletter_stats: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_newsletter_user_logs: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 39.38MB + Index: 2.39MB + Engine InnoDB
wp_postmeta: Data: 448.81MB + Index: 279.50MB + Engine InnoDB
wp_posts: Data: 56.58MB + Index: 20.06MB + Engine InnoDB
wp_shopmagic_automation_outcome: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_automation_outcome_logs: Data: 7.52MB + Index: 0.28MB + Engine InnoDB
wp_shopmagic_cart: Data: 4.52MB + Index: 1.47MB + Engine InnoDB
wp_shopmagic_guest: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_guest_meta: Data: 37.56MB + Index: 16.52MB + Engine InnoDB
wp_shopmagic_marketing_lists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.50MB + Index: 0.59MB + Engine InnoDB
wp_terms: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_term_relationships: Data: 3.52MB + Index: 3.52MB + Engine InnoDB
wp_term_taxonomy: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 68.61MB + Index: 62.20MB + Engine InnoDB
wp_users: Data: 7.52MB + Index: 7.55MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 5.52MB + Index: 5.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 7.52MB + Index: 9.06MB + Engine InnoDB
wp_wc_order_stats: Data: 5.52MB + Index: 5.55MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 3.52MB + Index: 4.45MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 1.08MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.09MB + 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_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + 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_gpf_google_taxonomy: Data: 2.02MB + Index: 0.13MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 74.61MB + Index: 80.17MB + Engine InnoDB
wp_woocommerce_order_items: Data: 13.52MB + Index: 4.52MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_prl_deploymentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_prl_deployments: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_prl_frequencies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_prl_tracking_clicks: Data: 88.63MB + Index: 79.86MB + Engine InnoDB
wp_woocommerce_prl_tracking_conversions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_prl_tracking_views: Data: 2.52MB + Index: 1.83MB + Engine InnoDB
wp_woocommerce_sessions: Data: 38.02MB + Index: 12.02MB + Engine InnoDB
wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + 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_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rocket_cache: Data: 1.52MB + Index: 1.89MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wps_index: Data: 3.52MB + Index: 6.55MB + Engine InnoDB
wp_wps_key: Data: 0.34MB + Index: 0.30MB + Engine InnoDB
wp_wps_object_term: Data: 4.52MB + Index: 12.09MB + Engine InnoDB
wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_indexable: Data: 8.14MB + Index: 2.42MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 1.16MB + Index: 2.25MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 3.03MB + Index: 6.61MB + Engine InnoDB
wp_yoast_seo_links: Data: 2.52MB + Index: 2.67MB + Engine InnoDB
wp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

amp_validated_url: 2
attachment: 50000
custom_css: 1
custom-css-js: 6
fl-builder-template: 14
fl-theme-layout: 8
nav_menu_item: 277
oembed_cache: 558
page: 26
post: 8
postman_sent_mail: 250
prl_engine: 1
product: 5983
product_variation: 6
revision: 10
seedprod: 1
shop_coupon: 7
shop_order: 33851
shop_order_refund: 1815
shopmagic_automation: 1
woocarousel: 1
woocarouselpro: 6
wp_block: 1
wp_global_styles: 1
wp_navigation: 1

Security

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

Active Plugins (2)

WooCommerce: by Automattic – 7.6.1
Backup Duplicator & Migration - WP STAGING: by WP-STAGING
WPStagingBackup – 2.13.0

Inactive Plugins (57)

Ajax Search Pro: by Ernest Marcinko – 4.23.2
Async JavaScript: by Frank Goossens (futtta) – 2.21.08.31
Auto Login New User After Registration: by Jeff Sherk – 1.9.6
Beaver Builder Plugin (Pro Version): by The Beaver Builder Team – 2.6.3.3
Beaver Themer: by The Beaver Builder Team – 1.4.5.1
Beaver Tunnels: by FireTree Design
LLC [email protected] – 2.1.6

CloudCommercePro Connector: by Cloud Commerce Pro – 1.2.3
Custom Product Stickers for Woocommerce: by starblank.com – 1.9.0
Database Management tool - Adminer: by Pexle Chris – 2.1.0
Facebook for WooCommerce: by Facebook – 3.0.19
Gift Up!: by Gift Up! – 2.19.2
HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 10.1.16
Imagify: by Imagify – Optimize Images & Convert WebP – 2.1.1
Kadence WooCommerce Email Designer: by Kadence WP – 1.5.10
Max Mega Menu: by megamenu.com – 3.2.1
Max Mega Menu - Pro Addon: by Tom Hemsley – 1.6.5
Multi-Step Checkout for WooCommerce (Pro): by ThemeHigh – 2.1.0
Newsletter: by Stefano Lissa & The Newsletter Team – 7.6.9
Newsletter - Addons Manager: by The Newsletter Team – 1.2.0
Newsletter - SMTP Addon: by The Newsletter Team – 1.0.6
Post SMTP: by Post SMTP – 2.4.8
Product Feed PRO for WooCommerce: by AdTribes.io – 12.5.4
Query Monitor: by John Blackbourn – 3.12.1
Redis Object Cache: by Till Krüss – 2.3.0
Simple Custom CSS and JS: by SilkyPress.com – 3.43
Smart WooCommerce Search: by YummyWP – 2.5.0
StoreCustomizer: by Kaira – 2.5.0
Term Management Tools: by theMikeD
scribu – 2.0.1

Trustpilot-reviews: by Trustpilot – 2.5.914
Ultimate Addons for Beaver Builder: by Brainstorm Force – 1.35.4
Ultimate FAQ - WordPress FAQ and Accordion Plugin: by – 2.2.6
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.23.3

WooCommerce Additional Variation Images: by WooCommerce – 1.7.19
Woocommerce Advanced Bulk Edit: by George Iron – 3.9.2
WooCommerce Google Ads Dynamic Remarketing: by SweetCode – 1.8.2
WooCommerce Google Analytics Integration: by WooCommerce – 1.7.1
WooCommerce Google Product Feed: by Ademti Software Ltd. – 10.8.2
WooCommerce Min/Max Quantities: by WooCommerce – 2.4.15
WooCommerce PayPal Payments: by WooCommerce – 1.9.3 (update to version 2.0.4 is available)
WooCommerce Product Carousel Slider Pro: by Aazztech – 3.4.0
WooCommerce Product CSV Import Suite: by Automattic – 1.10.11
WooCommerce Product Recommendations: by SomewhereWarm – 1.4.13
WooCommerce Side Cart Premium: by XootiX – 1.0.0
WooCommerce Stripe Gateway: by WooCommerce – 7.3.0
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.12
WooCommerce Tab Manager: by SkyVerge – 1.10.1
WooCommerce Waitlist: by Neil Pie – 2.2.4
WooPack for Beaver Builder: by Team IdeaBox - Beaver Addons – 1.3.4.3
WP Add Mime Types: by Kimiya Kitani – 3.0.3
WP Bulk Delete: by Xylus Themes – 1.2.4
WP File Manager: by mndpsingh287 – 7.1.8
WP Rocket: by WP Media – 3.12.6.1
WP Rollback: by GiveWP.com – 1.7.3
YITH Infinite Scrolling: by YITH – 1.10.0
Yoast SEO: by Team Yoast – 20.6
Yoast SEO: Search index purge: by Team Yoast – 1.1.0
Yoast SEO Premium: by Team Yoast – 20.6

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

Settings

API Enabled: ?
Force SSL: –
Currency: GBP (￡)
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: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #23942 - /?page_id=23942
Basket: #23943 - /?page_id=23943
Checkout: #71665 - /?page_id=71665
My account: #23945 - /?page_id=23945
Terms and conditions: ? Page not set

Theme

Name: Twenty Twenty-Three
Version: 1.1
Author URL: https://en-gb.www.ads-software.com
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

WooCommerce Support: ?

Templates

Overrides: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
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: block-editor-feature-enabled
minified-js
new-product-management-experience
product-variation-management
settings

Daily Cron: ? Next scheduled: 2023-04-29 10:09:53 +01:00
Options: ?
Notes: 140
Onboarding: completed

Action Scheduler

Canceled: 1
Oldest: 2023-04-28 13:39:33 +0100
Newest: 2023-04-28 13:39:33 +0100

Complete: 30,532
Oldest: 2023-03-29 08:35:30 +0100
Newest: 2023-04-29 08:15:49 +0100

Failed: 134,936
Oldest: 2023-02-01 06:44:48 +0000
Newest: 2023-04-28 17:37:21 +0100

Pending: 2
Oldest: 2023-04-29 10:51:49 +0100
Newest: 2023-04-29 18:04:27 +0100

Status report information

Generated at: 2023-04-29 08:24:39 +01:00
`

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

Viewing 15 replies - 1 through 15 (of 16 total)

  • Hi @22wpexpert

    Thanks for reaching out!

    I understand that importing historical data on your site gets stuck in finalizing status. Furthermore, you’ve already deactivated all plugins, switched to the default theme, and cleared the analytics cache, however, the issue still persists, correct?

    Checking your site’s SSR, I am not seeing anything suspicious. If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Thanks!

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @xue28

    Yes, you understand the issue.
    There is no error in logs https://prnt.sc/iX7MpScUZj7H

    If I am testing with older version of WooCommerce then It’s working fine.

    Hi @22wpexpert

    Thanks for sharing further information here.

    Can you please try to follow the steps below and see if this works?

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @xue28

    I have activated storefront theme and only WooCommerce plugin activated but still the same issue.

    Hi @22wpexpert ,

    Failed: 134,936
Oldest: 2023-02-01 06:44:48 +0000
Newest: 2023-04-28 17:37:21 +0100

Pending: 2
Oldest: 2023-04-29 10:51:49 +0100
Newest: 2023-04-29 18:04:27 +0100

    As per your SSR, I am able to see that you have a lot of failed actions, and 2 pending actions as recent as 29 April 2023.

    WooCommerce uses a system called?WP-CRON?that runs automated actions inside WordPress. There may be times when it doesn’t work as expected, and they are stuck in a pending state.

    I would recommend installing the?WP Crontrol?plugin to see if there are any errors.

    For more information on this, you can read our support guide on Debugging WP-Cron.

    Additionally, can you please go to Tools → Scheduled Actions, then go to the Pending tab and send us a screenshot of that page?

    You can use?https://snipboard.io?to send us a screenshot link.

    Cheers!

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @beautyofcode

    Both cron executed fine:
    wc-admin_import_batch_init_orders
    wc-admin_import_batch_init_customers

    2 pending crons screenshot: https://prnt.sc/4GIkZgojlzCQ

    And I have installed WP Crontrol?plugin It’s not showing any error for those 2 crons.

    https://prnt.sc/YJKD9G1kEkEt

    • This reply was modified 1 year, 10 months ago by 22wpexpert.
    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi?@beautyofcode

    Can you please help on this. It’s very urgent.

    Hi,

    Sorry to hear about the issue.

    I understand importing the historical data remains stuck.

    Can you head to WooCommerce > status > scheduled actions > pending, and try to manually run the pending actions? Or to delete them so that new pending actions can run?

    If that does not help, please try to reproduce the issue again and check your browser developer Console, do a right-click on the page or press F12 on the keyboard and select “Inspect” (this option will show up on most browsers). In the developer tools that will pop up, you should see a “Console” tab. From there, please send us a screenshot of what’s being displayed using a tool like https://snipboard.io/.

    Thanks.

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @ihereira 

I have removed all the Failed and completed scheduled actions and cancel the pending schedules.

There is a action "woocommerce_cleanup_draft_orders" that can't be cancel or delete.

For importing the historic data these 2 actions works:

wc-admin_import_batch_init_orders
wc-admin_import_batch_init_customers

Both actions completed successfully (Screenshot: https://prnt.sc/d--t4KOrgXtf ). But the import still stuck on "finalizing".

I have checked developer console there are some warning and errors (screenshot: https://prnt.sc/pcxH78_yLiIl ? https://prnt.sc/AbEqcQGvvjtm)

Console warnings:

blocks.min.js?ver=63…14271099dc3d85bf:10 The block "woocommerce/product-section" is registered with an invalid category "woocommerce".

blocks.min.js?ver=63…14271099dc3d85bf:10 The block "woocommerce/product-tab" is registered with an invalid category "woocommerce".

deprecated.min.js?ve…63cb9494ba26b77eb:2 position prop in wp.components.Dropdown is deprecated since version 6.2. Please use popoverProps.placement prop instead. Note: Note that the position prop will override any values passed through the popoverProps.placement prop.

Console errors:

Bocks.min.js?ver=639e14271099dc3d85bf:3 Block "core/paragraph" is already registered.

? ? ? ? ne @ blocks.min.js?ver=639e14271099dc3d85bf:3

? ? ? ? je @ block-library.min.js?ver=3115f0b5551a55bb6d3b:12

? ? ? ? Uh @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? SE @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

blocks.min.js?ver=639e14271099dc3d85bf:3 Block "core/image" is already registered.

? ? ? ? ne @ blocks.min.js?ver=639e14271099dc3d85bf:3

? ? ? ? je @ block-library.min.js?ver=3115f0b5551a55bb6d3b:12

? ? ? ? Xu @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? SE @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

blocks.min.js?ver=639e14271099dc3d85bf:3 Block "core/heading" is already registered.

? ? ? ? ne @ blocks.min.js?ver=639e14271099dc3d85bf:3

? ? ? ? je @ block-library.min.js?ver=3115f0b5551a55bb6d3b:12

? ? ? ? yu @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? SE @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

blocks.min.js?ver=639e14271099dc3d85bf:3 Block "core/list" is already registered.

? ? ? ? ne @ blocks.min.js?ver=639e14271099dc3d85bf:3

? ? ? ? je @ block-library.min.js?ver=3115f0b5551a55bb6d3b:12

? ? ? ? Fm @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? SE @ block-library.min.js?ver=3115f0b5551a55bb6d3b:14

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2

? ? ? ? (anonymous) @ index.js?ver=7.6.1:2
    Saif

    (@babylon1999)

    Hello @22wpexpert,

    Thank you for sharing all this information. However, I’m afraid these errors are not related to the issue.

    I noticed that your PHP time limit is set to 120. The time limit is a setting that determines how long a PHP script can run before it is terminated by the server. Usually, when the time limit is exhausted, an error should be thrown. Although that’s not the case on your site, I suggest increasing it to at least 500 seconds just to make sure that’s not the case. You can contact your hosting provider to help you with this. :?)

    Let us know how it goes!

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @babylon1999

    I have updated the PHP time limit from cPanel. But still, the issue is same.
    Screenshot: https://prnt.sc/mE1dD6ndoRkk


    Saif

    (@babylon1999)

    I have updated the PHP time limit from cPanel. But still, the issue is same.
    Screenshot: https://prnt.sc/mE1dD6ndoRkk

    I understand your frustration at this point. I have checked similar threads and found that two merchants reported success after changing the wc-update-db-reminder in wc_admin_notes table to actioned. I suggest you try the same.

    Furthermore, if something is not working then an error has to be dropped somewhere. Can you please check if the Query Monitor plugin is detecting anything?

    Also, please ask your hosting provider if there are any server-side errors.


    Let us know how it goes!

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @babylon1999

    Thanks for taking this issue seriously.

    I have updated ‘wc-update-db-reminder’ status “actioned” and ?installed Query Monitor plugin It’s not showing any PHP error screenshot attached.

    Still the historical data stuck in Finalising stage.

    https://prnt.sc/DxiYSV4EB3eQ
    https://prnt.sc/ifntT0gxCNI-

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @babylon1999

    There are some errors provided by hosting provider.

    https://prnt.sc/WGOZvkCSlXT2
    https://prnt.sc/2Bryr6CfQMT_

    [Wed May 10 11:25:35.142912 2023] [proxy_fcgi:error] [pid 76375:tid 139828330936064] [client 213.171.210.191:44134] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘date_paid’ in ‘field list’ for query REPLACE INTO wp_wc_order_stats (order_id, parent_id, date_created, date_paid, date_completed, date_created_gmt, num_items_sold, total_sales, tax_total, shipping_total, net_total, status, customer_id, returning_customer) VALUES (658821, 0, ‘2023-05-09 19:15:12’, ‘2023-05-09 19:15:21’, ‘2023-05-10 12:25:08’, ‘2023-05-09 18:15:12’, 2, 30.270000, 4.380000, 3.990000, 21.900000, ‘wc-completed’, 51847, 0) made by do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘wc-admin_import_orders’), WP_Hook->do…

    Thread Starter 22wpexpert

    (@22wpexpert)

    Hi @babylon1999

    This issue is fixed now, thanks for your help.

    The issue was “date_paid” and “date_completed” column missing from ‘xx_wc_order_stats‘ table.

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Help Needed for WooCommerce Analytics’ is closed to new replies.