Support » Plugin: WooCommerce » Category shows product count but is empty

  • Resolved barkingbird

    (@barkingbird)


    Some categories show a product count, such as seen in this screenshot: https://prnt.sc/FJUg53nnTcz2

    But when I click on the product count number, the resulting page is blank, as seen in this screenshot: https://prnt.sc/ezp2hE-lDOlA

    To troubleshoot, I have:
    disabled all plugin,s except WooCommerce
    switched to Storefront theme
    cleared all transients
    recounted terms
    optimized the database tables

    ******************************

    Below is the System Report if helpful

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://otrtiresnewdev.wpengine.com
    Site address (URL): https://otrtiresnewdev.wpengine.com
    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: 768 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_US
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 8.0.20
    PHP Post Max Size: 256 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 10000
    cURL Version: 7.74.0
    OpenSSL/1.1.1n
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.38-41-log
    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.8.0
    WC Database Prefix: wp_
    Total Database Size: 3829.56MB
    Database Data Size: 2483.10MB
    Database Index Size: 1346.46MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.34MB + Index: 0.22MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    admin_role: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    otr_product_data: Data: 1.52MB + Index: 0.09MB + Engine InnoDB
    otr_product_posts: Data: 0.25MB + Index: 0.16MB + Engine InnoDB
    simpletire_brand_markup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    simpletire_environment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    simpletire_product_markup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    simpletire_product_posts: Data: 12.52MB + Index: 10.06MB + Engine InnoDB
    staging_products: Data: 23.55MB + Index: 1.52MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.05MB + Index: 0.13MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.31MB + Index: 0.17MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 124.66MB + Index: 79.16MB + Engine InnoDB
    wp_ac_abandoned_cart_history_lite: Data: 60.58MB + Index: 0.00MB + Engine InnoDB
    wp_ac_email_templates_lite: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wp_ac_guest_abandoned_cart_history_lite: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.20MB + Index: 0.09MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 0.31MB + Index: 0.06MB + Engine InnoDB
    wp_gf_entry_meta: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_view: Data: 0.19MB + Index: 0.14MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 2.52MB + Index: 0.38MB + Engine InnoDB
    wp_pantheon_sessions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_postmeta: Data: 1160.00MB + Index: 482.98MB + Engine InnoDB
    wp_posts: Data: 112.64MB + Index: 43.13MB + Engine InnoDB
    wp_pv_am_activities: Data: 54.56MB + Index: 10.55MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_redirection_404: Data: 2.52MB + Index: 0.45MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_termmeta: Data: 7.52MB + Index: 7.03MB + Engine InnoDB
    wp_terms: Data: 7.52MB + Index: 7.03MB + Engine InnoDB
    wp_term_relationships: Data: 100.67MB + Index: 52.59MB + Engine InnoDB
    wp_term_taxonomy: Data: 9.52MB + Index: 10.03MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wp_users: Data: 0.33MB + Index: 0.20MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_gpf_render_cache: Data: 62.58MB + Index: 3.52MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 20.55MB + Index: 26.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_meta_data: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_meta_values: Data: 1.52MB + Index: 1.97MB + Engine InnoDB
    wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    wp_wps_index: Data: 277.81MB + Index: 277.97MB + Engine InnoDB
    wp_wps_key: Data: 7.52MB + Index: 4.52MB + Engine InnoDB
    wp_wps_object_term: Data: 59.59MB + Index: 100.22MB + Engine InnoDB
    wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wt_iew_action_history: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yarpp_related_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_indexable: Data: 327.89MB + Index: 186.48MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 29.55MB + Index: 32.55MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 417
    acf-field-group: 25
    attachment: 287242
    custom_css: 1
    export_template: 2
    filter-field: 1
    filter-set: 1
    nav_menu_item: 41
    page: 60
    post: 29
    product: 55021
    revision: 5
    seedprod: 2
    shop_coupon: 1
    shop_order: 122
    shop_order_refund: 7
    team: 1
    team-member: 4
    testimonial: 5
    wcpf_item: 5
    wcpf_project: 2
    wp_block: 2
    wp_global_styles: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (2) ###
    
    WooCommerce: by Automattic – 6.8.0
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.6
    
    ### Inactive Plugins (43) ###
    
    Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.12.0
    Advanced Custom Fields: Font Awesome: by Matt Keys – 4.0.3
    Advanced Custom Fields: Gravityforms Add-on: by Say Hello GmbH – 1.3.4
    Advanced Custom Fields PRO: by Delicious Brains – 5.12.2
    Akismet Anti-Spam: by Automattic – 5.0
    Argument test: by Jitendra Kelhe –
    Better Search Replace: by Delicious Brains – 1.4.1
    Classic Widgets: by WordPress Contributors – 0.3
    Column Shortcodes: by Codepress – 1.0.1
    Filter Everything — WooCoomerce Product & WordPress Filter: by Andrii Stepasiuk – 1.6.8
    Gravity Forms: by rocketgenius – 2.3.2.10
    Import Export for WooCommerce Wrapper: by WebToffee – 1.1.5
    Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.3.3
    Import OTR Tire products: by Jitendra Kelhe –
    Import SimpleTire products: by Jitendra Kelhe –
    MainWP Child: by MainWP – 4.2.4
    Nested Pages: by Kyle Phillips – 3.1.22
    OTR Request for quote plugin: by Jitendra Kelhe – 1.0.1
    OTR Simpletire Markup Management: by Jitendra Kelhe – 1.0.0
    OTR Tire live price & quantity verification: by Jitendra Kelhe –
    Product Filter by WooBeWoo: by WooBeWoo – 2.1.6
    Product Filters for WooCommerce: by WooCommerce – 1.3.2 (update to version 1.3.6 is available)
    Product Import Export for WooCommerce Add-on: by WebToffee – 1.1.2
    Rank Math SEO: by Rank Math – 1.0.95
    Rank Math SEO PRO: by Rank Math – 3.0.15.1
    Redirection: by John Godley – 5.3.2
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
    Toolbar Publish Button: by wpUXsolutions – 1.8
    Upload Brand Logo: by Jitendra Kelhe – 1.0.0
    User Role Editor: by Vladimir Garagulya – 4.63
    WooCommerce - Product Importer Deluxe: by Visser Labs – 3.8.2
    WooCommerce - Store Exporter Deluxe: by Visser Labs – 5.2.1
    WooCommerce AvaTax: by SkyVerge – 1.16.0 (update to version 1.16.3 is available)
    WooCommerce Blocks: by Automattic – 8.2.1
    WooCommerce Product Search: by itthinx – 4.7.0
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.3
    WooCommerce Stripe Gateway: by WooCommerce – 6.4.3
    WPCode - Insert Headers, Footers, and Code Snippets: by WPCode – 2.0.1
    WP Crontrol: by John Blackbourn & crontributors – 1.14.0
    WP Engine Smart Plugin Manager: by WP Engine – 5.10.33
    Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
    Yoast SEO: by Team Yoast – 19.5.1
    Yoast SEO Premium: by Team Yoast – 18.1
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    object-cache.php: Memcached Redux
    
    ### Must Use Plugins (7) ###
    
    Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0
    Pantheon: by Pantheon – 0.1
    WPE ElasticPress Autosuggest Logger: by WP Engine – 1.0.0
    WP Engine Cache Plugin: by WP Engine – 1.0.10
    WP Engine Seamless Login Plugin: by WP Engine – 1.6.0
    WP Engine Security Auditor: by wpengine – 1.0.10
    WP Engine System: by WP Engine – 5.0.1
    
    ### 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)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    instock (instock)
    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: #703 - /shop
    Cart: #704 - /cart
    Checkout: #705 - /checkout
    My account: #706 - /my-account
    Terms and conditions: #2332 - /terms
    
    ### Theme ###
    
    Name: Storefront
    Version: 4.1.2
    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
    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-13 03:13:13 +00:00
    Options: ✔
    Notes: 93
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 43
    Oldest: 2022-07-12 16:19:02 +0000
    Newest: 2022-08-12 12:52:03 +0000
    
    Failed: 8
    Oldest: 2021-06-09 13:32:50 +0000
    Newest: 2021-06-09 13:32:50 +0000
    
    Pending: 1
    Oldest: 2022-08-12 17:06:03 +0000
    Newest: 2022-08-12 17:06:03 +0000
    
    ### Status report information ###
    
    Generated at: 2022-08-12 13:00:04 +00:00
    
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hi @barkingbird!

    Thanks for getting in touch.

    That’s really annoying – can you click on the product category name and then the ‘Update’ button on the next page without making any actual changes? I’ve seen this method work for users reporting a similar issue.

    If nothing changes, please reach out to your host and ask them to clear and temporarily pause the cache system as it may be cache related.

    Thanks.

    Thread Starter barkingbird

    (@barkingbird)

    Thanks – I tried that but it did not resolve the issue. The host cleared all of the caches, disabled Object Caching. Still have the same problem.

    Do you have any other ideas to fix this?

    Hi @barkingbird

    It looks like your site currently has the WooCommerce plugin disabled. Can you please enable again, and then send us a link to the product that’s in the Aderenza category so we can take a look?

    Thread Starter barkingbird

    (@barkingbird)

    Hi MayKato. That is the problem. There is no product in the Aderenza category. Doing a search for Aderenza in Products also shows no results. After all of the troubleshooting I’ve done as described at the top of this thread, do you know how I can resolve this? There are over 53,000 products and over 600 categories, so manually fixing this one at a time really is not an option. Thanks!

    Plugin Support Sunday Ukafia (a11n)

    (@sukafia)

    Hi @barkingbird,

    Just to be sure I understand correctly, if you go to Products > Categories, you’re seeing the product count but clicking on it doesn’t lead you to the products, correct?

    If that’s indeed the case:

    1) Can you confirm going to Products > All Products and filtering by category doesn’t return the products too?

    2) Can you go to Products > Export, and export all products in that category to a CSV and let me know what you find?

    3) You mentioned recounting terms, did you try to “Regenerate” Product lookup tables?

    4) Can you provide some insights into how the products in the category were created? were they imported or created directly on the site?

    5) Lastly, did you make any modifications to your database or performed a site migration prior to this?

    We await your response to better assist you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.