CSV file from product exporter contains unused meta columns

  • Resolved nikolaykomsiyski

    (@nikolaykomsiyski)


    6 years, 5 months ago

    Hi,

    I installed an ebay plugin several months ago that created about 30 meta columns in my products when exported with the built-in csv file. I fully deleted the plugin together with any tables in the phpMyAdmin but the columns are still there, and now I can’t export my csv file – it just freezes and I assume this is because I have too many meta columns that I can’t delete. Could you please tell me how I can control which meta columns are exported and ideally delete the ones that I don’t use anymore, as the exporter just seems to be downloading all meta columns that affected the products at some point.

    Best regards,

    Nikolay

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

  • Hi there,

    Check out the below link. You have the option to choose to export columns and custom meta
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Importer-&-Exporter#exporter

    Also check out if the last two options in Examples provided in below link are of help.
    https://codex.www.ads-software.com/Function_Reference/remove_meta_box

    Thank you.

    Thread Starter nikolaykomsiyski

    (@nikolaykomsiyski)

    Hi,

    Thank you for your prompt reply. Unfortunately they didn’t work, but in the meantime I noticed that I had added youtube videos in the product description boxes and when I exported all the meta, the following columns were created:

    _oembed_time_29d587ff0ddd682ca368b84098431f5a
    _oembed_29d587ff0ddd682ca368b84098431f5a
    _oembed_time_b7cd76a76f598a6e199138a381ed6b42
    _oembed_b7cd76a76f598a6e199138a381ed6b42
    _oembed_time_354c1ac3ec9593137eaf33605a11276c
    _oembed_354c1ac3ec9593137eaf33605a11276c
    _oembed_time_04acd42e921e384d0e233f2317a0798a
    _oembed_04acd42e921e384d0e233f2317a0798a
    _oembed_time_3d39423820309ebe0f2d54e9da164574
    _oembed_3d39423820309ebe0f2d54e9da164574

    So a total of 12 new columns that even if there is nothing in the cells for any product they are still being exported, which makes matters even worse. I really need some of the meta columns created by my plugins so I can’t simply not export any metadata at all.

    Plugin Support con

    (@conschneider)

    Engineer

    Hello again,

    The ideal solution for you would probably be a selective meta exporter function but there is no such advanced functionality in the standard WooCommerce exporter.
    You can try and check your error logs to see why the exports freezes for you. Maybe extending your PHP runtime or the memory limit can help. Alternatively your server might be running out of breath and a bit more hardware can solve this for you.

    Kind regards,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘CSV file from product exporter contains unused meta columns’ is closed to new replies.