Orders missing items in admin area after update

  • sorincoza

    (@sorincoza)


    8 years, 10 months ago

    I updated to version 3, then run the database update and then worked on other things on my site. Today I noticed that I cannot view past orders’ items which were purchased.

    I exported the orders from a backup site that I keep, and imported into my site (using the WP importer), and the item data disappeared again! So I think it has something to do with the new version (?)

    Also, the orders created after the update are fine. Just the old orders seem to have lost their items. The total amount is there though.

    Here is a screenshot: Screenshot

    I searched the web everywhere, but no one had this problem. So I’m hoping maybe someone here knows what’s going on?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    8 years, 10 months ago

    Interesting, haven’t seen that happen before after just updating.

    To rule out a lot of variables, could you try switching to a default WordPress theme and disabling all plugins except for WooCommerce? See if the order items appear again. If not, perhaps try the import again.

    If that doesn’t help, it seems as though something is wrong with the wp_woocommerce_order_items and wp_woocommerce_order_items database tables.

    Thread Starter sorincoza

    (@sorincoza)

    8 years, 10 months ago

    Disabling all plugins and changing theme did not help. But you are right about the table woocommerce_order_items – it’s empty.

    I’ll probably try to “merge” the backup table with the table from my site.

    But what I find most interesting is that export/import does not work. Doesn’t make any sense. Or maybe the WP importer does import/export all the order data?

    Plugin Contributor Mike Jolley

    (@mikejolley)

    8 years, 10 months ago

    WP Export won’t export order items – those are in a custom table.

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

The topic ‘Orders missing items in admin area after update’ is closed to new replies.