Importing products with custom tabs

URGENT: Migrated our website from localhost to live and it lost the product tabs on all our products over 1500 of them.

I an see the information is on the database but how do we get them to show.

Hi! I created a tab in one product and want to copy it to the other 300 products. I exported everything using the standard Woocommerce plugin, got the “yikes_woo_products_tabs” field. Copied far need to information and imported back. Tabs in the new products did not appear. Prompt how it is possible to solve a problem?

Yes. Before import, I changed the value of the field to “import as meta-data.” I’m not a big expert by the MySQL, but i can try. I do not use “WP All Import”, as far as I know, it is paid.

No, I first created a tab for one product. Then I exported all the goods, copied the cell of this product and pasted it into others.

Just figured I’d leave my tip here after screwing with this for a few days..

I was doing the same thing as poster – wanting to import products with custom (or saved) tabs from a csv and I couldn’t get it to work. First, like OP, I manually made a product, exported it… and then I duplicated the row and edited the new rows to make new products… and then when I would import back into woocommerce the custom tabs wouldn’t show up even with the “import as meta” option. However, If I took the original export of the product I made manually and tried importing it and would import just fine by itself…

So, I looked at the yikes_woo_products_tabs column in my csv for the first duplicated product I made which was this:

a:1:{i:0;a:3:{s:5:"title";s:12:"User Reviews";s:2:"id";s:12:"user-reviews";s:7:"content";s:251:"<h2>ATCProxys User Reviews:</h2>
<h3>[RICH_REVIEWS_SNIPPET category="ATCProxys.com"]</h3>
[RICH_REVIEWS_SHOW category="ATCProxys.com" num="8"]<br />
(If you have used ATCProxys please leave a review below!)
[RICH_REVIEWS_FORM category="ATCProxys.com"]";}} 

and then I noticed that the "content";s:251:" part is a character count of actual content in the tab, and once it was changed to "content";s:255:" the product would import properly! I’ve just imported 800+ products with Custom Tabs after fixing the character counts for the “content” part of the serial/meta data. Thankfully the Custom Tabs only changed every few dozen products and not for each. If every single product has a different custom tab then it would have been very tedious for sure.

• This reply was modified 5 years, 7 months ago by jsnowbusiness.