Just ran data update, some products vanished!

  • Resolved stratocaster

    (@stratocaster)


    5 years, 9 months ago

    Woocommerce data update – We need to update your store’s database to the latest version.

    So, I backed up my database, then ran the data update. All seemed ok, but now I notice on one of my categories, which should have 170+ products listed, there are only 38 showing now.
    Not just on front end, but also in the dashboard, it shows that there are only 38 products in that category.

    So I restored the db backup, but its still the same. I checked the db tables and in wp_posts I can see the entries for all the missing products are there, altho their valies in post_status column have a value of “inherit”, whereas those that I can see on the site have a value of “publish”. Also in post_parent column, those that are missing have a value of 140, where as those that I can see on the site have a value of 0.

    However, changing any of these values does nothing. I don’t want to just re-list the missing products, because I can see that they are already in the db, just for some reason they are not being fetched.

    I checked on a Woo Help facebook group and it seems that others are having the same experience. Any idea what is causing this?

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Hari Shanker R

    (@harishanker)

    Hi @stratocaster

    This definitely is an odd problem, going by your description of the same. I took a look at the link you shared: This definitely is an odd problem, going by your description of the same.

    I took a look at the link you shared to learn more about the troubles: https://www.ncolondon.com/product-category/gelesse/

    It looks like you were able to have the problem fixed, as I could see in this screenshot. If the problem comes back though, feel free to let us know. I’m marking this as Resolved for now, but feel free to reply if the problem seems to come back.

    Thread Starter stratocaster

    (@stratocaster)

    Yes, I just re-loaded the products. The only thing I can think of was maybe something happened to the backup db. All seems to be working as it should, so I’m happy now.

    Thakns for your attention ??

    Moderator Hari Shanker R

    (@harishanker)

    Hi @stratocaster I’m glad to hear that you got that sorted. And the backup db definitely might have been the cause of the troubles here.

    Feel free to drop us a line here if the problem persists, we are happy to look into this.

    All the best!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Just ran data update, some products vanished!’ is closed to new replies.