All orders showing as guest and order amounts have disappeared

  • Resolved thecalicotree

    (@thecalicotree)


    9 years, 1 month ago

    HI,

    My client has just pointed out that all of their orders are missing customer information – all showing Guest. The products are still there but all order amounts have been zeroised.

    Understandably they are freaking out yet neither of us have changed a thing. I just updated to 2.5.1 to see if that fixed things but it’s made no difference.

    Has anyone experienced this before?

    HELP!!

    Thanks

    Helen

    https://www.ads-software.com/plugins/woocommerce/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    Data cannot delete itself, so you may want to first check if a plugin you have installed is hiding said data. Disable plugins and check again.

    The actual data is stored in wp_posts and wp_postmeta tables. The only way this could be removed is manually, or uninstalling woocommerce.

    Thread Starter thecalicotree

    (@thecalicotree)

    The data all exists (customers are all still listed int he Users screen with a status of customer).

    It’s bizarre to disappear all of a sudden is it not when no updates have been made to plugins/themes etc?

    Plugin Contributor Mike Jolley

    (@mikejolley)

    The address information per-order is stored in postmeta, not user tables. Perhaps your client did update something without telling you.

    Thread Starter thecalicotree

    (@thecalicotree)

    Yes that is possible – thank you. Do you know how to interrogate the postmeta table to see if the address information still exists?

    Plugin Contributor Mike Jolley

    (@mikejolley)

    Look for a meta_key of _billing_address_1 for example for any order.

    Thread Starter thecalicotree

    (@thecalicotree)

    So having gone into phpAdmin and tried to query that table I got an error:
    #144- Table ‘./wp_postmeta’ is marked as crashed and last (automatic?) repair failed.

    I’ve raised a ticket with my server support guys.

    Thanks for your help.

    Plugin Contributor Mike Jolley

    (@mikejolley)

    That would explain it ?? Good luck!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘All orders showing as guest and order amounts have disappeared’ is closed to new replies.

Tags