Strange WooCommerce database related issue

  • Resolved szepesif

    (@szepesif)


    4 years, 11 months ago

    I have a strange WooCommerce issue on one of my sites. It’s a popular webshop with thousands of products. Most likely the issue is there for a long time but we just noticed it.

    The problem: A lot of products are not showing up on the frontend. All of those are visible in the backend, all of them are live, all of those are in stock. So they should show up. Some of the store products are visible, some of them are not. There’s no logic in this. BUT… if I just edit a missing product and just simply re-save it in the backend it shows up in the frontend right away.

    Most likely the issue is related to the 2.x to 3.x database upgrade: “3.0.0 instroduces a new product visibility taxonomy; catalog, search, hidden, featured, outofstock are terms. These are set on upgrade and help filter products in the catalog during frontend queries.”

    My theory is that this database upgrade didn’t finish at that time for some reason.

    So the solution would be to run it again or to find an automatic way to emulate the “save” feature that I do manually if I edit and save a missing product in the backend. But the manual way is simply not an option when I have thousands of products.

    I just want all available products to appear in the frontend too. Do you have any idea how can I solve this?

    P.s: I have already tried switching back to a default theme and disabling every other plugin except WooCommerce. It’s clearly a database related WooCommerce issue. And yes, I have the latest WP and the latest 3.x Woo. The PHP version is 7.2.

    Thank you in advance!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support fevered – a11n

    (@fevered)

    Hey there!

    From what you’ve described, this does sound like a database issue. I don’t know of an existing way to run an update on all the products in your store, but that’s likely something a developer could write a script for. There is some code here which could get you started on a script for that: https://stackoverflow.com/questions/50633551/update-the-product-visibility-in-woocommerce-3

    Another option would be to directly update the products in the database without a script, which would be quicker than individually updating the products but would still take more time than a written script

    Plugin Support fevered – a11n

    (@fevered)

    Hey there, since I haven’t heard back from you I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Strange WooCommerce database related issue’ is closed to new replies.