Ordered product info missing from old orders

Hi there! ??

Oh, that’s odd. Honestly, this is a tough one to troubleshoot.

In this case, I would suggest you reach out to your hosting and check with them if they have an old backup of your site, and if they do, restore it on a staging site so you can inspect if the orders exist there.

Probably a PHP or Database issue occurred on that date that wiped out all of the data, but I am not sure.

Cheers.

Was there a change in database structure where the order data is stored? Would it be possible to get a list of all the tables where order data is stored? I have an older backup, but table names and structure is different

Is it normal to have two sets of wc tables in the same database? The order data that is missing when I check orders in wordpress is in the “wc” tables, but not in “woocommerce” tables:

Hello @bingokid,

Was there a change in database structure where the order data is stored?

Not by default, did you enable High-Performance Order Storage by any chance?

Is it normal to have two sets of wc tables in the same database? The order data that is missing when I check orders in wordpress is in the “wc” tables, but not in “woocommerce” tables:

In most cases, you’ll find two tables one with and one without a backup prefix. Checking the two screenshots, I didn’t find the same table with wc and woocommerce.

Could you please share a copy of your site’s System Status Report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

It’s also worth checking if there are any fatal error logs from WooCommerce > Status > Logs and choosing from the drop-down menu the fatal-errors.log option.

Look forward to hearing back from you.

Hi @bingokid ,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Cheers!