Title: Exporting and Importing Data
Last modified: December 3, 2021

---

# Exporting and Importing Data

 *  Resolved [mmkurhade](https://wordpress.org/support/users/mmkurhade/)
 * (@mmkurhade)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/exporting-and-importing-data/)
 * Hi,
 * I have created two custom tabs, one is Ingredients and another is Note. When 
   I export product data from woocommerce, it export those tabs as sterilized meta
   in single column and makes hard to edit. I can import same csv data (sterilized)
   and tabs work fine.
 * May I know solution to this issue? I just want to edit some data in custom tab
   and update it through CSV import.
 * I was trying this too – [https://yikesplugins.com/knowledge-base/importing-custom-tabs-using-the-built-in-woocommerce-csv-importer/](https://yikesplugins.com/knowledge-base/importing-custom-tabs-using-the-built-in-woocommerce-csv-importer/)
   
   but no luck.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [jpowersdev](https://wordpress.org/support/users/jpowersdev/)
 * (@jpowersdev)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/exporting-and-importing-data/#post-15137319)
 * Hi [@mmkurhade](https://wordpress.org/support/users/mmkurhade/),
 * Yes, serialized data is difficult to edit (as it’s not designed to be), but that’s
   just how WordPress stores complex data types in the database.
 * The knowledge base article you are referencing provides code enabling you to 
   edit your tabs as JSON, but it only provides instructions on parsing the import.
   There was another recent support thread which includes a discussion on how to
   convert your tab data to JSON during the export – [https://wordpress.org/support/topic/export-not-including-data/](https://wordpress.org/support/topic/export-not-including-data/)
 * Let me know if that helps,
    Jon
 *  Thread Starter [mmkurhade](https://wordpress.org/support/users/mmkurhade/)
 * (@mmkurhade)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/exporting-and-importing-data/#post-15156652)
 * I am little confused as if I import exported data as it is, it brings all tabs.
   And about the article, I am able to map fields but it doesn’t show data in tabs.
   For example, my tab name is Note and if I map it as per article, it imports blank
   fields.
 *  [jpowersdev](https://wordpress.org/support/users/jpowersdev/)
 * (@jpowersdev)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/exporting-and-importing-data/#post-15159151)
 * Hi [@mmkurhade](https://wordpress.org/support/users/mmkurhade/),
 * If you use an existing export, the tabs will be formatted as serialized data.
   If you then try to import the data after converting the importer to recognize
   JSON, it won’t see anything.
 * You first need to add code to convert the exported meta to JSON, then export 
   it again. After doing that, future imports using the JSON strategy will recognize
   the tabs.
 * Let me know if that helps,
    Jon

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Exporting and Importing Data’ is closed to new replies.

 * ![](https://ps.w.org/yikes-inc-easy-custom-woocommerce-product-tabs/assets/icon-
   256x256.png?rev=1558461)
 * [Custom Product Tabs for WooCommerce](https://wordpress.org/plugins/yikes-inc-easy-custom-woocommerce-product-tabs/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/yikes-inc-easy-custom-woocommerce-product-tabs/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/yikes-inc-easy-custom-woocommerce-product-tabs/)
 * [Active Topics](https://wordpress.org/support/plugin/yikes-inc-easy-custom-woocommerce-product-tabs/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/yikes-inc-easy-custom-woocommerce-product-tabs/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/yikes-inc-easy-custom-woocommerce-product-tabs/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 3 replies
 * 2 participants
 * Last reply from: [jpowersdev](https://wordpress.org/support/users/jpowersdev/)
 * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/exporting-and-importing-data/#post-15159151)
 * Status: resolved