No products shown for product tag archives

  • finalwebsites
    Participant
    2 years, 8 months ago #27457

    Hi,
    WPSOLR has replaced all archives except the product tag archives.
    Product attributes and categories are fine, it’s only the tags ar not showing is that some setting I need to change?

    wpsolr
    Keymaster
    2 years, 8 months ago #27458

    Do you see errors in chrome js console or WP debug.log?

    finalwebsites
    Participant
    2 years, 8 months ago #27459

    Nope, no error’s in the console and the debug log is empty.
    Check by yourself https://123pianomuziek.nl/product/pop-hits-for-piano-duet-popular-songs-series/

    wpsolr
    Keymaster
    2 years, 8 months ago #27460

    Can you activate the query logging in screen 2.1, and copy here the query on product tags archive?

    finalwebsites
    Participant
    2 years, 8 months ago #27461

    Here is the query:

    [10-Aug-2021 05:33:08 UTC] WPSOLR Log query =>
    Url: “/componist/anouk/”
    Index: “123pianomuziek_index”
    Nb results shown: 2
    Total nb results: 2
    Speed: 839 ms
    Query: {
    “from”: 0,
    “size”: 20,

    “query”: {

    {
    “bool”: {
    “must”: {
    “term”: {
    “pa_componist_str”: “Anouk”
    }
    }}

    ….

    wpsolr
    Keymaster
    2 years, 8 months ago #27464

    This query is a product attribute query (“/componist/anouk/”), and returns 2 results.

    finalwebsites
    Participant
    2 years, 8 months ago #27472

    Hi,
    sorry that was not the right query log.
    The query log for this URL https://123pianomuziek.nl/product-tag/piano-duet/ is:

    
    [13-Aug-2021 12:03:00 UTC] WPSOLR Log query =>
    Url: "/product-tag/piano-duet/"
    Index: "123pianomuziek_index"
    Nb results shown: 0
    Total nb results: 0
    Speed: 403 ms 
    Query: {
        "from": 0,
        "size": 20,
        "sort": [
            {
                "menu_order_i": {
                    "order": "desc"
                }
            },
            {
                "date": {
                    "order": "desc"
                }
            }
        ],
        "_source": [
            "id",
            "PID",
            "type",
            "meta_type_s",
            "title",
            "numcomments",
            "comments",
            "displaydate",
            "displaymodified",
            "*categories_str",
            "author",
            "*post_thumbnail_href_str",
            "*post_href_str",
            "snippet_s"
        ],
        "query": {
            "bool": {
                "must": {
                    "query_string": {
                        "query": "text:(*)",
                        "default_operator": "AND"
                    }
                },
                "filter": {
                    "bool": {
                        "must": [
                            {
                                "terms": {
                                    "type": [
                                        "product"
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "terms": {
                                                "post_status_s": [
                                                    "draft",
                                                    "pending",
                                                    "trash",
                                                    "future",
                                                    "private",
                                                    "auto-draft"
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must": {
                                        "term": {
                                            "product_tag_str": "Piano Duet"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "product_visibility_str"
                                                        }
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "terms": {
                                                            "product_visibility_str": [
                                                                "exclude-from-catalog"
                                                            ]
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "bool": {
                                                            "must": {
                                                                "exists": {
                                                                    "field": "is_excluded_s"
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "terms": {
                                                "is_excluded_s": [
                                                    "n"
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "terms": {
                                                "_id": [
                                                    "wpsolr_doc_id_attachment"
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            }
        },
        "aggs": {
            "pa_arrangeur_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_arrangeur_str": {
                        "terms": {
                            "field": "pa_arrangeur_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_bezetting_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_bezetting_str": {
                        "terms": {
                            "field": "pa_bezetting_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_componist_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_componist_str": {
                        "terms": {
                            "field": "pa_componist_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_genre_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_genre_str": {
                        "terms": {
                            "field": "pa_genre_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_moeilijkheidsgraad_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_moeilijkheidsgraad_str": {
                        "terms": {
                            "field": "pa_moeilijkheidsgraad_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_periode_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_periode_str": {
                        "terms": {
                            "field": "pa_periode_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_series_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_series_str": {
                        "terms": {
                            "field": "pa_series_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_uitgever_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_uitgever_str": {
                        "terms": {
                            "field": "pa_uitgever_str",
                            "size": 20
                        }
                    }
                }
            },
            "pa_vorm_str": {
                "filter": {
                    "match_all": {}
                },
                "aggs": {
                    "pa_vorm_str": {
                        "terms": {
                            "field": "pa_vorm_str",
                            "size": 20
                        }
                    }
                }
            }
        }
    } 
    Results: {
        "took": 3,
        "timed_out": false,
        "_shards": {
            "total": 5,
            "successful": 5,
            "skipped": 0,
            "failed": 0
        },
        "hits": {
            "total": 0,
            "max_score": null,
            "hits": []
        },
        "aggregations": {
            "pa_uitgever_str": {
                "doc_count": 0,
                "pa_uitgever_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_arrangeur_str": {
                "doc_count": 0,
                "pa_arrangeur_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_periode_str": {
                "doc_count": 0,
                "pa_periode_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_genre_str": {
                "doc_count": 0,
                "pa_genre_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_bezetting_str": {
                "doc_count": 0,
                "pa_bezetting_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_series_str": {
                "doc_count": 0,
                "pa_series_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_componist_str": {
                "doc_count": 0,
                "pa_componist_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_vorm_str": {
                "doc_count": 0,
                "pa_vorm_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            },
            "pa_moeilijkheidsgraad_str": {
                "doc_count": 0,
                "pa_moeilijkheidsgraad_str": {
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0,
                    "buckets": []
                }
            }
        }
    }
    
    
    wpsolr
    Keymaster
    2 years, 8 months ago #27473

    I suspect your data needs to be full re-indexed.

    Can you query manually your index with Kibana, to ensure that “product_tag_str” field contains “Piano Duet” for some of your products?

    finalwebsites
    Participant
    2 years, 8 months ago #27504

    Hi,
    I did a complete re-index and still not results for any tag.

    Can you query manually your index with Kibana, to ensure that “product_tag_str” field contains “Piano Duet” for some of your products?

    I checked the index via Kibana and it look like the field “producttags” is not included. The “Send your data” tab show the information “All Producttags are indexed.”

    wpsolr
    Keymaster
    2 years, 8 months ago #27509

     

    “product_tag_str” should definitely be present in Elasticsearch.

     

    Image woocommerce-product-tags-screen-data.png of Image woocommerce-product-tags-elasticsearch.png of Image woocommerce-product-tags-archive.png of

     

     

    finalwebsites
    Participant
    2 years, 8 months ago #27524

    Hi,
    it might work in your simple demo application, but the product tags are missing inside the index while wpsolr says it’s indexed:

    https://www.dropbox.com/s/s11c9zdy32bpom6/Screenshot%20from%202021-08-18%2014-22-25.png?dl=0
    https://www.dropbox.com/s/0s36h1mqc8qyomj/ZB_Selection_170.jpg?dl=0

    wpsolr
    Keymaster
    2 years, 8 months ago #27532

    Can you show me your screen 2.2, especially the settings of the product post type?

    finalwebsites
    Participant
    2 years, 8 months ago #27533

    Hi,
    I think we found the problem:
    https://www.dropbox.com/s/nd8zw6360iy63j9/ZB_Selection_171.jpg?dl=0
    Why do you have two options for the product tag?

    wpsolr
    Keymaster
    2 years, 8 months ago #27534

    The first option is used for search: products containing a tag will be found and filtered by the tag.

    The second option is used for suggestions (autocompletion): the tag will appear in the suggestions if it matches the keywords.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic.