GQL product query doesn't response for product that is set visibility as "Search"

[adarshkhatri]

Preconditions and environment

• Magento version : 2.4.4-p1
• Commerce (Community might be behaving same)

Steps to reproduce

1. Create a product and set it's visibility to search
2. Query for GQL

query products(
    $filter: ProductAttributeFilterInput
    ) {
      products(
          filter: $filter
    ) {
        total_count
      items {
          type_id
          sku
          url_key
   }
}

Variable:

{
  "filter": {
      "sku": {
          "eq": "your-product-sku"
        }
  }
}

Expected result

The response should have a product.

Actual result

The response is empty.

Additional information

It looks Magento adds visibility as 2 and 4 by default while doing GQL query. It make sense when doing query for the category page. But how about the product detail page?

Release note

No response

Triage and priority

• [X] Severity: S0 - Affects critical data or functionality and leaves users without workaround.
• [ ] Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
• [ ] Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
• [ ] Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
• [ ] Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.

[m2-assistant[bot]]

Hi @adarshkhatri. Thank you for your report. To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:

• @magento give me 2.4-develop instance - upcoming 2.4.x release
• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this

• To learn more about issue processing workflow, refer to the Code Contributions.

  Join Magento Community Engineering Slack and ask your questions in #github channel. :warning: According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting. :clock10: You can find the schedule on the Magento Community Calendar page. :telephone_receiver: The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[adarshkhatri]

@magento give me 2.4-develop instance - upcoming 2.4.x release

[magento-deployment-service[bot]]

Hi @adarshkhatri. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @adarshkhatri, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_5a7f Login: 252163c5 Password: 329f56b8a069

[adarshkhatri]

I was able to reproduce in above instance.

[m2-assistant[bot]]

Hi @engcom-Bravo. Thank you for working on this issue. In order to make sure that issue has enough information and ready for development, please read and check the following instruction: :point_down:

• [ ] 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• [ ] 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• [ ] 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• [ ] 4. Verify that the issue is reproducible on 2.4-develop branch
  Details

  - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
• [ ] 5. Add label Issue: Confirmed once verification is complete.
• [ ] 6. Make sure that automatic system confirms that report has been added to the backlog.

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Bravo, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_86e5 Login: b50c8847 Password: e81d88c79989

[engcom-Bravo]

Hi @adarshkhatri,

Thank you for reporting and collaboration.

Verified the issue on Magento 2.4-develop instance and the issue is not reproducible.Kindly refer the screenshots.

Steps to reproduce

1.Create a product and set it's visibility to search 2.Query for GQL

As per magento devdocs when we set to product visibility to search it will be found through search tool.

Kindly go through with this document https://docs.magento.com/user-guide/v2.3/sales-channels/amazon/creating-assigning-catalog-products.html#create-a-multiple-catalog-products-using-their-amazon-listing-information and please let us know if you are still facing any issue.

Thanks.

[adarshkhatri]

Isn't that the issue I reported that is response has no product?

[adarshkhatri]

If this is expected, then what is the query should I run to take customer to product detail page?

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Bravo, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_3898 Login: 732b15f7 Password: 541eea619e2d

[engcom-Bravo]

Hi @adarshkhatri,

Thanks for your update.

Verified the issue on Magento 2.4-develop instance and the issue is not reproducible.Kindly refer the screenshots.

Steps to reproduce

1.Create a product and set it's visibility to search

We have used below query for a product when set visibility as "search".We got a response for a product.

{
  products(search: "Product SKU") {
    items {
      name
      sku
      url_rewrites {
        url
        parameters {
          name
          value
        }
      }
    }
  }
}

Kindly let us know if we are still facing any issue.

Thanks.

[adarshkhatri]

Above query would be for your search result page. now how will you take your customer to product detail page? You cannot rely on ‘search query’ to take your customer to PDP.

The way we do it, we remove the “search” query and pass the SKU as a filter when taking to PDP.

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Bravo, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_40a5 Login: e493355e Password: 56c72a1d1c64

[engcom-Bravo]

Hi @adarshkhatri,

Thanks for your update.

As per Magento devdocs when we set visibility to searchthe product should be only searchable,and also we cannot find that product in categories kindly refer the attached video.

https://user-images.githubusercontent.com/51680745/220626105-a3485213-e9bb-488d-83f4-7d032b3b9bd0.mov

We have used below graphql query for a product when we set visibility to search.we got the response.

{
  products(
    search: "ProductA"

  ) {
    items {
      name
      sku
      price_range {
        minimum_price {
          regular_price {
            value
            currency
          }
        }
      }
    }
    total_count
    page_info {
      page_size
    }
  }
}

Since the product is not showing an category page we cannot filter the product.Kindly let us know if you are still facing any issue.Please let us know if we missed anything.

Thanks.

[adarshkhatri]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @adarshkhatri. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @adarshkhatri, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_3525 Login: 259c2238 Password: 26f6e359402e

[adarshkhatri]

Ok, I think we are going in circle. I agree with you on search result page. But I am trying to understand your approach for PDP.

Below is the approach I am using for my storefront.

Have a look this URL: https://venia.magento.com/graphql?query=query+getProductDetailForProductPage%28%24urlKey%3AString%21%29%7Bproducts%28filter%3A%7Burl_key%3A%7Beq%3A%24urlKey%7D%7D%29%7Bitems%7Bid+uid+...ProductDetailsFragment+__typename%7D__typename%7D%7Dfragment+ProductDetailsFragment+on+ProductInterface%7B__typename+categories%7Buid+breadcrumbs%7Bcategory_uid+__typename%7D__typename%7Ddescription%7Bhtml+__typename%7Dshort_description%7Bhtml+__typename%7Did+uid+media_gallery_entries%7Buid+label+position+disabled+file+__typename%7Dmeta_description+name+price%7BregularPrice%7Bamount%7Bcurrency+value+__typename%7D__typename%7D__typename%7Dprice_range%7Bmaximum_price%7Bfinal_price%7Bcurrency+value+__typename%7Ddiscount%7Bamount_off+__typename%7D__typename%7D__typename%7Dsku+small_image%7Burl+__typename%7Dstock_status+url_key+custom_attributes%7Bselected_attribute_options%7Battribute_option%7Buid+label+is_default+__typename%7D__typename%7Dentered_attribute_value%7Bvalue+__typename%7Dattribute_metadata%7Buid+code+label+attribute_labels%7Bstore_code+label+__typename%7Ddata_type+is_system+entity_type+ui_input%7Bui_input_type+is_html_allowed+__typename%7D...on+ProductAttributeMetadata%7Bused_in_components+__typename%7D__typename%7D__typename%7D...on+ConfigurableProduct%7Bconfigurable_options%7Battribute_code+attribute_id+uid+label+values%7Buid+default_label+label+store_label+use_default_value+value_index+swatch_data%7B...on+ImageSwatchData%7Bthumbnail+__typename%7Dvalue+__typename%7D__typename%7D__typename%7Dvariants%7Battributes%7Bcode+value_index+__typename%7Dproduct%7Buid+media_gallery_entries%7Buid+disabled+file+label+position+__typename%7Dsku+stock_status+price%7BregularPrice%7Bamount%7Bcurrency+value+__typename%7D__typename%7D__typename%7Dprice_range%7Bmaximum_price%7Bfinal_price%7Bcurrency+value+__typename%7Ddiscount%7Bamount_off+__typename%7D__typename%7D__typename%7Dcustom_attributes%7Bselected_attribute_options%7Battribute_option%7Buid+label+is_default+__typename%7D__typename%7Dentered_attribute_value%7Bvalue+__typename%7Dattribute_metadata%7Buid+code+label+attribute_labels%7Bstore_code+label+__typename%7Ddata_type+is_system+entity_type+ui_input%7Bui_input_type+is_html_allowed+__typename%7D...on+ProductAttributeMetadata%7Bused_in_components+__typename%7D__typename%7D__typename%7D__typename%7D__typename%7D__typename%7D%7D&operationName=getProductDetailForProductPage&variables=%7B%22urlKey%22%3A%22penelope-peasant-blouse%22%7D

And https://venia.magento.com/penelope-peasant-blouse.html As you see, for the PDP there the query: getProductDetailForProductPage($urlKey:String!)

and fitler by url_key: {"urlKey":"penelope-peasant-blouse"} in the filter payload.

With this fitler, the response is null.

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Bravo, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_eba0 Login: 7cc73077 Password: 4fa3868fb7f3

[engcom-Bravo]

Hi @adarshkhatri,

Thanks for your update.

We have created 3 products with visilibity to search.These products we cannot found in category.we tried using search tool.

We have used below query with filter input.We got response.

{
  products(
    search: "ProductA"
    filter: { sku: { eq: "ProductAAA" } }
  ) {
    items {
      name
      sku

      price_range {
        minimum_price {
          regular_price {
            value
            currency
          }
        }
      }
    }
    total_count
    page_info {
      page_size
    }
  }
}

We are able to filter the product with SKU.

Kindly let us know if we missed anything.

Thanks.

[adarshkhatri]

You are using search for the product query in PDP. As we know search query may not give you the exact product. The search query is for catalog search.

As you can see your own demo PWA link https://venia.magento.com/penelope-peasant-blouse.html it is not using search query

query getProductDetailForProductPage($urlKey:String!){
  products(
    filter:{
      url_key:{eq:$urlKey}
    }
  ){
    items{
      id
      uid 
      ...ProductDetailsFragment 
        __typename
    }
    __typename
  }
}

Can you confirm or point me to a Magento doc about the PDP page query approach to use search in a query?

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Bravo, here is your Magento Instance: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering Admin access: https://a8e18a502c712ea06a567934a0b8b1a6.instances.magento-community.engineering/admin_8410 Login: 07c77e17 Password: 1e07e824c85d

[engcom-Bravo]

Hi @adarshkhatri,

Thanks for your update.

We have tried below query using search.we got response for PDP page.

query {
  productDetail: products(
  search: "ProductA"
    filter: { sku: { eq: "ProductAAA" } }
  ) {
    total_count
    items {
      sku
      id
      name
      __typename
      price_range {
        minimum_price {
          regular_price {
            value
            currency
          }
        }
      }
      }

      }

          }

As per Magento devdocs https://developer.adobe.com/commerce/webapi/graphql/schema/products/queries/products/#deprecated-output-attributes. filter withurl_key is deprecated.

For url_key we have to use route query.Please check this document https://developer.adobe.com/commerce/webapi/graphql/schema/products/queries/route/.

Kindly let us know if you are still facing any issue.

Thanks.

[adarshkhatri]

I think we are going in circles. Please close the ticket if you think there is no problem. I have already patched our version.

[engcom-Bravo]

Hi @adarshkhatri,

Thanks for your update.

As per latest comment https://github.com/magento/magento2/issues/36857#issuecomment-1445012602 we are closing this issue. Please raise a fresh ticket or reopen this ticket if you need more assistance on this.

Thanks.

[oleksiyzestlogic]

I have the same issue as @adarshkhatri. I think we should reopen task.

Maybe it's an issue from the PWA side and we should use another query, but for now it's products with filter still:

Query is:

query getProductDetailForProductPage($urlKey:String!) {
    products(filter:{url_key:{eq:$urlKey}}) {
        items {
            ...
        }
    }
}

And this query has build in filter by visibility and products with visibility "Search" ignored.

[BITS-Martin]

I think we are going in circles. Please close the ticket if you think there is no problem. I have already patched our version.

@adarshkhatri how did you resolve the issue? We encounter the same problem in 2.4.5-p8 aswell.