WooCommerce-Customers section empty list
-
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?
-
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 theGet system report
button and then copy it by clicking on theCopy for support
button. Then paste it here in a comment.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!
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 andOption + 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!
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!
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!
- The topic ‘WooCommerce-Customers section empty list’ is closed to new replies.