t ask WooCommerce for full product objects when you only need a few fields. wc_get_products()is convenient but it t need the object, you need one column, from every row, as cheaply as possible. That one SELECT meta_value AS sku, COUNT(*) AS cnt FROM{$wpdb->postmeta}WHERE meta_key = s solved similar large-catalog scanning problems in WooCommerce or WordPress more generally, I Nothing throws an error, a product just goes live with no featured image, an import leaves two products sharing the same SKU, a variation ends up with a $0 price.