Import Tabs with CVS

Hi @arjanvanansem,

As long as you check the “export custom meta” box when you export the CSV, the import will include the tabs as well. I’m not sure what you mean by copying the column, but the tabs are stored as serialized data, so they aren’t exactly human readable. If you want to read the contents of a tab, you could always run it through something like https://www.unserialize.com/.

Let me know if that helps,
Jon

Hi Jon,

Thankyou for your answer.
Currently I can export the custom meta from the tabs.

But because I have to work with a lot of products, it is nice to add all products via the CVS file and then import them into WooCommerce.

Currently I get stuck, so I add all products in my CVS file, is it correct that I cannot create tabs from the CVS file? I tried this by copying tabs from an old product to the new product and changing the “content”. When I then import this CVS file there are no tabs for these products.

Kind regards

Hello @jpowersdev,
I believe I’m having the same sort of problem. I’ve exported the CSV file including custom meta. The CSV (when opened in Excel) contains a column called “Meta: yikes_woo_products_tabs” that contains data like

a:1:{i:0;a:3:{s:5:title;s:9:[TAB NAME];s:2:id;s:9:[tabname];s:7:content;s:686:[CONTENT FROM THE TAB APPEARS HERE];}}

I then use this column/data in a CSV file populated with the new products I want to import into Woocommerce. (part of the tab content is changed on each line for each new product)

When the finished CSV is imported into Woocommerce the tab does not appear on the new product. I checked and an entry is made in wp_postmeta so it seems something’s awry with the upload?

Hope you can help.
Regards.

Please disregard my last. I see that your Custom Product Tabs WP All Import Add On might be the solution. Apologies for inconvenience.

Hi @arjanvanansem,

WooCommerce allows you to add custom meta to products through the CSV, and our plugin is using custom meta to store tabs on products. The problem is that the information used by our plugin is serialized data, which you should not be editing manually. It’s a very specific format, and if even one row is invalid my guess is that WooCommerce would ignore the entire column.

You can use something like unserialize.com to take a look at the data if you want to understand the format. That being said, this question is a little out of scope for what our plugin is supposed to do.

Jon

Hello. So what should I do if I need to add information to a custom tabs in a csv? I need to add many products so I need to work in spreadsheets and then I need to import products in bulk.

Thanks

Martin

Hi all,

We put together a knowledge base article that should help you out – https://yikesplugins.com/knowledge-base/importing-custom-tabs-using-the-built-in-woocommerce-csv-importer/

Let me know if you have any trouble,
Jon