Support » Plugin: WooCommerce » Product categories + products disappeared

  • Resolved stanleyuroy11

    (@stanleyuroy11)


    Hi all,

    I need your help.

    My product categories and products have disappeared, and this is not the first time. However, the products pulled various categories to build the home page remained.

    Then, after a few minutes, everything then returned. This probably the 3rd time it has occurred. All product categories showed (0)but a while the site then returned to normal.

    What is actually happening? Please, your help counts! Anyone with similar experiences? Would you mind to share how your case was resolved?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support MayKato woo-hc

    (@maykato)

    Hello,

    As a first step, could you please 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.

    Thread Starter stanleyuroy11

    (@stanleyuroy11)

    Hi Maykato,

    Thank you for the response. Below is the report. I have kept the domain private for security reasons as the site is not trading yet

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://xxxxx.com
    Site address (URL): https://xxxxx.com
    WC Version: 5.9.0
    REST API Version: ✔ 5.9.0
    WC Blocks Version: ✔ 6.1.0
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 2.8.0
    Log Directory Writable: ✔
    WP Version: 5.8.2
    WP Multisite: –
    WP Memory Limit: 3 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.25
    PHP Post Max Size: 2 GB
    PHP Time Limit: 300
    PHP Max Input Vars: 6000
    cURL Version: 7.80.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.5.13-MariaDB
    Max Upload Size: 1 GB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.9.0
    WC Database Prefix: wpmr_
    Total Database Size: 136.58MB
    Database Data Size: 124.20MB
    Database Index Size: 12.38MB
    wpmr_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_actionscheduler_actions: Data: 0.24MB + Index: 0.12MB + Engine MyISAM
    wpmr_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_actionscheduler_logs: Data: 0.18MB + Index: 0.14MB + Engine MyISAM
    wpmr_bp_activity: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_bp_activity_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_invitations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_notifications_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_xprofile_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_xprofile_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_bp_xprofile_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_bp_xprofile_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_ce4wp_abandoned_checkout: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpmr_countries: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wpmr_eg_grids: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_eg_item_elements: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_eg_item_skins: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    wpmr_eg_navigation_skins: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpmr_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpmr_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpmr_geodir_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_attachments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_custom_sort_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_gd_place_detail: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_post_review: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_geodir_tabs_layout: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_layerslider: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
    wpmr_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_litespeed_avatar: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_litespeed_img_optm: Data: 12.53MB + Index: 4.19MB + Engine MyISAM
    wpmr_litespeed_img_optming: Data: 0.58MB + Index: 0.17MB + Engine MyISAM
    wpmr_litespeed_url: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
    wpmr_litespeed_url_file: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wpmr_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_masterslider_options: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpmr_masterslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_mclean_refs: Data: 0.21MB + Index: 0.07MB + Engine MyISAM
    wpmr_mclean_scan: Data: 0.51MB + Index: 0.11MB + Engine MyISAM
    wpmr_nf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_action_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpmr_nf3_chunks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_field_meta: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpmr_nf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_form_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpmr_nf3_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_object_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_nf3_upgrades: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wpmr_options: Data: 9.41MB + Index: 0.16MB + Engine MyISAM
    wpmr_postmeta: Data: 78.79MB + Index: 4.28MB + Engine MyISAM
    wpmr_posts: Data: 18.72MB + Index: 1.88MB + Engine MyISAM
    wpmr_rank_math_analytics_gsc: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_rank_math_analytics_objects: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
    wpmr_rank_math_internal_links: Data: 0.21MB + Index: 0.05MB + Engine MyISAM
    wpmr_rank_math_internal_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpmr_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpmr_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_sliders: Data: 0.10MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_slides: Data: 0.76MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_slides_bkp: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_shortpixel_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_shortpixel_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_signups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_termmeta: Data: 0.33MB + Index: 0.15MB + Engine MyISAM
    wpmr_terms: Data: 0.08MB + Index: 0.17MB + Engine MyISAM
    wpmr_term_relationships: Data: 0.06MB + Index: 0.13MB + Engine MyISAM
    wpmr_term_taxonomy: Data: 0.23MB + Index: 0.10MB + Engine MyISAM
    wpmr_usermeta: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    wpmr_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_user_registration_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_vi_wad_ali_orders_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_vi_wad_ali_shipping_info: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpmr_vi_wad_error_product_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wacv_abandoned_cart_record: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wacv_cart_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wacv_email_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wacv_guest_info_record: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_product_meta_lookup: Data: 0.29MB + Index: 0.30MB + Engine MyISAM
    wpmr_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpmr_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wotv_woo_track_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_customers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_customer_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_wpcommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpmr_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    amp_validated_url: 4
    attachment: 9563
    bp-email: 15
    cause: 10
    custom_css: 2
    dict_event: 31
    dict_gallery: 12
    dict_portfolio: 28
    dict_services: 7
    dict_team: 11
    dict_testimonials: 3
    dslc_downloads: 8
    dslc_hf: 6
    dslc_partners: 10
    dslc_projects: 6
    dslc_staff: 8
    dslc_templates: 9
    dslc_testimonials: 8
    elementor_library: 1
    mc4wp-form: 2
    nav_menu_item: 147
    oembed_cache: 3
    page: 37
    post: 9
    product: 251
    product_variation: 2259
    project: 10
    revision: 547
    seedprod: 1
    shop_order: 19
    ts_footer_block: 12
    ts_logo: 5
    ts_portfolio: 12
    ts_team: 6
    ts_testimonial: 6
    user_registration: 1
    vi_wad_draft_product: 410
    viwec_template: 14
    wacv_email_template: 3
    wpcf7_contact_form: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (23) ###
    
    Redux: by Extendify – 4.3.3
    AMP: by AMP Project Contributors – 2.1.4
    PublishPress Capabilities: by PublishPress – 2.3
    Contact Form 7: by Takayuki Miyoshi – 5.5.2
    Envato Market: by Envato – 2.0.6
    Site Kit by Google: by Google – 1.45.0
    Jetpack: by Automattic – 10.3
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.7.0
    LiteSpeed Cache: by LiteSpeed Technologies – 4.4.3
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6
    Minimal Coming Soon & Maintenance Mode: by WebFactory Ltd – 2.33
    Product Variations Swatches for WooCommerce: by VillaTheme – 1.0.1.16
    Slider Revolution: by ThemePunch – 6.5.8
    Rank Math SEO: by Rank Math – 1.0.76.1
    ThemeSky: by ThemeSky Team – 1.1.6
    WPC Product Bundles for WooCommerce: by WPClever – 5.9.7
    ALD - Aliexpress Dropshipping and Fulfillment for WooCommerce: by VillaTheme(villatheme.com) – 1.0.6
    WooCommerce Stripe Gateway: by WooCommerce – 5.7.0
    WooCommerce: by Automattic – 5.9.0
    Smush: by WPMU DEV – 3.9.2
    YITH WooCommerce Compare: by YITH – 2.8.0
    YITH WooCommerce Frequently Bought Together: by YITH – 1.7.0
    YITH WooCommerce Wishlist: by YITH – 3.3.0
    
    ### Inactive Plugins (13) ###
    
    Abandoned Cart Recovery for WooCommerce: by VillaTheme – 1.0.4.6
    Akismet Anti-Spam: by Automattic – 4.2.1
    Email Template Customizer for WooCommerce: by VillaTheme – 1.1.0
    Facebook for WooCommerce: by Facebook – 2.6.7
    Google Listings and Ads: by WooCommerce – 1.6.0
    Mailchimp for WooCommerce: by Mailchimp – 2.5.3
    One Click Demo Import: by OCDI – 3.0.2
    Orders Tracking for WooCommerce: by VillaTheme – 1.1.9
    Photo Reviews for WooCommerce: by VillaTheme – 1.1.4.3
    StoreCustomizer: by Kaira – 2.3.5
    W3 Total Cache: by BoldGrid – 2.1.9
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
    YITH WooCommerce Quick View: by YITH – 1.9.0
    
    ### Dropin Plugins (1) ###
    
    object-cache.php: object-cache.php
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: GBP (£)
    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)
    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: –
    
    ### WC Pages ###
    
    Shop base: #51 - /shop/
    Cart: #52 - /cart-2/
    Checkout: #53 - /checkout-2/
    My account: ❌ Page does not contain the [woocommerce_my_account] shortcode.
    Terms and conditions: #60935 - /terms-and-conditions/
    
    ### Theme ###
    
    Name: MyMedi Child
    Version: 1.0.0
    Author URL: http://theme-sky.com/
    Child Theme: ✔
    Parent Theme Name: MyMedi
    Parent Theme Version: 1.2.4
    Parent Theme Author URL: http://theme-sky.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: mymedi/woocommerce/archive-product.php
    mymedi/woocommerce/content-product-cat.php
    mymedi/woocommerce/content-product.php
    mymedi/woocommerce/content-widget-product.php
    mymedi/woocommerce/loop/add-to-cart.php
    mymedi/woocommerce/loop/loop-end.php
    mymedi/woocommerce/loop/loop-start.php
    mymedi/woocommerce/loop/orderby.php
    mymedi/woocommerce/loop/rating.php
    mymedi/woocommerce/single-product/add-to-cart/variable.php
    mymedi/woocommerce/single-product/rating.php
    mymedi/woocommerce/single-product/tabs/description.php
    mymedi/woocommerce/single-product/tabs/tabs.php
    mymedi/woocommerce/single-product.php
    
    ### Action Scheduler ###
    
    Canceled: 1
    Oldest: 2021-11-18 09:59:53 +0000
    Newest: 2021-11-18 09:59:53 +0000
    
    Complete: 856
    Oldest: 2021-11-17 06:13:29 +0000
    Newest: 2021-11-18 10:12:43 +0000
    
    Pending: 1
    Oldest: 2021-11-20 18:43:27 +0000
    Newest: 2021-11-20 18:43:27 +0000
    
    ### Status report information ###
    
    Generated at: 2021-11-18 17:29:42 +00:00
    
    Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hello @stanleyuroy11

    I’m not seeing anything particular on your System Status Report that may be causing this strange behavior. You’re running updated versions of WordPress and WooCommerce. Also, your database is showing data for product categories and all other custom taxonomies.

    This kind of problem is usually caused by a conflict with your theme or with another plugin. I’d suggest installing a plugin called WP Staging to create a duplicate/staging site with a few clicks. Then, you could perform a full conflict test on your staging site:

    • 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 behavior after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated.

    Reactivate the theme first and check again. Then, go on and reactivate 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/

    Once you have identified the culprit on your staging site and disabled the tool/plugin that is causing trouble and everything is working properly, it is recommended that you make the changes on your production site as well.

    Don’t forget to backup your site content and database before making any changes.

    Let us know how that goes.

    Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hi there,

    It’s been a while since we last heard from you, so I’m marking this thread as resolved.

    Hopefully, you’ve been able to resolve this, but we’ll be here if and/or when you are ready to continue.

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