WooCommerce not syncing data to Google Analytics

  • Resolved Picflick

    (@picflick)


    3 years, 7 months ago

    Good day,

    I am experiencing an issue whereby WooCommerce is not syncing 100% of the orders that have been processed on our website through WooCommerce.

    If you look at our orders page you will clearly see many orders – WooCommerce Orders Page
    But if you look in Google Analytics there is clearly a mismatch, and it is only displaying a subset of the actual orders – Google Analytics page
    I have configured the WooCommerce Analytics integration using the UA code (See config here)

    Please see below for system report.

    Kindly assist with resolving this issue and ensuring that ALL our data from WooCommerce is synced over to Google Analytics. I have waited over 48 hours and it has still not synced.

    Thanks and regards

    ### WordPress Environment ###

    WordPress address (URL): https://picflick.co.za
    Site address (URL): https://picflick.co.za
    WC Version: 5.1.0
    REST API Version: ? 5.1.0
    WC Blocks Version: ? 4.4.3
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 2.0.2
    Log Directory Writable: ?
    WP Version: 5.7.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: ?

    ### Server Environment ###

    Server Info: nginx
    PHP Version: 7.3.27
    PHP Post Max Size: 2 GB
    PHP Time Limit: 1200
    PHP Max Input Vars: 6144
    cURL Version: 7.75.0
    OpenSSL/1.1.0l

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

    ### Database ###

    WC Database Version: 5.1.0
    WC Database Prefix: wp_143273072_
    Total Database Size: 1178.92MB
    Database Data Size: 766.75MB
    Database Index Size: 412.17MB
    wp_143273072_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_143273072_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    wp_143273072_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_143273072_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_actionscheduler_actions: Data: 1.30MB + Index: 0.70MB + Engine InnoDB
    vp_backup_wp_143273072_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_actionscheduler_logs: Data: 1.42MB + Index: 0.48MB + Engine InnoDB
    vp_backup_wp_143273072_cmeb_email_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_cmeb_free_domains: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_cmeb_userlist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_commentmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_comments: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    vp_backup_wp_143273072_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_eum_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_gglcptch_whitelist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_layerslider: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_options: Data: 6.47MB + Index: 0.23MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_pmpro_membership_orders: Data: 0.06MB + Index: 0.20MB + Engine InnoDB
    vp_backup_wp_143273072_postmeta: Data: 16.55MB + Index: 9.03MB + Engine InnoDB
    vp_backup_wp_143273072_posts: Data: 15.52MB + Index: 1.36MB + Engine InnoDB
    vp_backup_wp_143273072_pts_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_pts_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_pts_tables: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_pts_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_pv_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_slides: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_slides_bkp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_termmeta: Data: 0.28MB + Index: 0.39MB + Engine InnoDB
    vp_backup_wp_143273072_terms: Data: 0.22MB + Index: 0.28MB + Engine InnoDB
    vp_backup_wp_143273072_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    vp_backup_wp_143273072_term_taxonomy: Data: 0.23MB + Index: 0.27MB + Engine InnoDB
    vp_backup_wp_143273072_usermeta: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
    vp_backup_wp_143273072_users: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_daily_analysis: Data: 4.52MB + Index: 4.52MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_detailed_analysis: Data: 134.67MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_enquiries_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_enquiries_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_enquiries_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_fbc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_fbc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_fbc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_fbc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_following_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_product_multivendor: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_refund_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_reviews_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_review_rating_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_withdraw_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_marketplace_withdraw_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_membership_subscription: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_messages: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_messages_modifier: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_messages_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_support_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcfm_support_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_cust_answers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_cust_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_products_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_vendor_ledger: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_vendor_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wcmp_visitors_stats: Data: 14.52MB + Index: 24.13MB + Engine InnoDB
    vp_backup_wp_143273072_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    vp_backup_wp_143273072_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    vp_backup_wp_143273072_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_wc_product_meta_lookup: Data: 0.23MB + Index: 0.50MB + Engine InnoDB
    vp_backup_wp_143273072_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_downloadable_product_permissi: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    vp_backup_wp_143273072_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_chat_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_chat_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_departments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_roi_conversions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_roi_goals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wsal_metadata: Data: 48.58MB + Index: 81.31MB + Engine InnoDB
    vp_backup_wp_143273072_wsal_occurrences: Data: 6.52MB + Index: 11.03MB + Engine InnoDB
    vp_backup_wp_143273072_wsal_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    vp_backup_wp_143273072_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_yith_wcwl_lists: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_indexable: Data: 2.52MB + Index: 1.64MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    vp_backup_wp_143273072_yoast_seo_meta: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_actionscheduler_actions: Data: 2.03MB + Index: 0.78MB + Engine InnoDB
    wp_143273072_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_actionscheduler_logs: Data: 1.05MB + Index: 0.63MB + Engine InnoDB
    wp_143273072_cmeb_email_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_cmeb_free_domains: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_cmeb_userlist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_commentmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    wp_143273072_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_eum_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_gglcptch_whitelist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_layerslider: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_options: Data: 7.45MB + Index: 0.23MB + Engine InnoDB
    wp_143273072_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_143273072_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_143273072_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_143273072_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_pmpro_membership_orders: Data: 0.06MB + Index: 0.20MB + Engine InnoDB
    wp_143273072_postmeta: Data: 18.55MB + Index: 9.02MB + Engine InnoDB
    wp_143273072_posts: Data: 17.52MB + Index: 1.27MB + Engine InnoDB
    wp_143273072_pts_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_pts_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_pts_tables: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_pts_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_pv_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_slides: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_slides_bkp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_termmeta: Data: 0.28MB + Index: 0.36MB + Engine InnoDB
    wp_143273072_terms: Data: 0.22MB + Index: 0.28MB + Engine InnoDB
    wp_143273072_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    wp_143273072_term_taxonomy: Data: 0.23MB + Index: 0.27MB + Engine InnoDB
    wp_143273072_usermeta: Data: 4.50MB + Index: 4.02MB + Engine InnoDB
    wp_143273072_users: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
    wp_143273072_wcfm_daily_analysis: Data: 4.52MB + Index: 4.52MB + Engine InnoDB
    wp_143273072_wcfm_detailed_analysis: Data: 134.67MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_enquiries_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_enquiries_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_enquiries_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_fbc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_fbc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcfm_fbc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_fbc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_following_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_product_multivendor: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_refund_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_reviews_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_review_rating_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_withdraw_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_marketplace_withdraw_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_membership_subscription: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcfm_messages: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_messages_modifier: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_messages_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_support_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcfm_support_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_cust_answers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcmp_cust_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_products_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_vendor_ledger: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wcmp_vendor_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wcmp_visitors_stats: Data: 14.52MB + Index: 24.13MB + Engine InnoDB
    wp_143273072_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_143273072_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_143273072_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_wc_product_meta_lookup: Data: 0.23MB + Index: 0.50MB + Engine InnoDB
    wp_143273072_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_chat_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_chat_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_departments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_roi_conversions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_roi_goals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wsal_metadata: Data: 48.58MB + Index: 81.31MB + Engine InnoDB
    wp_143273072_wsal_occurrences: Data: 6.52MB + Index: 11.03MB + Engine InnoDB
    wp_143273072_wsal_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_143273072_yith_wcwl: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_yith_wcwl_lists: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_143273072_yoast_indexable: Data: 2.52MB + Index: 1.64MB + Engine InnoDB
    wp_143273072_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_143273072_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_143273072_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_143273072_yoast_seo_meta: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_actionscheduler_actions: Data: 0.34MB + Index: 0.38MB + Engine InnoDB
    __wp_143273072_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_actionscheduler_logs: Data: 0.25MB + Index: 0.17MB + Engine InnoDB
    __wp_143273072_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_comments: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
    __wp_143273072_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_layerslider: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_mailchimp_jobs: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_options: Data: 3.41MB + Index: 0.14MB + Engine InnoDB
    __wp_143273072_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    __wp_143273072_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    __wp_143273072_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    __wp_143273072_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB
    __wp_143273072_popup_country_d: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_popup_form_results: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_popup_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_popup_visits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_popup_windows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_postmeta: Data: 10.50MB + Index: 6.03MB + Engine InnoDB
    __wp_143273072_posts: Data: 12.50MB + Index: 0.81MB + Engine InnoDB
    __wp_143273072_pts_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_pts_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_pts_tables: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_pts_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_pv_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_termmeta: Data: 0.16MB + Index: 0.20MB + Engine InnoDB
    __wp_143273072_terms: Data: 0.13MB + Index: 0.16MB + Engine InnoDB
    __wp_143273072_term_relationships: Data: 1.48MB + Index: 1.52MB + Engine InnoDB
    __wp_143273072_term_taxonomy: Data: 0.16MB + Index: 0.19MB + Engine InnoDB
    __wp_143273072_usermeta: Data: 2.42MB + Index: 1.98MB + Engine InnoDB
    __wp_143273072_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    __wp_143273072_wcfm_daily_analysis: Data: 26.55MB + Index: 26.59MB + Engine InnoDB
    __wp_143273072_wcfm_detailed_analysis: Data: 117.66MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_enquiries_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_enquiries_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_enquiries_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_fbc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_fbc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcfm_fbc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_fbc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_following_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_product_multivendor: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_refund_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_reviews_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_review_rating_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_withdraw_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_marketplace_withdraw_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_membership_subscription: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcfm_messages: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_messages_modifier: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_messages_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_support_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcfm_support_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_cust_answers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcmp_cust_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_products_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wcmp_vendor_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wcmp_visitors_stats: Data: 8.52MB + Index: 16.09MB + Engine InnoDB
    __wp_143273072_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    __wp_143273072_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    __wp_143273072_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_wc_product_meta_lookup: Data: 0.14MB + Index: 0.33MB + Engine InnoDB
    __wp_143273072_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    __wp_143273072_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_order_itemmeta: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    __wp_143273072_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    __wp_143273072_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_chat_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_chat_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_departments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_roi_conversions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_roi_goals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_wsal_metadata: Data: 24.56MB + Index: 41.16MB + Engine InnoDB
    __wp_143273072_wsal_occurrences: Data: 2.52MB + Index: 4.02MB + Engine InnoDB
    __wp_143273072_wsal_options: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_yikes_easy_mc_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    __wp_143273072_yith_wcwl: Data: 3.02MB + Index: 4.05MB + Engine InnoDB
    __wp_143273072_yith_wcwl_lists: Data: 4.02MB + Index: 19.06MB + Engine InnoDB
    __wp_143273072_yoast_indexable: Data: 0.23MB + Index: 0.06MB + Engine InnoDB
    __wp_143273072_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    __wp_143273072_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    __wp_143273072_yoast_seo_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    __wp_143273072_yoast_seo_meta: Data: 0.19MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    amp_validated_url: 2
    attachment: 4479
    bnfw_notification: 1
    condition_group: 1
    custom-css-js: 1
    customize_changeset: 31
    custom_css: 2
    custom_dns: 1
    custom_order_status: 2
    da_image: 1
    dc_commission: 57
    dns_revision: 1
    hf_shop_subscription: 14
    jetpack_migration: 2
    jp_img_sitemap: 9
    jp_img_sitemap_index: 5
    jp_sitemap: 3
    jp_sitemap_master: 3
    nav_menu_item: 57
    oembed_cache: 64
    page: 52
    popup: 3
    popupbuilder: 1
    popup_theme: 8
    portfolio: 6
    post: 10
    product: 2176
    restriction: 1
    revision: 910
    seedprod: 3
    shop_coupon: 6
    shop_order: 167
    shop_order_vendor: 3
    team-members: 3
    testimonials: 3
    tm_global_cp: 1
    user_request: 1
    wafs: 1
    wcfm_knowledgebase: 7
    wcfm_memberships: 5
    wcmp_university: 8
    wcmp_vendor_notice: 2
    wcpa_pt_forms: 4
    wcs_ruleset: 1
    wc_afrsm: 1
    wc_order_email: 2
    wc_order_status: 9
    wpcf7_contact_form: 4

    ### Security ###

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

    ### Active Plugins (56) ###

    WP Activity Log: by WP White Security – 4.2.1
    LayerSlider WP: by Kreatura Media – 6.11.2
    Akismet Anti-Spam: by Automattic – 4.1.9
    AMP: by AMP project contributors – 2.0.11
    Bainternet Posts Creation Limits: by bainternet – 3.2
    Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.2.1
    Contact Form 7: by Takayuki Miyoshi – 5.4
    Multivendor Marketplace Solution for WooCommerce – WC Marketplace: by WC Marketplace – 3.7.1
    Disable “BIG image” Threshold: by Jonathan Desrosiers – 1.0
    Draw Attention: by N Squared – 1.9.15
    Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.1.2
    Email Verification for WooCommerce: by WPFactory – 2.0.8
    Envato Market: by Envato – 2.0.6
    Flatastic Content Types: by mad_velikorodnov – 1.0.7
    WordPress.com Editing Toolkit: by Automattic – 3.4764
    Site Kit by Google: by Google – 1.30.0
    Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5
    Import and export users and customers: by codection – 1.17.4.4
    Insert Headers and Footers: by WPBeginner – 1.5.0
    Jetpack by WordPress.com: by Automattic – 9.6.1
    WPBakery Page Builder: by Michael M – WPBakery.com – 6.4.1
    Login With Ajax: by Marcus Sykes – 3.1.11
    Mailchimp for WooCommerce: by Mailchimp – 2.5.1
    Mega Addons For WPBakery Page Builder: by Topdigitaltrends – 4.2.7
    Mega Main Menu: by MegaMain.com – 2.1.4
    Metronet Tag Manager: by Ronald Huereca – 1.5.4
    Multiple Roles: by Florian TIAR – 1.3.1
    Page Optimize: by Automattic – 0.5.1
    Paid Memberships Pro: by Stranger Studios – 2.5.7
    Photection: by Colormelon
    justnorris – 1.0.0

    Paid Memberships Pro – Email Templates Add On (.org): by Paid Memberships Pro – 0.8.1
    Paid Memberships Pro – PayFast Gateway: by Paid Memberships Pro – 1.2
    Popup Maker: by Popup Maker – 1.16.1
    Pricing Table by Supsystic: by supsystic.com – 1.9.4
    Slider Revolution: by ThemePunch – 6.3.5
    Right Click Disable Orignal: by Yash Fale – 1.0
    Ultimate Addons for WPBakery Page Builder: by Brainstorm Force – 3.19.6
    User Menus: by Code Atlantic – 1.2.5
    User Role Editor: by Vladimir Garagulya – 4.59
    Woocommerce Custom Product Addons: by Acowebs – 3.9.8
    WOOCS – WooCommerce Currency Switcher: by realmag777 – 1.3.4.2
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.1
    WooCommerce Order Status Manager: by SkyVerge – 1.13.2
    WooCommerce PayFast Gateway: by WooCommerce – 1.4.18
    WOOF – WooCommerce Products Filter: by realmag777 – 2.2.5.1
    WooCommerce Sequential Order Numbers: by SkyVerge – 1.9.5
    WooCommerce Shipping & Tax: by Automattic – 1.25.11
    WooCommerce: by Automattic – 5.1.0 (update to version 5.2.2 is available)
    WP Crontrol: by John Blackbourn & contributors – 1.10.0
    WP Image Zoom: by SilkyPress – 1.46
    WP Mail SMTP: by WPForms – 2.7.0
    WP Rollback: by Impress.org – 1.7.1
    SEOPress: by SEOPress – 4.5.1
    WPForms Lite: by WPForms – 1.6.6
    YITH WooCommerce Ajax Search: by YITH – 1.8.9
    YITH WooCommerce Wishlist: by YITH – 3.0.20

    ### Inactive Plugins (15) ###

    All-in-One WP Migration: by ServMask – 7.40
    Classic Editor: by WordPress Contributors – 1.6
    CoBlocks: by GoDaddy – 2.10.1
    Custom Order Status for WooCommerce: by Tyche Softwares – 2.0.2
    DHL Express Commerce: by DHL Express – 1.0.1
    Easy Updates Manager: by Easy Updates Manager Team – 9.0.8
    Envato WordPress Toolkit (Deprecated): by Envato – 1.8.0
    Facebook for WooCommerce: by Facebook – 2.3.5
    Gutenberg: by Gutenberg Team – 10.4.1
    Layout Grid: by Automattic – 1.5
    Multi Currency for WooCommerce: by VillaTheme – 2.1.6.2
    Query Monitor: by John Blackbourn – 3.6.7
    The Official Facebook Chat Plugin: by Facebook – 2.0
    WooCommerce Admin: by WooCommerce – 2.2.1
    WordPress Users & WooCommerce Customers Import Export(BASIC): by WebToffee – 2.1.0

    ### Dropin Plugins (2) ###

    advanced-cache.php: advanced-cache.php
    object-cache.php: Memcached

    ### Must Use Plugins (2) ###

    Health Check Troubleshooting Mode: by – 1.7.2
    WP.com Site Helper: by –

    ### Settings ###

    API Enabled: ?
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    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: ?

    ### WC Pages ###

    Shop base: #35 – /products/
    Basket: #61 – /basket/
    Checkout: #62 – /checkout/
    My account: #63 – /my-account/
    Terms and conditions: #593 – /terms-and-conditions-customers/

    ### Theme ###

    Name: Flatastic
    Version: 1.8.7
    Author URL: https://themeforest.net/user/monkeysan/portfolio
    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: flatastic/woocommerce/archive-product.php
    flatastic/woocommerce/auth/footer.php
    flatastic/woocommerce/auth/form-grant-access.php
    flatastic/woocommerce/auth/form-login.php
    flatastic/woocommerce/cart/cart-empty.php
    flatastic/woocommerce/cart/cart-item-data.php
    flatastic/woocommerce/cart/cart-shipping.php
    flatastic/woocommerce/cart/cart-totals.php
    flatastic/woocommerce/cart/cart.php
    flatastic/woocommerce/cart/cross-sells.php
    flatastic/woocommerce/cart/mini-cart.php
    flatastic/woocommerce/cart/proceed-to-checkout-button.php
    flatastic/woocommerce/cart/shipping-calculator.php
    flatastic/woocommerce/checkout/cart-errors.php
    flatastic/woocommerce/checkout/form-billing.php
    flatastic/woocommerce/checkout/form-checkout.php
    flatastic/woocommerce/checkout/form-coupon.php
    flatastic/woocommerce/checkout/form-login.php
    flatastic/woocommerce/checkout/form-pay.php
    flatastic/woocommerce/checkout/form-shipping.php
    flatastic/woocommerce/checkout/payment-method.php
    flatastic/woocommerce/checkout/payment.php
    flatastic/woocommerce/checkout/review-order.php
    flatastic/woocommerce/checkout/terms.php
    flatastic/woocommerce/checkout/thankyou.php
    flatastic/woocommerce/content-product.php
    flatastic/woocommerce/content-single-product.php
    flatastic/woocommerce/content-widget-product.php
    flatastic/woocommerce/emails/admin-cancelled-order.php
    flatastic/woocommerce/emails/admin-new-order.php
    flatastic/woocommerce/emails/customer-completed-order.php
    flatastic/woocommerce/emails/customer-invoice.php
    flatastic/woocommerce/emails/customer-new-account.php
    flatastic/woocommerce/emails/customer-note.php
    flatastic/woocommerce/emails/customer-processing-order.php
    flatastic/woocommerce/emails/customer-refunded-order.php
    flatastic/woocommerce/emails/customer-reset-password.php
    flatastic/woocommerce/emails/email-addresses.php
    flatastic/woocommerce/emails/email-footer.php
    flatastic/woocommerce/emails/email-header.php
    flatastic/woocommerce/emails/email-order-items.php
    flatastic/woocommerce/emails/email-styles.php
    flatastic/woocommerce/emails/plain/admin-cancelled-order.php
    flatastic/woocommerce/emails/plain/admin-new-order.php
    flatastic/woocommerce/emails/plain/customer-completed-order.php
    flatastic/woocommerce/emails/plain/customer-invoice.php
    flatastic/woocommerce/emails/plain/customer-new-account.php
    flatastic/woocommerce/emails/plain/customer-note.php
    flatastic/woocommerce/emails/plain/customer-processing-order.php
    flatastic/woocommerce/emails/plain/customer-refunded-order.php
    flatastic/woocommerce/emails/plain/customer-reset-password.php
    flatastic/woocommerce/emails/plain/email-addresses.php
    flatastic/woocommerce/emails/plain/email-order-items.php
    flatastic/woocommerce/global/breadcrumb.php
    flatastic/woocommerce/global/form-login.php
    flatastic/woocommerce/global/quantity-input.php
    flatastic/woocommerce/global/sidebar.php
    flatastic/woocommerce/global/wrapper-end.php
    flatastic/woocommerce/global/wrapper-start.php
    flatastic/woocommerce/loop/add-to-cart.php
    flatastic/woocommerce/loop/loop-end.php
    flatastic/woocommerce/loop/loop-start.php
    flatastic/woocommerce/loop/no-products-found.php
    flatastic/woocommerce/loop/orderby.php
    flatastic/woocommerce/loop/pagination.php
    flatastic/woocommerce/loop/price.php
    flatastic/woocommerce/loop/rating.php
    flatastic/woocommerce/loop/result-count.php
    flatastic/woocommerce/loop/sale-flash.php
    flatastic/woocommerce/myaccount/form-login.php
    flatastic/woocommerce/myaccount/my-address.php
    flatastic/woocommerce/myaccount/my-orders.php
    flatastic/woocommerce/notices/error.php
    flatastic/woocommerce/notices/notice.php
    flatastic/woocommerce/notices/success.php
    flatastic/woocommerce/order/form-tracking.php
    flatastic/woocommerce/order/order-again.php
    flatastic/woocommerce/order/order-details-customer.php
    flatastic/woocommerce/order/order-details-item.php
    flatastic/woocommerce/order/tracking.php
    flatastic/woocommerce/product-searchform.php
    flatastic/woocommerce/single-product/add-to-cart/external.php
    flatastic/woocommerce/single-product/add-to-cart/grouped.php
    flatastic/woocommerce/single-product/add-to-cart/simple.php
    flatastic/woocommerce/single-product/add-to-cart/variable.php
    flatastic/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
    flatastic/woocommerce/single-product/meta.php
    flatastic/woocommerce/single-product/price.php
    flatastic/woocommerce/single-product/product-attributes.php
    flatastic/woocommerce/single-product/product-image.php
    flatastic/woocommerce/single-product/product-thumbnails.php
    flatastic/woocommerce/single-product/rating.php
    flatastic/woocommerce/single-product/related.php
    flatastic/woocommerce/single-product/review.php
    flatastic/woocommerce/single-product/sale-flash.php
    flatastic/woocommerce/single-product/share.php
    flatastic/woocommerce/single-product/short-description.php
    flatastic/woocommerce/single-product/tabs/additional-information.php
    flatastic/woocommerce/single-product/tabs/description.php
    flatastic/woocommerce/single-product/tabs/tabs.php
    flatastic/woocommerce/single-product/title.php
    flatastic/woocommerce/single-product/up-sells.php
    flatastic/woocommerce/single-product-reviews.php
    flatastic/woocommerce/single-product.php
    flatastic/woocommerce/content-product_cat.php
    flatastic/woocommerce/taxonomy-product_cat.php
    flatastic/woocommerce/taxonomy-product_tag.php

    ### Action Scheduler ###

    Complete: 2,970
    Oldest: 2021-03-22 10:53:52 +0200
    Newest: 2021-04-19 20:32:57 +0200

    Failed: 121
    Oldest: 2018-06-11 17:09:58 +0200
    Newest: 2018-07-09 15:28:11 +0200

    Pending: 5
    Oldest: 2021-04-19 20:41:00 +0200
    Newest: 2021-04-23 18:09:48 +0200

    ### Status report information ###

    Generated at: 2021-04-19 20:35:45 +02:00

    • This topic was modified 3 years, 7 months ago by Picflick.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    Hi @picflick,

    Looking at the screenshots of the orders from WooCommerce vs the screenshot of the orders from Google Analytics all of the correct orders which have statuses of either Processing or Completed seem to be displaying on both WooCommerce and Google Analytics.

    From what I can see orders which have a status of On Hold or Cancelled would not initially be passed to Google Analytics. You could however record such orders’ data in Google Analytics by importing those using Analytics Management API.

    https://support.google.com/analytics/answer/3191589?hl=en

    Thread Starter Picflick

    (@picflick)

    Thanks for the response @stuartduff

    I appreciate you doing a recon between the screenshots, however order #1189, #1199, and #1203 are all Completed yet not displaying on Google Analytics (the same status as order #1195, #1175, etc. which are showing on Google Analytics).

    The manual import kind of negates the functionality of this plugin, which I would love to use considering its integration with WooCommerce/Analytics. Can you please assist me with with fixing it. Are there any other locations I can check the settings or provide you with screenshots – please let me know how we can resolve

    Thanks, PicFlick

    Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    Hey @picflick,

    If the order statuses we’re automatically set to Processing or Completed after being successfully paid for I’m not sure why those orders would not have been tracked. It wouldn’t be settings related or similar if nothing has been changed in the settings of the WooCommerce Google Analytics Integration. The plugins only function is to insert the tracking code into a website rather than having to do that manually by editing files etc.

    It could however be something on the site affected the tracking code from working correctly during that time and prevented the data from passing from your WooCommerce installation to Google. That could be another plugin installed on the site which has been updated recently or a cache of some kind which is enabled.

    Thread Starter Picflick

    (@picflick)

    Thanks for the insight @stuartduff
    While all these points are great and well noted, I would appreciate if you could kindly advise a way forward on how to resolve?!
    Thank you,
    PicFlick

    Hi,

    I am having the exact same issue. Could this be due to users blocking cookies?

    Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    Hi @picflick,

    If you install the Google Tag assistance tool for the Google Chrome browsers you will be able to take a closer look at the Analytics tags which are now displaying on your site of https://picflick.co.za/ when viewing that today. You can find more information on testing analytics integrations from this section of the WooCommerce Google Analytics Integration documentation.

    https://docs.woocommerce.com/document/google-analytics-integration/#testing-analytics

    When using this tool I’m seeing a warning that one of your UA- analytics tracking ID’s is being used twice on the site.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WooCommerce not syncing data to Google Analytics’ is closed to new replies.