Hello Magento pals <\/p>\n\n\n\n
Ever faced an error in Magento that says: “Text Fields are Not Optimised for Operations”<\/strong><\/em>?<\/p>\n\n\n\n Magento<\/a> continuously releases regular updates that add amazing features and enhance the store’s performance. However, sometimes these upgrades also come with some technical bugs that can hamper the store’s performance. One such elastic search bug in the Magento 2.4 release<\/a> line is causing issues on the product category page. Many of the store owners reported the products aren’t loaded on the category page and the following error in the exception.log file is generated:<\/p>\n\n\n\n “Text fields are not optimized for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead.”<\/p>\n\n\n\n In this blog post, I will provide a complete solution to solve this issue in Magento 2.4.x.<\/p>\n\n\n\n In Magento 2.4.x, the product listing issue on the category page or the ‘Text fields are not optimized for operations’ error is caused when a varchar or text field is set to filterable in elastic search. This can be solved by finding the error-causing attribute and disabling the filterable in search for that attribute.<\/p>\n\n\n\n You can run the following query to find those attributes:<\/p>\n\n\n\n Running the above query will list down all the varchar attributes that are set to ‘filterable in search’.<\/p>\n\n\n\n Once you find the attributes that are causing the ‘Text Fields are Not Optimized for Operations’ issue, you can disable them using the following query:<\/p>\n\n\n\n That\u2019s it.<\/p>\n\n\n\n Recently I posted a solution to cluster block exception in Magento 2<\/a>, which you may also love to read. You can also configure Elasticsearch in Magento 2<\/a> to use its features like an open-source, readily-scalable, analytics, broadly-distributable, etc.<\/p>\n\n\n\n If you have any doubts or queries, please feel free to comment. I\u2019d be happy to help you. <\/p>\n\n\n\n Also, I\u2019d be grateful if you could share the solution with the Magento community via social media. <\/p>\n\n\n\n Thank you. <\/p>\n\n\n\n Also read:<\/strong><\/p>\n\n\n\nMethod to Solve Magento 2.4.x Elastic Search Error: Text Fields are Not Optimised for Operations<\/strong><\/h2>\n\n\n\n
SELECT\n cea.*\nFROM\n catalog_eav_attribute cea\nJOIN\n eav_attribute ea ON cea.attribute_id = ea.attribute_id\nWHERE\n cea.is_filterable_in_search = 1\n AND ea.entity_type_id = 4\n AND ea.backend_type = 'varchar';<\/pre>\n\n\n\n
UPDATE\n catalog_eav_attribute cea\nJOIN\n eav_attribute ea ON cea.attribute_id = ea.attribute_id\nSET\n cea.is_filterable_in_search = 0\nWHERE\n ea.entity_type_id = 4\n AND ea.backend_type = 'varchar';<\/pre>\n\n\n\n