I’m working on a WordPress website that uses WooCommerce as an eCommerce solution. So here’s what I’m trying to do:
I want to export all of the orders and order details from an old database to a new one. Pretty simple task right? Well, we’re using WooCommerce Product Add-Ons and for some reason, the “Add-Ons” data that was saved to the orders is not showing up on the new database. I’ve tried importing “Orders” via the WordPress importer, I’ve tried SQL queries, I’ve even tried copying the entire wp_posts and wp_postmeta meta tables from the old database to the new one; but nothing is working!
Any help would be greatly appreciated!
Read more here: Importing WooCommerce Order Data