Import multiple products via CSV

  • We needed to import a large number of bundles. I decided to prepare a csv file for this. I quickly discovered that Woo doesn’t support serialized data in their import/export, and the plugin’s main field is serialized. Woo’s import reserializes the contents of the field _yith_wcpb_bundle_data, which adds data at the head and tail of the string. Simply trimming off the extra characters afterwards doesn’t work. I tried a bit of code to unserialize the data during import. This worked fine last year, but doesn’t seem to work anymore. Then I discovered that entering the data from the spreadsheet I created to assemble the strings directly into the database ALSO doesn’t work. The strings can LOOK identical to those produced by the manual product creation process, but they aren’t. IOW, no way to get the attached product data into the product, except by hand. Can anyone suggest a workaround? Maybe a different encoding (tried UTF7-8, ASCII)? YITH, how about giving us a csv import/export to get that data into the database?

Viewing 1 replies (of 1 total)
  • Plugin Support Iván Sosa

    (@ivansosa)

    Hi there,

    I hope you are doing well ??

    At the moment, WooCommerce importer doesn’t support serialized data.
    Since WooCommerce doesn’t support it, you will need to wait for it or use another plugin that allows this feature.

    Anyways, we will study this case in order to see if it’s possible to create our own importer to make it easier.

    Thanks for understanding.

    Have a nice day!

Viewing 1 replies (of 1 total)
  • The topic ‘Import multiple products via CSV’ is closed to new replies.