Customer Lookup Table not updating

Hi Ashley!

Thanks for getting in touch.

To get a better understanding, could you please share a full uncropped screenshot of the page that is not updating data? Please redact any personal info on the customer’s data as we’re on a public forum.

I recommend https://snipboard.io for easily sharing screenshots – please follow the instructions on that page, then paste the URL in this thread. It works with Chrome, Firefox, Safari, and Edge browsers.

Could you please also share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Thanks!

Hi Mirko

Thanks for coming back to me

I would love to post a screen print but by the time I have redacted sensitive info there would be nothing left of interest

The page URL is https://www.mydomain.es/wp-admin/admin.php?page=wc-admin&path=%2Fcustomers

Reached by following WP Admin > WooCommerce > Customers

Generated from the myprefix_wc_customer_lookup table in the database

I even changed the email value directly in the myprefix_wc_customer_lookup table in the database using phpMyAdmin

But it does not display the change when I call the page

I’m wondering if WC has a cache somewhere I can purge

Although I understood that the lookup tables were a sort of cache

Best regards

Ashley

Below is notes that the cart and checkout pages do not contain the WC shortcodes that is because I am using Elementor to create those pages

### WordPress Environment ###

WordPress address (URL): https://www.musicologic.es
Site address (URL): https://www.musicologic.es
WC Version: 6.8.0
REST API Version: ? 6.8.0
WC Blocks Version: ? 8.0.0
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: es_ES
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.0.21
PHP Post Max Size: 256 MB
PHP Time Limit: 1200
PHP Max Input Vars: 10000
cURL Version: 7.71.0
OpenSSL/1.1.1p

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

### Database ###

WC Database Version: 6.8.0
WC Database Prefix: qwkahde_
Total Database Size: 129.75MB
Database Data Size: 125.09MB
Database Index Size: 4.66MB
qwkahde_woocommerce_sessions: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_order_items: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
qwkahde_woocommerce_order_itemmeta: Data: 0.14MB + Index: 0.10MB + Engine MyISAM
qwkahde_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_actionscheduler_actions: Data: 0.17MB + Index: 0.08MB + Engine MyISAM
qwkahde_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_actionscheduler_logs: Data: 0.38MB + Index: 0.28MB + Engine MyISAM
qwkahde_aiowps_debug_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_failed_logins: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_global_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_login_activity: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_akeeba_common: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_ak_params: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_ak_profiles: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
qwkahde_ak_stats: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
qwkahde_ak_storage: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qwkahde_ak_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_check_email_log: Data: 0.69MB + Index: 0.00MB + Engine MyISAM
qwkahde_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
qwkahde_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
qwkahde_e_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_e_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_e_notes_users_relations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_e_submissions: Data: 0.00MB + Index: 0.03MB + Engine MyISAM
qwkahde_e_submissions_actions_log: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_e_submissions_values: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qwkahde_litespeed_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_litespeed_url_file: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_options: Data: 4.05MB + Index: 0.13MB + Engine InnoDB
qwkahde_postmeta: Data: 62.47MB + Index: 2.98MB + Engine InnoDB
qwkahde_posts: Data: 56.50MB + Index: 0.53MB + Engine InnoDB
qwkahde_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qwkahde_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qwkahde_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
qwkahde_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
qwkahde_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
qwkahde_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
qwkahde_wcs_payment_retries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_order_product_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
qwkahde_wc_order_stats: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
qwkahde_wc_order_tax_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
qwkahde_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_tax_rate_classes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
qwkahde_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
qwkahde_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

af_c_fields: 1
attachment: 96
custom-css-js: 18
def_reg_fields: 10
e-landing-page: 1
elementor_font: 1
elementor_library: 18
nav_menu_item: 38
page: 27
post: 1
postman_sent_mail: 7
product: 12
product_variation: 37
revision: 3341
shopengine-template: 2
shop_coupon: 1
shop_order: 139
shop_subscription: 10
wc_memberships_team: 10
wc_membership_plan: 5
wc_user_membership: 10
wp_global_styles: 2

### Security ###

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

### Active Plugins (22) ###

