Category shows product count but is empty

  • Resolved barkingbird

    (@barkingbird)


    2 years, 7 months ago

    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)
  • Mirko P.

    (@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!

    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)
  • The topic ‘Category shows product count but is empty’ is closed to new replies.