benjminG

functions.php

add_action( 'wcml_before_sync_product', 'fix_orphaned_skus', 2, 10 );
function fix_orphaned_skus( $original_product_id, $post_id ) {
    global $wpdb;
    $sku          = get_post_meta( $original_product_id, '_sku', true );
    $type         = get_post_type( $original_product_id );
    $trid         = apply_filters( 'wpml_element_trid', null, $original_product_id, 'post_' . $type );
    $translations = apply_filters( 'wpml_get_element_translations', null, $trid, 'post_' . $type );
    $others       = $wpdb->get_col( $wpdb->prepare( "SELECT `post_id` FROM $wpdb->postmeta WHERE `meta_key` = '_sku' AND `meta_value` LIKE %s", $sku ) );
    foreach ( $others as $key => $value ) {
        foreach ( $translations as $tr ) {
            if ( $value == $tr->element_id ) {
                unset ( $others[ $key ] );
                continue;
            }
        }

    }
    foreach ( $others as $index => $delete ) {
        wp_delete_post( $delete );
    }
}