• Resolved mhawkins93

    (@mhawkins93)


    Hello. Our Analytics has not been displaying any revenue for this year or last year in WooCommerce (even though we have orders). I have followed the steps posted in other forums (clearing the analytics cache, restarting the import, etc.) and nothing has worked. Our import is frozen at 0 and has been all month. We have no new plug-ins or theme changes that would conflict. Can you please help us figure out how to get this to work?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hi @mhawkins93,

    Thank you for reaching out.

    I understand you’re having trouble with WooCommerce analytics not working as expected, and you’ve tried several steps, but the issue persists.

    As a next step, please check under?WooCommerce > Status > Scheduled Actions?to see if there are any stuck processes preventing the updated information from importing.

    In the meantime, can you navigate to?Analytics →? Settings, scroll to?Actionable Statuses?and then check that?Completed?is checked:

    Let us know how this goes.

    Thread Starter mhawkins93

    (@mhawkins93)

    Hi! Everything I’m seeing under Scheduled Actions says Complete. We have quite a few pages though, how many should I go through?

    As for Actionable Statuses, only Completed is checked. Should the others be checked as well?

    Thanks,

    Morgan

    Hi! Everything I’m seeing under Scheduled Actions says Complete.

    Thanks for confirming this for us @mhawkins93.

    We have quite a few pages though, how many should I go through?

    Could you please clarify on the pages you’re referring to here?

    only Completed is checked. Should the others be checked as well?

    Please try having the rest checked as well and see if this yields any different results.

    Thread Starter mhawkins93

    (@mhawkins93)

    We have quite a few pages of Scheduled Actions.

    I have checked all the actionable statuses, stopped the import, and restarted and it is still stuck at 0.

    Plugin Support RK a11n

    (@riaanknoetze)

    Hey there,

    Thanks for helping with the troubleshooting so far – that’s really appreciated. Based on the answers here, I want to ask a few followup questions:

    • Is your store set to use High Performance Order Storage (HPOS)? You can verify that under WooCommerce > Settings > Advanced > Features (Analytics should work with either option but I just wanted to verify as it changes the underlying database structure on how orders are saved)
    • Can you share a copy of your status report as found under WooCommerce > Status?
    • Regarding the Scheduled Actions, you’ll have a submenu that looks something like this. Are you seeing any actions under Pending or Failed. Can you take screenshots of these?
    • Are you seeing any recent fatal error logs as found under WooCommerce > System Status > Logs?

    Thanks!

    Thread Starter mhawkins93

    (@mhawkins93)

    Hello!

    We are not using HPOS, we are using the WordPress posts storage. It appears HPOS is not compatible with some of our plug-ins.

    Here is our status report (apologies, I didn’t see a way to attach it to this post).

    ` WordPress Environment</p> <p>WordPress address (URL): https://alor.com<br>Site address (URL): https://alor.com<br>WC Version: 9.0.2<br>Legacy REST API Package Version: ? 1.0.4<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: ? 6.5.5 – There is a newer version of WordPress available (6.6.1)<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: – Server Environment</p> <p>Server Info: Apache<br>PHP Version: 8.2.19<br>PHP Post Max Size: 100 MB<br>PHP Time Limit: 3600<br>PHP Max Input Vars: 10000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2</p> <p>SUHOSIN Installed: –<br>MySQL Version: 8.0.36-28<br>Max Upload Size: 50 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</p> <p>WC Database Version: 9.0.2<br>WC Database Prefix: wp_<br>Total Database Size: 968.34MB<br>Database Data Size: 586.43MB<br>Database Index Size: 381.91MB<br>wp_woocommerce_sessions: Data: 77.63MB + Index: 5.03MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 2.52MB + Index: 0.50MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 22.55MB + Index: 17.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>hw_wpsm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 3.02MB + Index: 4.11MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 1.02MB + Index: 2.11MB + Engine InnoDB<br>wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_connections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_affiliate_wp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_creativemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_custom_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_affiliate_wp_notifications: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_affiliate_wp_referrals: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_sales: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_affiliate_wp_visits: Data: 1.52MB + Index: 0.38MB + Engine InnoDB<br>wp_application_passwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_bulkgate_module: Data: 0.06MB + Index: 0.00MB + 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: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_comments: Data: 7.52MB + Index: 15.61MB + Engine InnoDB<br>wp_db7_forms: Data: 10.52MB + Index: 0.00MB + Engine InnoDB<br>wp_eh_ab_cart_details: Data: 0.33MB + Index: 0.00MB + Engine InnoDB<br>wp_eh_ab_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_eh_ab_log_table: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_image_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_post_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_posts: Data: 0.25MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_snapshots: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_streams: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ffi_streams_sources: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_jckpc_inventory: Data: 0.31MB + Index: 0.00MB + Engine InnoDB<br>wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mainwp_stream: Data: 1.52MB + Index: 1.36MB + Engine InnoDB<br>wp_mainwp_stream_meta: Data: 3.52MB + Index: 6.55MB + Engine InnoDB<br>wp_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_nextend2_image_storage: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_nextend2_section_storage: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nextend2_smartslider3_sliders: Data: 0.13MB + Index: 0.03MB + Engine InnoDB<br>wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_nextend2_smartslider3_slides: Data: 0.13MB + Index: 0.11MB + Engine InnoDB<br>wp_options: Data: 22.06MB + Index: 2.53MB + Engine InnoDB<br>wp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_pimwick_gift_card_activity: Data: 0.06MB + Index: 0.02MB + 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_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_hash: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_images: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_imports: Data: 0.45MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_posts: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxi_templates: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 159.00MB + Index: 275.70MB + Engine InnoDB<br>wp_posts: Data: 14.52MB + Index: 14.06MB + Engine InnoDB<br>wp_ppress_coupons: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_ppress_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ppress_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ppress_formsmeta: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_ppress_meta_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ppress_ordermeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ppress_orders: Data: 0.02MB + Index: 0.13MB + Engine InnoDB<br>wp_ppress_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ppress_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ppress_subscriptions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_redirection_404: Data: 6.52MB + Index: 2.27MB + Engine InnoDB<br>wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_redirection_items: Data: 0.05MB + Index: 0.09MB + Engine InnoDB<br>wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_revslider_css: Data: 0.16MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_css_bkp: Data: 0.16MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_sliders: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_sliders_bkp: Data: 0.22MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_slides: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_slides_bkp: Data: 0.45MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_splitit_logs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_term_relationships: Data: 2.52MB + Index: 2.52MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_termmeta: Data: 1.52MB + Index: 1.38MB + Engine InnoDB<br>wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_usermeta: Data: 4.52MB + Index: 13.55MB + Engine InnoDB<br>wp_users: Data: 0.20MB + Index: 0.27MB + Engine InnoDB<br>wp_w3tc_cdn_pathmap: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_w3tc_cdn_queue: Data: 0.02MB + Index: 0.02MB + 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.23MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.34MB + Index: 0.25MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.80MB + Engine InnoDB<br>wp_wc_order_stats: Data: 1.52MB + Index: 0.47MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.31MB + Index: 0.28MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 2.52MB + Index: 4.80MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 3.52MB + Index: 0.03MB + 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: 116.72MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 0.39MB + Index: 0.08MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 85.61MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 0.47MB + Index: 0.16MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<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_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 1.52MB + Index: 0.39MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwafconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_exported_csv_items: Data: 0.52MB + Index: 0.08MB + Engine InnoDB<br>wp_woocommerce_gc_activity: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cards: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cardsmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.13MB + Engine InnoDB<br>wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_sc_coupon_lookup: Data: 2.52MB + Index: 0.66MB + Engine InnoDB<br>wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_indexable: Data: 2.52MB + Index: 1.19MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.19MB + Index: 0.28MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.16MB + Index: 0.17MB + Engine InnoDB<br>wp_yoast_prominent_words: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 1.52MB + Index: 0.61MB + Engine InnoDB<br>wp_yoast_seo_meta: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>wp_ywdpd_exclusion_list_table: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts</p> <p>acf-field: 6<br>acf-field-group: 1<br>addify_rfq: 1<br>afreg_fields: 1<br>aoc_popup: 1<br>attachment: 13732<br>b2bking_custom_field: 10<br>b2bking_custom_role: 4<br>b2bking_group: 1<br>b2bking_offer: 4<br>b2bking_rule: 1<br>cookielawinfo: 6<br>csp_rules: 2<br>custom_css: 1<br>custom-css-js: 1<br>customize_changeset: 8<br>def_reg_fields: 10<br>jetpack_migration: 2<br>mc4wp-form: 1<br>mts_notification_bar: 1<br>nav_menu_item: 176<br>o-discount: 29<br>o-list: 11<br>oembed_cache: 13<br>page: 123<br>portfolio: 12<br>post: 88<br>product: 3003<br>product_variation: 8940<br>pw_bogo: 6<br>pw_gift_rule: 2<br>revision: 125<br>shop_bogof_rule: 4<br>shop_coupon: 14725<br>shop_order: 5169<br>shop_order_refund: 438<br>size-chart: 12<br>wapf_product: 1<br>wp_block: 2<br>wp_global_styles: 1<br>wpcf7_contact_form: 4<br>wpcode: 4<br>ywdpd_discount: 1 Security</p> <p>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (69)</p> <p>Advanced Cron Manager: by BracketSpace – 2.5.10<br>Advanced Custom Fields PRO: by WP Engine – 6.3.3<br>AffiliateWP: by AffiliateWP – 2.25.3<br>AffiliateWP – Affiliate Area Shortcodes: by AffiliateWP – 1.3.1<br>AffiliateWP – Affiliate Area Tabs: by AffiliateWP – 1.4.1<br>AffiliateWP – Affiliate Dashboard Sharing: by Sandhills Development<br>LLC – 1.3</p> <p>AffiliateWP – Affiliate Info: by Sandhills Development<br>LLC – 1.2</p> <p>WP Engine Smart Plugin Manager: by WP Engine – 5.18.0<br>Caxton: by PootlePress – 1.30.1<br>Contact Form 7 Captcha: by 247wd – 0.1.6<br>Contact Form 7: by Takayuki Miyoshi – 5.9.8<br>Contact Form CFDB7: by Arshid – 1.2.7<br>CookieYes | GDPR Cookie Consent: by CookieYes – 3.2.6<br>WooCommerce Coupon Generator: by Jeroen Sormani – 1.2.0<br>Simple Custom CSS and JS: by SilkyPress.com – 3.47<br>Duplicate Page: by mndpsingh287 – 4.5.4<br>GTM4WP – A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20.2<br>ELEX Bulk Edit Products, Prices & Attributes for Woocommerce: by ELEXtensions – 2.7.2<br>EqualWeb: by Equalweb Accessibility – 1.0<br>Facebook for WooCommerce: by Facebook – 3.2.4<br>WP Standard Post: by WordPress – 3.5<br>WooCommerce HookMeUp: by Get Bowtied – 2.5.1<br>WooCommerce Product Configurator by Iconic: by Iconic – 1.23.0<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.4.18</p> <p>Index WP Users For Speed: by Oliver Jones – 1.1.6<br>WPCode Lite: by WPCode – 2.1.14<br>WPBakery Page Builder: by Michael M – WPBakery.com – 7.2<br>Klaviyo: by Klaviyo<br>Inc. – 3.3.5</p> <p>MainWP Child Reports: by MainWP – 2.2<br>MainWP Child: by MainWP – 5.1.1<br>Smart Slider 3 Pro: by Nextend – 3.5.1.23<br>PixelYourSite: by PixelYourSite – 9.7.0.1<br>Product XML Feeds for WooCommerce Pro: by Algoritmika Ltd – 1.5.4<br>Redirection: by John Godley – 5.4.2<br>Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6<br>SafeOpt Tags: by Addshoppers – 1.0.0<br>Storefront Pro Blocks: by Pootlepress – 3.4.0<br>Shopkeeper Extender: by Get Bowtied – 3.7<br>Product Size Charts Plugin for WooCommerce (Premium): by theDotstore – 2.4.4<br>Subscriber Discounts for WooCommerce: by AMP-MODE – 1.5.2<br>Typeform: by Typeform – 2.9.1<br>Woo Additional Terms: by MyPreview – 1.6.6<br>WPC Frequently Bought Together for WooCommerce: by WPClever – 7.1.6<br>Woo Custom Stock Status: by Softound Solutions – 1.5.2<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>Variation Swatches for WooCommerce – Pro: by Emran Ahmed – 2.1.3<br>Variation Swatches for WooCommerce: by Emran Ahmed – 2.1.1<br>Avalara AvaTax: by Avalara – 2.7.2 (update to version 2.8.0 is available)<br>WooCommerce Buy One Get One Free: by Oscar Gare – 5.2.4 (update to version 5.3.2 is available)<br>WooCommerce Conversion Tracking: by weDevs – 2.0.12<br>WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.5.1<br>WooCommerce Legacy REST API: by WooCommerce – 1.0.4<br>WooPayments: by Automattic – 7.8.1 (update to version 8.0.2 is available)<br>WooCommerce PayPal Payments: by WooCommerce – 2.8.1 (update to version 2.8.3 is available)<br>WooCommerce Google Product Feed: by Ademti Software Ltd. – 11.0.10 (update to version 11.0.12 is available)<br>WooCommerce: by Automattic – 9.0.2 (update to version 9.2.2 is available)<br>Wordfence Security: by Wordfence – 7.11.7<br>WordPress Importer: by wordpressdotorg – 0.8.2<br>Yoast SEO Premium: by Team Yoast – 23.0<br>Yoast SEO: by Team Yoast – 23.0<br>WP Fastest Site Search: by Expertrec – 5.3.8<br>WP Headers And Footers: by WPBrigade – 2.2.0<br>WP Mailgun SMTP: by InkThemes – 1.0.7<br>WP Migrate: by WP Engine – 2.6.13<br>ProfilePress: by ProfilePress Membership Team – 4.15.10<br>WPMU DEV Dashboard: by WPMU DEV – 4.11.26<br>Yoast SEO: WooCommerce: by Team Yoast – 16.2<br>Smart Coupons For WooCommerce Coupons: by WebToffee – 1.8.0<br>YITH WooCommerce Frequently Bought Together: by YITH – 1.38.0 Inactive Plugins (3)</p> <p>NitroPack: by NitroPack Inc. – 1.15.3<br>SafeOpt Tags: by Addshoppers – 1.0.0<br>Seraphinite Accelerator (Extended, limited): by Seraphinite Solutions – 2.22.3 Dropin Plugins ()</p> <p>advanced-cache.php: advanced-cache.php Must Use Plugins (7)</p> <p>Force Strong Passwords – WPE Edition: by Jason Cosper – 1.8.0<br>Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.17<br>WP Engine Cache Plugin: by WP Engine – 1.3.1<br>WP Engine Seamless Login Plugin: by WP Engine – 1.6.1<br>WP Engine Security Auditor: by wpengine – 1.1.1<br>WP Engine System: by WP Engine – 5.0.1<br>WP Migrate Compatibility: by Delicious Brains – 1.3 Settings</p> <p>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: external (external)<br>grouped (grouped)<br>pw gift card (pw-gift-card)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)</p> <p>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)</p> <p>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</p> <p>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 45 MB WC Pages</p> <p>Shop base: #2851 – /shop/<br>Cart: #6 – /cart/<br>Checkout: #7 – /checkout/<br>My account: #8 – /my-account/<br>Terms and conditions: ? Page not set Theme</p> <p>Name: Shopkeeper Child<br>Version: 1.0<br>Author URL: http:%20//www.getbowtied.com/<br>Child Theme: ?<br>Parent Theme Name: Shopkeeper<br>Parent Theme Version: 2.8.3<br>Parent Theme Author URL: https://www.getbowtied.com/<br>WooCommerce Support: ? Templates</p> <p>Overrides: shopkeeper-child/woocommerce/archive-product.php version 3.4.0 is out of date. The core version is 8.6.0<br>shopkeeper/woocommerce/cart/cart-empty.php version 3.5.0 is out of date. The core version is 7.0.1<br>shopkeeper/woocommerce/cart/mini-cart.php version 3.7.0 is out of date. The core version is 7.9.0<br>shopkeeper/woocommerce/checkout/form-coupon.php version 3.4.4 is out of date. The core version is 7.0.1<br>shopkeeper/woocommerce/checkout/form-login.php version 3.4.0 is out of date. The core version is 3.8.0<br>shopkeeper-child/woocommerce/checkout/review-order.php version 3.8.0 is out of date. The core version is 5.2.0<br>shopkeeper-child/woocommerce/content-product.php<br>shopkeeper/woocommerce/content-single-product.php<br>shopkeeper/woocommerce/global/quantity-input.php version 3.6.0 is out of date. The core version is 7.8.0<br>shopkeeper/woocommerce/global/sidebar.php<br>shopkeeper/woocommerce/global/wrapper-end.php<br>shopkeeper/woocommerce/global/wrapper-start.php<br>shopkeeper/woocommerce/loop/loop-end.php<br>shopkeeper/woocommerce/loop/loop-start.php<br>shopkeeper/woocommerce/loop/no-products-found.php version 2.0.0 is out of date. The core version is 7.8.0<br>shopkeeper/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 7.0.1<br>shopkeeper/woocommerce/order/form-tracking.php version 3.6.0 is out of date. The core version is 7.0.1<br>shopkeeper/woocommerce/single-product/add-to-cart/simple.php version 3.4.0 is out of date. The core version is 7.0.1<br>shopkeeper-child/woocommerce/single-product/meta.php<br>shopkeeper/woocommerce/single-product/product-image.php version 3.5.1 is out of date. The core version is 7.8.0<br>shopkeeper/woocommerce/single-product/product-thumbnails.php<br>shopkeeper-child/woocommerce/single-product/short-description.php<br>shopkeeper-child/woocommerce/single-product/tabs/tabs.php version 2.4.0 is out of date. The core version is 3.8.0<br>shopkeeper/woocommerce/single-product.php<br>shopkeeper/woocommerce/content-product_cat.php version 2.6.1 is out of date. The core version is 4.7.0</p> <p>Outdated Templates: ?</p> <pre class=”wp-block-code”><code> Learn how to update</code></pre> <p>WooPayments</p> <p>Version: 7.8.1<br>Connected to WPCOM: Yes<br>WPCOM Blog ID: 150707152<br>Account ID: acct_1LhFiH2HCtCO6GPv<br>Payment Gateway: Enabled<br>Test Mode: Disabled<br>Enabled APMs: card<br>WooPay: Enabled (checkout)<br>WooPay Incompatible Extensions: No<br>Apple Pay / Google Pay: Enabled (product,cart,checkout)<br>Fraud Protection Level: basic<br>Multi-currency: Enabled<br>Auth and Capture: Enabled<br>Documents: Disabled<br>Logging: Enabled WooCommerce Google Product Feed feeds</p> <p>6de5526d6fb0f745: Google merchant centre product feed<br>  Type: google<br>  Category filter: -<br>  Categories: – WooCommerce Google Product Feed options</p> <p>Include variations in feed: Enabled<br>Send “item group ID”: Enabled<br>Expanded schema markup: -<br>Debug key: 1fb509d3-bf1c-41ae-a2a8-0d449b5bf460 WooCommerce Google Product Feed fields</p> <p>Title: Pre-populates from product product_title.<br>Product description: Main product description (full preferred) plus variation description<br>Availability (in stock products): Defaults to “in stock”.<br>Availability (backordered products): Defaults to “in stock”.<br>Availability (out of stock products): Defaults to “out of stock”.<br>Brand: Defaults to “ALOR”.<br>Manufacturer Part Number (MPN):<br>Product Type:<br>Google Product Category:<br>Size system: WooCommerce Google Product Feed DB status</p> <p>Database version: 17<br>Active database version: 17<br>wc_gpf_render_cache: Empty<br>woocommerce_gpf_google_taxonomy (en-US): 5595 items Buy One Get One Free</p> <p>Database version: 5.2.4<br>Legacy options: yes<br>Disable coupons: no<br>Custom attributes: no WooCommerce PayPal Payments</p> <p>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 Admin</p> <p>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</p> <p>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</p> <p>Daily Cron: ? Next scheduled: 2024-08-24 03:13:43 -07:00<br>Options: ?<br>Notes: 201<br>Onboarding: completed WooCommerce Customer/Order/Coupon Export</p> <p>Automated exports: 0<br>Custom formats: 0<br>Next export: Not scheduled Action Scheduler</p> <p>Complete: 320<br>Oldest: 2024-07-26 17:21:23 -0700<br>Newest: 2024-08-06 00:22:57 -0700</p> <p>Pending: 3,609<br>Oldest: 2024-07-30 12:21:48 -0700<br>Newest: 2024-08-26 05:38:02 -0700</p> <p>Failed: 9<br>Oldest: 2024-07-26 19:29:01 -0700<br>Newest: 2024-07-29 19:29:14 -0700</p> <p>Canceled: 1,713<br>Oldest: 2024-07-27 16:49:02 -0700<br>Newest: -0001-11-29 16:07:02 -0752 Status report information</p> <p>Generated at: 2024-08-26 05:40:19 -07:00<br>`

    For the Scheduled Actions, I’m seeing 9 failed:

    There are 3,609 under pending. Here is the first few, let me know if you need more:

    Where do I find the recent fatal error logs? I’m not seeing anything under System Status marked as this. The Logs tab also doesn’t use those terms.

    Thanks,

    Morgan

    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi Morgan, thank you for sharing those additional details.

    As a first step, I can see your WordPress and WooCommerce versions are out of date. Could you please try running all pending updates and seeing if that fixes it? You can take a full?backup?of your site before doing that or try the updates on a?staging?site to make sure nothing breaks while doing so.
    ?
    If this still doesn’t fix the issue, I suggest running a conflict test. I see there are 69 active plugins, many of them related to WooCommerce; one (or a combination) of them may be causing a conflict here. To rule out any such issue, can you please run a conflict test as described in this guide?

    Additionally, your screenshots didn’t save to the forums, you can try sending them using a service like https://snipboard.io/ and sharing the links here.

    Where do I find the recent fatal error logs? I’m not seeing anything under System Status marked as this. The Logs tab also doesn’t use those terms.

    These should be under WooCommerce > Status > Logs. If you aren’t seeing any that’s good news.

    Thanks!
    -OP

    Thread Starter mhawkins93

    (@mhawkins93)

    Hello! I have been told our WordPress and WooCommerce versions have been updated now. Analytics is still not working.

    The conflict test is not doable for us, even on a staging site. All our plug-ins are necessary and it’s not feasible to delete and reinstate so many on an active site. Especially, when it’s been running all along just fine.

    See below for the screenshot of our order data storage:

    https://snipboard.io/SzhmO7.jpg

    Regarding the failed scheduled actions:

    https://snipboard.io/WxerJl.jpg

    https://snipboard.io/JGKCcB.jpg

    https://snipboard.io/k6W58h.jpg

    Let me know next steps, thanks.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello mhawkins93,

    Thank you for your reply.

    I see that your site has 69 active plugins. While I understand that everything was functioning well before, it’s important to note that WordPress and plugins are frequently updated, which can sometimes introduce conflicts.

    Given the challenges of performing a conflict test, even on a staging site, and considering the number of essential plugins you have, it would be prudent to consult a professional web developer. They can log in to your site, conduct a thorough inspection, and address any underlying issues that might be causing the analytics malfunction.

    You can find experienced developers at WooExperts and Codeable.
    If you need further assistance or guidance, feel free to ask.

    Best regards.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘WooCommerce Analytics Not Working’ is closed to new replies.