I have noticed that ordered product info is missing from all orders made before December 8th 2022. Order detail for those orders looks like this:
I am not sure when that happened, the rest of the order information is ok (billing shipping address etc…). Upon inspection of the database, I have found that tables
wpcv_woocommerce_order_itemmeta and wpcv_woocommerce_order_items
only have information from Dec 8th on. Any idea how to solve this and get old order information back?
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.
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:
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.
