Thousands of columns in the database when exporting Woocommerce products to CSV

Hi @joyryde, thanks for reporting this. It’s been some time since I wrote the uninstallation script for this plugin and I wouldn’t be surprised if it’s not bullet-proof anymore. There might also be something specific about WooCommerce that could be tweaked in this plugin to prevent unintended additions of data to your export.

Currently, when deactivating the plugin, all oembed entries should be removed from the database:

static function delete_oembed_caches() {

global $wpdb;

$meta_key_1 = "|_oembed|_%%";

$meta_key_2 = "|_oembed|_time|_%%";

$wpdb->query(

$wpdb->prepare(

"DELETE FROM ".$wpdb->postmeta."

WHERE meta_key LIKE %s ESCAPE '|'

OR meta_key LIKE %s ESCAPE '|'",

$meta_key_1,

$meta_key_2

)

);

// Flush all transient oembed caches. Those are used by the block editor.

// @since 2.9.0

$option_name_1 = "|_transient|_oembed|_%%";

$option_name_2 = "|_transient|_timeout|_oembed|_%%";

$wpdb->query(

$wpdb->prepare(

"DELETE FROM ".$wpdb->options."

WHERE option_name LIKE %s ESCAPE '|'

OR option_name LIKE %s ESCAPE '|'",

$option_name_1,

$option_name_2

)

);

}

When uninstalling the plugin (after deactivating), two things happen:

1. Clear all oembed caches
2. Delete all post-specific metadata added by this plugin:

static function delete_postmeta() {

global $wpdb;

$meta_key_1 = "lazyload_thumbnail_quality";

$wpdb->query(

$query = $wpdb->prepare(

"DELETE FROM ".$wpdb->postmeta."

WHERE meta_key = %s",

$meta_key_1

)

);

}

My recommendation would be to simply try and see what happens if you deactivate the plugin. Does that fix your WooCommerce issue?

@joyryde You got lucky! I was motivated to squeeze in some plugin updates today. Please check out v2.18.0 and see if that fixes your issue. I implemented a solution that should prevent oembed metadata from getting exported in WooCommerce product CSVs.