Akeeba Backup Professional for WordPress: by Akeeba Ltd – 7.6.10
All In One WP Security: by All In One WP Security & Firewall Team – 4.4.12
Simple Custom CSS and JS: by SilkyPress.com – 3.40
Dynamic Visibility for Elementor: by Dynamic.ooo – 5.0.1
Elementor Pro: by Elementor.com – 3.7.3
Elementor: by Elementor.com – 3.7.0
Favicon by RealFaviconGenerator: by Philippe Bernard – 1.3.25
JetTabs For Elementor: by Crocoblock – 2.1.18
Loco Translate: by Tim Whitlock – 2.6.2
Price By Quantity For WooCommerce: by WebMeteors – 1.0.3
SVG Support: by Benbodhi – 2.4.2
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.22.14.25

Quantity Plus Minus Button for WooCommerce: by CodeAstrology – 1.1.1
WooCommerce Stripe Gateway: by WooCommerce – 6.5.1
Teams for WooCommerce Memberships: by SkyVerge – 1.6.2
WooCommerce Memberships: by SkyVerge – 1.23.0
WooCommerce PayPal Payments: by WooCommerce – 1.9.2
Invoices for WooCommerce Premium: by Bas Elbers – 2.1.1
Invoices for WooCommerce: by Bas Elbers – 3.1.9
WooCommerce Subscriptions: by WooCommerce – 4.5.0
WooCommerce: by Automattic – 6.8.0
WP Mail SMTP: by WPForms – 3.5.1

### Inactive Plugins (5) ###

Check & Log Email: by WPChill – 1.0.6
Custom Fields for WooCommerce: by Addify – 1.0.2
LiteSpeed Cache: by LiteSpeed Technologies – 5.1
User Switching for WooCommerce: by Krokedil – 2.0.2
WooCommerce Checkout Field Editor: by WooCommerce – 1.7.3

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

Admin language fix for elementor: by Ashley from @crazypsycho Github – 1.0.0
akeeba-backup-coreupdate.php: by  –

### Settings ###

API Enabled: –
Force SSL: ?
Currency: EUR (€)
Currency Position: right
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: #1578 - /suscripcions/
Basket: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #1581 - /my-account/
Terms and conditions: #907 - /terminos-y-condiciones/

### Theme ###

Name: Hello Elementor Child
Version: 1.0.1
Author URL: https://elementor.com/
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 2.6.1
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ?

### Templates ###

Overrides: –

### Memberships ###

Restriction mode:: Hide completely
Public content:: –
Excluded from discounts:: –
Membership plans:: 5
Canal Custom:: Members: 1Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: Yes
Multicanal:: Members: 4Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: Yes
Multicanal Plus:: Members: 0Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: Yes
Multicanal Free:: Members: 2Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: Yes
Multicanal Esencial:: Members: 3Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No

### Subscriptions ###

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://www.musicologic.es
Subscription Statuses: wc-active: 1
wc-cancelled: 9

WooCommerce Account Connected: ? Yes
Active Product Key: ? Yes
Custom Retry Rules: ? No
Custom Retry Rule Class: ? No
Custom Raw Retry Rule: ? No
Custom Retry Rule: ? No
Retries Migration Status: ? Completed
Report Cache Enabled: ? Yes
Cache Update Failures: ? 0 failure

### Store Setup ###

Country / State: Spain — Alicante

### Subscriptions by Payment Gateway ###

Stripe: wc-active: 1
wc-cancelled: 9

### Payment Gateway Support ###

Stripe: products
refunds
tokenization
add_payment_method
subscriptions
subscription_cancellation
subscription_suspension
subscription_reactivation
subscription_amount_changes
subscription_date_changes
subscription_payment_method_change
subscription_payment_method_change_customer
subscription_payment_method_change_admin
multiple_subscriptions

### WooCommerce PayPal Payments ###

Onboarded: –
Shop country code: ES
WooCommerce currency supported: ?
PayPal card processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: –
Vault enabled: –
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
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-08-11 18:57:42 +02:00
Options: ?
Notes: 29
Onboarding: skipped

### Action Scheduler ###

Canceled: 2
Oldest: 2022-07-14 00:09:09 +0200
Newest: 2022-07-19 23:05:05 +0200

Complete: 567
Oldest: 2022-08-02 15:39:40 +0200
Newest: 2022-08-10 21:51:04 +0200

Pending: 3
Oldest: 2022-08-11 17:51:51 +0200
Newest: 2022-09-10 21:25:31 +0200

### Status report information ###

