Order Status in DB Incorrect

  • Resolved perchpole

    (@perchpole)


    1 year ago

    A customer order was not showing on either the front end or the admin area. I elected to search for it in the DB. It soon became apparent that the reason why the order was not showing was because the “post_status” in wp_posts was showing “pending”. The correct entry should be “wc-pending”. Once I had edited this manually, the order was again visible.

    After further investigations, I found 2 more orders (out of 500+) with a similar issue.

    What could have caused the DB entry to be written incorrectly?

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

Viewing 1 replies (of 1 total)

  • Hi @perchpole

    Thanks for reaching out!

    This is quite strange that a certain order is not showing under WooCommerce > Orders, however, visible on the database and has a post_status showing pending instead of wc-pending

    You’ve mentioned that there were 2 orders out of 500 that has the same issue. Can you please check these orders and see if there are any similarities to these orders like, same products, same product type, same categories, same customer, same shipping location, same payment gateway, etc?

    Otherwise, I would suggest replicating the exact same orders once again and see if you are able to reproduce the issue here?

    If so, it looks like a third-party plugin or your theme might be causing the conflict here.

    For us to investigate this further, can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled, repeat the steps of replicating the same order and see if these are orders are now showing under WooCommerce > Orders?

    If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

    If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

    You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Or, if you’d like someone else to do this work for you, our trusted partner, Codeable, has an offering where they will run this test for $150 USD. If there is time left, they will also fix the problems they found.

    Let us know how it goes!

Viewing 1 replies (of 1 total)
  • The topic ‘Order Status in DB Incorrect’ is closed to new replies.