Issues with the xstore search products form

Hello, mitys,

We have noticed that your website is utilizing a large number of plugins. This could potentially impact the website’s performance, lead to errors, and affect its overall speed. To ensure optimal functionality and avoid such issues, we kindly ask you to manually review each plugin currently in use on your website.

If the problem persists, we suggest switching to the Parent theme if you are currently using the Child Theme on your site. After clearing the cache, check again.
Do the same test for the default WooCommerce theme – Storefront. The issue may be due to your custom code in the Child Theme.

Let us know the results.

Best regards,
8Theme’s Team

Hello,

In this case, the SKU of the parent product should be similar to the SKU of its variations.

For example, if the parent product has the SKU test-12-12, then the variations should have SKUs such as test-12-12-1, test-12-12-2, and so on.

Best regards,
8Theme Team

Hello, mitys,

Our search by variations is available only for the XStore theme.
Best regards,
The 8Theme Team

Hello, mitys,
The search by variations is also available in the parent theme too
Best regards,
8Theme Team

Hello, mitys,
we were looking for variations. To do this yourself, you need to open the header in the Elementor editor mode, go to the Ajax search element, and in the data type field, select the product variation as shown in the screenshot attached to the post.

Best Regards,
8Theme’s Team

Hello, mitys,

We have enabled this option for you and are also providing a video showing where to find it in the future.

Best regards,
The 8Theme Team

Hello, mitys,

to fix this issue you have added the following custom code to your child theme. Please check if the issue persists.

/**
 * Ensure product search by SKU respects selected language in XStore et_search requests.
 */
add_filter( 'posts_where', 'xstore_child_limit_product_search_by_lang', 999, 2 );
function xstore_child_limit_product_search_by_lang( $where, $query ) {
    if ( is_admin() || ! ( $query instanceof WP_Query ) ) {
        return $where;
    }

    if ( empty( $_GET['et_search'] ) || ! $query->is_search() ) {
        return $where;
    }

    $post_type = $query->get( 'post_type' );
    $is_product_query = ( 'product' === $post_type ) || ( is_array( $post_type ) && in_array( 'product', $post_type, true ) );
    if ( ! $is_product_query ) {
        return $where;
    }

    $lang = $query->get( 'lang' );
    if ( empty( $lang ) && isset( $_GET['lang'] ) ) {
        $lang = wp_unslash( $_GET['lang'] );
    }

    $lang = is_string( $lang ) ? preg_replace( '/[^a-zA-Z_-]/', '', $lang ) : '';
    if ( '' === $lang ) {
        return $where;
    }

    global $wpdb;

    // WPML: limit products to requested language.
    if ( defined( 'ICL_SITEPRESS_VERSION' ) || defined( 'ICL_LANGUAGE_CODE' ) ) {
        $icl_table = $wpdb->prefix . 'icl_translations';
        $condition = $wpdb->prepare(
            " AND EXISTS (
                SELECT 1 FROM {$icl_table} icl
                WHERE icl.element_id = {$wpdb->posts}.ID
                AND icl.element_type = 'post_product'
                AND icl.language_code = %s
            )",
            $lang
        );

        return $where . $condition;
    }

    // Polylang: limit products by language taxonomy relation.
    if ( defined( 'POLYLANG_VERSION' ) || function_exists( 'pll_current_language' ) ) {
        $condition = $wpdb->prepare(
            " AND EXISTS (
                SELECT 1
                FROM {$wpdb->term_relationships} tr
                INNER JOIN {$wpdb->term_taxonomy} tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
                INNER JOIN {$wpdb->terms} t ON t.term_id = tt.term_id
                WHERE tr.object_id = {$wpdb->posts}.ID
                AND tt.taxonomy = 'language'
                AND t.slug = %s
            )",
            $lang
        );

        return $where . $condition;
    }

    return $where;
}

Best Regards,
8Theme’s Team