WordPress.org

Forums

Relevanssi - A Better Search
[resolved] Searching product-level attributes in WooCommerce (3 posts)

  1. ecclescake
    Member
    Posted 9 months ago #

    WooCommerce allows two types of product attributes: global attributes and product-level attributes. Global attributes are a taxonomy, and product-level attributes are post meta. I've set up Relevanssi to search global attributes, but can't get it to search product-level attributes. I think this is because product-level attributes aren't post meta belonging to posts of type "product." They belong to posts of type "product_variation," which aren't public.

    Lots of shops use product-level attributes and it would be fantastic to be able to search them -- I would suggest returning the parent product when a particular product_variation is found to contain the search term. More details below:

    Product-level attributes get saved in a post meta field called attribute_[attribute name], for example, attribute_color. When these attributes are used to create product variations, this post meta field belongs to a CPT of type product_variation. Relevanssi can index this field and I can see the values in the Relevanssi table in the database (with a 1 in the customfield column), but no results get returned when I search for a word that appears only in a product-level attribute. For example, I have a color called 'aquamarine' and I can see it in the Relevanssi table, but no products get returned when I search using that word.

    product_variation is registered as follows:

    register_post_type( "product_variation",
    			apply_filters( 'woocommerce_register_post_type_product_variation',
    				array(
    					'label'        => __( 'Variations', 'woocommerce' ),
    					'public'       => false,
    					'hierarchical' => false,
    					'supports'     => false
    				)
    			)
    		);

    I've hooked into the filter to make public = true and explicitly set exclude_from_search = false, but it doesn't help.

    Is there any hope of Relevanssi returning products that have variations that match the search term?

    https://wordpress.org/plugins/relevanssi/

  2. Mikko Saari
    Member
    Plugin Author

    Posted 9 months ago #

    You can, for example, add code that adds the variation meta fields to the parent post.

    add_filter('relevanssi_content_to_index', 'rlv_add_variations', 10, 2);
    function rlv_add_variations($content, $post) {
        $variations = get_children(array('post_parent' => $post->ID, 'post_type' => 'product_variation'));
        if (!empty($variations)) {
            foreach ($variations as $variation) {
                $color = get_post_meta($variation->ID, 'attribute_color', true);
                $content .= " $color";
            }
        }
        return $content;
    }

    Something like that.

  3. ecclescake
    Member
    Posted 9 months ago #

    Oh, that's clever! It worked perfectly.

    This is my first time using Relevanssi and I'm really enjoying the control it gives me over indexing and search results. Thanks for a great plugin and great support!

Reply

You must log in to post.

About this Plugin

  • Relevanssi - A Better Search
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic