query( "UPDATE {$wpdb->postmeta} qs JOIN {$wpdb->postmeta} s1 ON s1.post_id = qs.post_id AND s1.meta_key = 'supplier_1' JOIN {$wpdb->postmeta} s2 ON s2.post_id = qs.post_id AND s2.meta_key = 'supplier_2' SET qs.meta_value = s1.meta_value + s2.meta_value WHERE qs.meta_key = 'quantity_supplier' AND qs.meta_value + 0 <> s1.meta_value + s2.meta_value" ); $repaired = (int) $wpdb->rows_affected; // 2. Variations that never got the meta at all (imported before the fix) $wpdb->query( "INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) SELECT s1.post_id, 'quantity_supplier', s1.meta_value + COALESCE(s2.meta_value, 0) FROM {$wpdb->postmeta} s1 LEFT JOIN {$wpdb->postmeta} s2 ON s2.post_id = s1.post_id AND s2.meta_key = 'supplier_2' WHERE s1.meta_key = 'supplier_1' AND NOT EXISTS ( SELECT 1 FROM (SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = 'quantity_supplier') existing WHERE existing.post_id = s1.post_id )" ); $added = (int) $wpdb->rows_affected; if ($repaired > 0 || $added > 0) { // Direct SQL bypasses the meta cache if (function_exists('wp_cache_flush_group')) { wp_cache_flush_group('post_meta'); } Log::write("Migration 1.2.5: quantity_supplier ricalcolata su {$repaired} variazioni, aggiunta su {$added}", Log::INFO, Log::CONTEXT_GENERAL); } } } }