• Resolved boesiger

    (@boesiger)


    Hi
    After trying out all leads found in the forum (switch to Storefront theme, deactivate all plugins except WooCommerce, importing historical data) the WooCommerce-Customers section still does not display any data. However, customers are listed in the WP users list (role: customer) and the WooCommerce-Reports section.
    Each order forces the user to either register or log in. So there’s no order without customer.

    What could be the reason for this behaviour?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Rafy a11n

    (@nawaz0705)

    Hi @boesiger

    Thank you for reaching out!

    Let’s see if there is an error on the WooCommerce Logs. Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    Also, in order for us to get a better understanding of your site setup, could you please share a copy of your website’s System Status Report?

    You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Thread Starter boesiger

    (@boesiger)

    Hi Rafy

    There’s no fatal error in the logs.
    Here’s the system report.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://global.inlingua.com
    Site address (URL): https://global.inlingua.com
    WC Version: 6.6.1
    REST API Version: ? 6.6.1
    WC Blocks Version: ? 7.6.2
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.30
    PHP Post Max Size: 256 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 200000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.34-MariaDB
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.6.1
    WC Database Prefix: RgQnwvgI_
    Total Database Size: 14.68MB
    Database Data Size: 11.51MB
    Database Index Size: 3.17MB
    RgQnwvgI_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_actionscheduler_actions: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
    RgQnwvgI_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    RgQnwvgI_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_icl_languages_translations: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
    RgQnwvgI_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_icl_mo_files_domains: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_strings: Data: 0.14MB + Index: 0.22MB + Engine InnoDB
    RgQnwvgI_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_string_positions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_string_translations: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_icl_translate: Data: 0.23MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_icl_translations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_icl_translation_status: Data: 0.22MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_mail_catcher_logs: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_action_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_field_meta: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_options: Data: 4.03MB + Index: 0.14MB + Engine InnoDB
    RgQnwvgI_postmeta: Data: 0.25MB + Index: 0.20MB + Engine InnoDB
    RgQnwvgI_posts: Data: 3.48MB + Index: 0.13MB + Engine InnoDB
    RgQnwvgI_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_usermeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    RgQnwvgI_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_wfconfig: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    RgQnwvgI_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    RgQnwvgI_yoast_indexable: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    RgQnwvgI_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    RgQnwvgI_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    RgQnwvgI_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    RgQnwvgI_yoast_seo_links: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 28
    custom_css: 1
    customize_changeset: 78
    logichop-conditions: 5
    logichop-goals: 1
    logichop-logicblocks: 1
    nav_menu_item: 7
    nf_sub: 118
    page: 38
    post: 2
    product: 12
    product_variation: 13
    revision: 278
    shop_coupon: 2
    shop_order: 8
    shop_subscription: 4
    wp_global_styles: 2
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (1) ###
    
    WooCommerce: by Automattic – 6.6.1
    
    ### Inactive Plugins (25) ###
    
    Akismet Anti-Spam: by Automattic – 4.2.4
    Classic Editor: by WordPress Contributors – 1.6.2
    Code Snippets: by Code Snippets Pro – 3.1.1
    Contact Form 7: by Takayuki Miyoshi – 5.6
    Copy & Delete Posts: by Copy Delete Posts – 1.3.0
    Disable Emails: by WebAware – 1.8.1
    Inlingua Courselist by PromptNet: by Kurt Zaugg – 1.0
    Mail logging - WP Mail Catcher: by James Ward – 2.0.4
    MWB HubSpot for WooCommerce: by MakeWebBetter – 1.3.1
    Ninja Forms: by Saturday Drive – 3.6.12
    Ninja Forms - Conditional Logic: by The WP Ninjas – 3.1
    Ninja Forms - Multi-Part Forms: by The WP Ninjas – 3.0.26
    Ninja Forms Multilingual: by OnTheGoSystems – 0.2.0
    Payment Plugins for Stripe WooCommerce: by Payment Plugins
    [email protected] – 3.3.23
    
    SVG Support: by Benbodhi – 2.4.2
    Ultimate Addons for Gutenberg: by Brainstorm Force – 1.25.6
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.12
    
    WooCommerce Multilingual & Multicurrency: by OnTheGoSystems – 5.0.1
    WooCommerce Subscriptions: by WooCommerce – 4.4.0
    Wordfence Security: by Wordfence – 7.5.11
    WPML Media: by OnTheGoSystems – 2.7.0
    WPML Multilingual CMS: by OnTheGoSystems – 4.5.8
    WPML SEO: by OnTheGoSystems – 2.0.1
    WPML String Translation: by OnTheGoSystems – 3.2.1
    Yoast SEO: by Team Yoast – 19.2
    
    ### Dropin Plugins (1) ###
    
    maintenance.php: maintenance.php
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: right_space
    Thousand Separator: 
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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: ?
    
    ### WC Pages ###
    
    Shop base: #643 - /shop/
    Cart: #644 - /cart/
    Checkout: #645 - /checkout-2/
    My account: #646 - /my-account/
    Terms and conditions: #3 - /privacy-policy/
    
    ### Theme ###
    
    Name: Storefront
    Version: 4.1.0
    Author URL: https://woocommerce.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
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    homescreen
    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
    wc-pay-promotion
    wc-pay-welcome-page
    wc-pay-subscriptions-page
    
    Disabled Features: minified-js
    settings
    
    Daily Cron: ? Next scheduled: 2022-06-20 13:31:51 +00:00
    Options: ?
    Notes: 30
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 2
    Oldest: 2022-06-28 13:50:55 +0000
    Newest: 2022-06-28 13:50:39 +0000
    
    Pending: 72
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: 2022-07-28 07:36:22 +0000
    
    Canceled: 92
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: -0001-11-30 00:00:00 +0000
    
    ### Status report information ###
    
    Generated at: 2022-06-28 14:45:25 +00:00
    

    Thanks!

    Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    Hi @boesiger,

    Thanks for sending that over. I have a few follow-ups for you.

    Do you see data in the Analytics section of the site?

    Please go to WooCommerce > Customers and open up the browser’s developer’s console. You can typically do that with Shift + CTRL + J on Windows and Option + Command + J on a Mac.

    See if there are any error messages here. If there are, please copy them and paste them into your reply.

    Thanks!

    Thread Starter boesiger

    (@boesiger)

    Hi @3sonsdevelopment

    There’s no error in the console.

    Meanwhile I ran all the WP cron jobs manually, and, heureka!, the customers are listed. However, I was also testing with new customers after having run the cron jobs and those new ones don’t appear in the list. So, there must something wrong with the cron jobs. Can you please tell which job syncs the customers list, so I can check.

    Thanks!

    Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    Hey @boesiger,

    Good detective work! The customers and other analytics information are imported into dedicated tables in the database to speed everything up. These are handled by the “Action Scheduler” system. It can be triggered via WP Cron so if cron isn’t working then it would affect importing of this data.

    If this was my site, I would try to find out what is keeping WP Cron from running as expected and go from there. Once it’s working reliably, that should take care of this.

    Let us know how it goes!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WooCommerce-Customers section empty list’ is closed to new replies.