-
Notifications
You must be signed in to change notification settings - Fork 9.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Attribute with "Used for Sorting in Product Listing" in combination with huge config products causes the product not to show on the category page #35956
Comments
Hi @oneserv-heuser. Thank you for your report.
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:
For more details, review the Magento Contributor Assistant documentation. Add a comment to assign the issue: To learn more about issue processing workflow, refer to the Code Contributions.
🕙 You can find the schedule on the Magento Community Calendar page. 📞 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. ✏️ Feel free to post questions/proposals/feedback related to the Community Contributions Triage process to the corresponding Slack Channel |
Hi @engcom-Bravo. Thank you for working on this issue.
|
@engcom-Bravo Can you see the product in the category view? The product view always works, regardless of the number of assigned single products. But it's not shown in the category view. |
@magento give me 2.4-develop instance |
Hi @oneserv-heuser. Thank you for your request. I'm working on Magento instance for you. |
Hi @oneserv-heuser, here is your Magento Instance: https://96534a2aa5b56e6ea8efb74e4430643e.instances.magento-community.engineering |
Probably related to this: #28966 (comment) |
@magento give me 2.4-develop instance |
Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you. |
Hi @engcom-Bravo, here is your Magento Instance: https://96534a2aa5b56e6ea8efb74e4430643e.instances.magento-community.engineering |
Hi @oneserv-heuser, Thanks for quick response. We are able to see the product with 560+ configurations in a category view. After adding products to Category view kindly do REINDEXING and CACHEFLUSH. Kindly check your system requirements. Thanks. |
@thlassche You're absolutely right, this is related and applying your patch fixes the issue. Thanks a lot! So, @engcom-Bravo can you please read the thread in #28966 and especially the comment from @thlassche
I think you should be able to reproduce the issue when setting "Yes" for "Use for Sort" for the attributes you're using and/or for the attribute "name". Very unfortunate that the other ticket is closed, even if it's an existing issue which was said by several users. |
To summarize:
That works for any attribute which has "Used for Sorting in Product Listing" set to true, but using "Name" is the easiest way. |
✅ Jira issue https://jira.corp.adobe.com/browse/AC-6443 is successfully created for this GitHub issue. |
✅ Confirmed by @engcom-Bravo. Thank you for verifying the issue. |
@engcom-Bravo Well, the 100 was only to make it as long as possibe to exceed the maximum length of 32766 characters in ElasticSearch with fewer assigned single products. Then just use 64 characters for the name and create more single products. Don't know why you first confirm the issue and then remove the confirmation because of this nonsense 😆 |
Hi @oneserv-heuser, Thanks for quick response. Sorry for cause. we will update as soon as possible. Thanks. |
Hi @oneserv-heuser, Thank you for reporting and collaboration. Verified the issue on Magento 2.4-develop branch and 2.4.5 we are able to reproduce the issue. Kindly refer the screenshots. 1.Set the "Used for Sorting in Product Listing" for the attribute "Name" to true 2.Create a configurable product with a long name (64 characters) and more than 600 single products. After creating a configurable Product we are not able to view the product on category page. Hence confirming the issue. Thanks. |
❌ Cannot export the issue. This GitHub issue is already linked to Jira issue(s): https://jira.corp.adobe.com/browse/AC-6443 |
magento give me 2.4-develop instance |
Preconditions and environment
Steps to reproduce
Expected result
The product is shown on the relevant assigned category page
Actual result
The product is not displayed on the category page and can also not be retrieved via the GraphQl "products" query.
Additional information
With less than 560 configurations the product is shown on the relevant assigned category page. The issue only happens when you have more than 560 (may not be exact number) configurationsThis is a follow up ticket for #35765 where this issue was observed initially.
There you can see that the border was at 350 configurations and that the issue wasn't reproducible anymore at any time on the development Magento version.But the issue is now reproducible in the development Version with 560 single products assigned to the configurable product.
I also tested it locally and viewed the ElasticSearch Index, the product never gets written into the index.
This is a very critical issue for us as we have products with more than 1000 configurations.
UPDATE
As written below, the issue is not the number of single products assigned to a config, it's the maximum field length in ElasticSearch which causes the product not to be indexed. ElasticSearch has a maximum field length of 32766 characters.
When you set "Used for Sorting in Product Listing" to true for the attribute "Name" (this works for all attributes, name is just the easiest for reproducing) all values for "Name" for all single products are written into one field which can exceed the character limit with a lot of single products. Then the product is silently not written into the index and not shown in categories or the search.
For more details see #28966 (comment)
Thanks a lot to @thlassche !
Release note
No response
Triage and priority
The text was updated successfully, but these errors were encountered: