Hi @dwc_user,
I’m not familiar with Duplicator Pro, but it is possible that not all of the product postmeta was transferred, or that it somehow got mangled in the process.
Do you have database access? The meta key for a given product’s tabs is yikes_woo_products_tabs, you could check to see if it’s there. If so, the data is probably corrupted. You can check using a tool like https://www.functions-online.com/unserialize.html.
Let me know if that helps,
Jon
Well i do still have access to the old webshop with the tabs on there.
I am not that familiar with Mysql, is there a other way to restore them?
Would it be possible to export the necessary data from one to another?
Using: SELECT * FROM postmeta ORDER BY meta_key DESC.
Exporting this data and importing it to postmeta in the new database?
Hi @dwc_user,
You can definitely acquire all of the data by selecting all records from wp_postmeta where meta_key is yikes_woo_products_tabs, but you probably cannot directly copy. Each row in wp_postmeta has an ID and you don’t want to override any existing ID’s by copying in new rows.
I’d recommend exporting that data to a CSV or JSON file and then writing a script to update each post with the associated key. This way you can assign the right value to the right post, but let your new site take care of the ID’s. A custom WP_CLI command would probably be the simplest option here. Have it take the path of your CSV file as an argument. Load the file, loop through each row, and update the post meta.
Using WP_CLI requires SSH access to the server. If you don’t have that, you can take a look at either creating a REST API route or an admin page with an upload form.
Let me know if that helps,
Jon
Would you maybe be able to help with this solution?
If we do have to purchase a license or pay a certain amount we totally understand.
I have exported the file containing the postmeta to CSV from the old server/database.
Or would a tool as this: https://www.wpallimport.com/ possibly do the job?
Hi @dwc_user,
If you are just looking to import products, you may look into the WooCommerce CSV importer. It’s a tool built-in to WooCommerce.
You’ll perform an export on your old site (making sure to check the include custom meta box) and then you’ll perform an import on your new site (making sure to select “Update Existing Posts”). It should add the missing meta to each of your products.
Take a backup before doing the import in case you need to change something.
Let me know if that helps,
Jon