Generated at: 2022-08-11 01:50:14 +02:00

Hello,

I’m wondering if WC has a cache somewhere I can purge

Can you please navigate to WooCommerce > Status > Tools, and Clear analytics cache to see if that helps?

Link to image: https://snipboard.io/4qUvnL.jpg

Hi
I created a staging site for you to play with and what do you know it has the correct info on the customer page – haha

I will try your suggestion re analytics cache

Rgds
Ashley

Ok, just checked again and the info has updated on its own on my actual site as well

Wish I knew how long it took to update!

Must be a cache somewhere but don’t know

Maybe I’ll get time to play with the staging site and can find out

Probably a scheduled action not getting triggered

I have few site visitors whilst developing, so had set up a cronjob to call wp-cron every 20 minutes instead

Thanks for your time

Ashley

• This reply was modified 2 years, 7 months ago by ashleyinspain.

Hi
I tested your suggestion on the staging site
Unfortunately, it did not work
Neither did ‘Reimporting Historical Data’

I edited one of the user’s email addresses, it did not automatically update the customer lookup table or the Customer Page displayed data

I was playing in the actual site database yesterday; I may have changed the email there manually and that made it look like it’s fixed itself!!! – I cloned the staging site this morning so would have included anything I did yesterday – ouffff

Have to keep testing – patience – test one change at a time

I think I will wait till tomorrow to see if the changed email in the staging site updates overnight

Best regards
Ashley

Hi Ashley,

From what you describe this could be likely caused by a conflict with your theme or with another plugin.

Could you please perform a conflict test by following the steps below?

• Temporarily switch your theme to Storefront
• Disable all plugins except for WooCommerce
• Repeat the action that is causing the problem

If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated.

To figure out which plugin is causing the problem, reactivate your theme first and check again. Then, your other plugins one by one, testing after each, until you find the one causing conflict.

You can find a more detailed explanation on how to do a conflict test here https://docs.woocommerce.com/document/how-to-test-for-conflicts.

Let us know how it goes.

Hi Mirko

Sounds like a canned response to me, step 3 on the script!

Do you actually know how the Customers report is generated or changed? If not escalate this ticket

I have done loads of researching and testing and discovered

The Customers Report Page updates ONLY on each and every new purchase

If you are registered and change your email address for instance, this is the issue I was having, it does not update on the Customers Report Page until you make a new purchase, when it does update the data stored in the DB and displayed on the Customers page

I find this somewhat problematic

I feel that any change should be updated immediately in the _wc_customer_lookup table in the DB customer and also the customer report page

Otherwise you can be looking at out of date information about your customers in the customers report page

If this is above your normal scope of support please escalate to someone how can discuss this with me

Best regards

Ashley

Hi there @ashleyinspain!

Thank you for getting back.

I believe the Customers data under WP Admin > WooCommerce > Customers is stored as transient with prefix _transient_wc_report_customers_ in wp_options table.

You can try clearing WooCommerce transients from WooCommerce > Status > Tools or delete the option named _transient_wc_report_customers_ in wp_options table using a plugin like phpMyAdmin to see updated information.

I hope this helps! ??

Hi Kaushik

Thanks for your input

I have found the data stored as a transient in the wp_options table as you said

How is it regenerated if I delete it

I’m always concerned with consequences

I don’t want to end up with no customer data

In Admin > WooCommerce > Status > Tools there is a way to delete and regenerate this data for Products why not for Customers data

Best regards

Ashley
PS What is the purpose of the Customers Lookup table if the info is kept as a transient in the wp-options table
I understand both are a sort of cache

Hi Ashley

How is it regenerated if I delete it

Transients are temporary caches that can be stored in database for quick access, deleted and regenerated. So if you delete that and navigate to WP Admin > WooCommerce > Customers, the system will generate the entry again, and on the next page load (for the same page), WooCommerce will take the data from the transient.

This can be helpful with certain lengthy calculations such as Total Spent for example. If transients were absent, the code for calculating Total spent will run on every page load and consume server resources.

In Admin > WooCommerce > Status > Tools there is a way to delete and regenerate this data for Products why not for Customers data

Currently, there isn’t any such tool, but you can raise a feature request on the WooCommerce Github repository here: https://github.com/woocommerce/woocommerce/issues

I hope this helps! ??