Problem with products not showing in category

  • Resolved zacvasiliki

    (@zacvasiliki)


    2 years, 10 months ago

    Hello there

    Few months ago I created a store with woocommerce and I have an issue that still haven’t found any solution and still not sure what is causing this issue.

    I have multiple categories with many products in each category. Every now and then these products disappear for no reason. They are public but they don’t show up in category or on search bar.

    After many hours of research I have only found that the only way to make those product appear in the category and in search, is by going on products and make them a feature products or un-featured the products if they already featured, or do any other change on those product ( I just found that fastest way was to featured or unfeatured them)

    If I do that , it’s like make the database or the products to wake up and show up again on the store. The point here is that when this happens and products deseappear , I have to make a change on the product in order to make them show up, otherwise products will stay hided.

    I’m not sure what is causing this issue but I have a thought which I haven’t check it yet. I think that this happens whenever there is a new woocommerce update and when I do the update and update database. but still not sure about that, I will check it on the next woocommerce update if happen again.

    However the funny about this issue is that on staging site , products are not disappered from categories and in general staging site it seems that it hasn’t got this issue with the products. (staging is hosted on same server)

    So the first question is this:

    1) is anybody have faced the same issue and if yes, is there any solution?

    2) Is there anybody can help me with SQL query that i can run on database table that select all the products and make them featured or make them unfeatured at once? (This will save me a lot of time, because every time this happens , I have to select products in bulk on each category and save changes, then move to next page to the same etc… it’s hard to do for 30k products.)

    I will aprreciate any help.

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @zacvasiliki,

    A lot of times if something is disappearing off a category, it is usually something in the theme, or a different plugin/code that is causing them to randomly disappear – especially if getting them back is by altering them via setting as a feature product or un-featured the product if it is already featured.

    If this happens again, try to switch your theme temporarily to something like Storefront or Twenty Twenty One, and see if the products show back up. If you have a test/staging site, see if the same exact issue occurs, and then switch the theme and leave it to see if it happens again. If it does not, then it is something with the theme. If it does, disable items down to WooCommerce, and see if the products/category show back up. Should it show up, see if it disappears again.

    You can read more about plugin and theme conflicts here:
    ?https://docs.woocommerce.com/document/woocommerce-self-service-guide/

    As mentioned above, we do *highly* recommend a staging site for these tests so that your Live site is unaffected. A staging site is a clone or copy of the Live site, used for testing. You can reach out to your Host if you need to have a staging site set up, as they usually can assist you with this.

    Let us know the results!

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    It’s been a while since we last heard back from you. I’m going to mark this thread as resolved.

    Hopefully, you were able to find a way forward with the issue – we’ll be here if you need further assistance.

    Best regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Problem with products not showing in category’ is closed to new replies.