Magento 2 - double ordering in category pageIs it possible to sort Magento sub categories by alphabetical order by default? NOT with mysql sporadicallyHow to create a working custom order for product category page?Magento 2: Products with internal IDs > ~16500 not showing in categoryDisplay specific category, toolbar and filter on home pageMagento 2 : Static blocks with products on category landing pageProduct sort order on category pageMagento 1, Responsive Category Page - Product and Filter LayoutMagento 2 REST API to fetch all the filter attributes based on CategoryOrder Detail page get Order Item Collection When select any order in admin order grid in Magento 2How to customise category top menu navigation by custom category id in Magento 2?

60s or 70s novel about Empire of Man making 1st contact with 1st discovered alien race

How can I make 12 tone and atonal melodies sound interesting?

Analogy between an unknown in an argument, and a contradiction in the principle of explosion

Difference between prepositions in "...killed during/in the war"

A map of non-pathological topology?

Is Lambda Calculus purely syntactic?

Why do radiation hardened IC packages often have long leads?

Can you make an identity from this product?

What is the logic behind charging tax _in the form of money_ for owning property when the property does not produce money?

Possible runaway argument using circuitikz

Does the Nuka-Cola bottler actually generate nuka cola?

Why did Intel abandon unified CPU cache?

Sql Server delete syntax

Why are MBA programs closing in the United States?

Does putting salt first make it easier for attacker to bruteforce the hash?

Please figure out this Pan digital Prince

Java Servlet & JSP simple login

bash vs. zsh: What are the practical differences?

How to publish items after pipeline is finished?

Why was this person allowed to become Grand Maester?

A word that means "blending into a community too much"

Is it okay to have a sequel start immediately after the end of the first book?

TicTacToe classic in C

What aircraft was used as Air Force One for the flight between Southampton and Shannon?



Magento 2 - double ordering in category page


Is it possible to sort Magento sub categories by alphabetical order by default? NOT with mysql sporadicallyHow to create a working custom order for product category page?Magento 2: Products with internal IDs > ~16500 not showing in categoryDisplay specific category, toolbar and filter on home pageMagento 2 : Static blocks with products on category landing pageProduct sort order on category pageMagento 1, Responsive Category Page - Product and Filter LayoutMagento 2 REST API to fetch all the filter attributes based on CategoryOrder Detail page get Order Item Collection When select any order in admin order grid in Magento 2How to customise category top menu navigation by custom category id in Magento 2?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















Some products have custom attribute blue_widget.



On category pages, I want to list all blue_widget poducts that belong to that category first, and then the rest of the products.



However, I want to keep this order regardless of sorting selected by a user. For example: If user sets sorting against price, I want all 'blue_widget' products listed first (sorted by price), and then the rest of products also sorted by price. Same with name sorting.



How to achieve this?



  1. Manipulating with SQL query

  2. Filter returned collection and move blue_widget products to top? How?









share|improve this question






























    0















    Some products have custom attribute blue_widget.



    On category pages, I want to list all blue_widget poducts that belong to that category first, and then the rest of the products.



    However, I want to keep this order regardless of sorting selected by a user. For example: If user sets sorting against price, I want all 'blue_widget' products listed first (sorted by price), and then the rest of products also sorted by price. Same with name sorting.



    How to achieve this?



    1. Manipulating with SQL query

    2. Filter returned collection and move blue_widget products to top? How?









    share|improve this question


























      0












      0








      0








      Some products have custom attribute blue_widget.



      On category pages, I want to list all blue_widget poducts that belong to that category first, and then the rest of the products.



      However, I want to keep this order regardless of sorting selected by a user. For example: If user sets sorting against price, I want all 'blue_widget' products listed first (sorted by price), and then the rest of products also sorted by price. Same with name sorting.



      How to achieve this?



      1. Manipulating with SQL query

      2. Filter returned collection and move blue_widget products to top? How?









      share|improve this question
















      Some products have custom attribute blue_widget.



      On category pages, I want to list all blue_widget poducts that belong to that category first, and then the rest of the products.



      However, I want to keep this order regardless of sorting selected by a user. For example: If user sets sorting against price, I want all 'blue_widget' products listed first (sorted by price), and then the rest of products also sorted by price. Same with name sorting.



      How to achieve this?



      1. Manipulating with SQL query

      2. Filter returned collection and move blue_widget products to top? How?






      magento2 category category-products sorting category-page






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jun 4 at 10:16









      Ahmed Zameer

      1197




      1197










      asked Jun 3 at 13:09









      Pete JaworskiPete Jaworski

      299217




      299217




















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277091%2fmagento-2-double-ordering-in-category-page%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277091%2fmagento-2-double-ordering-in-category-page%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Get product attribute by attribute group code in magento 2get product attribute by product attribute group in magento 2Magento 2 Log Bundle Product Data in List Page?How to get all product attribute of a attribute group of Default attribute set?Magento 2.1 Create a filter in the product grid by new attributeMagento 2 : Get Product Attribute values By GroupMagento 2 How to get all existing values for one attributeMagento 2 get custom attribute of a single product inside a pluginMagento 2.3 How to get all the Multi Source Inventory (MSI) locations collection in custom module?Magento2: how to develop rest API to get new productsGet product attribute by attribute group code ( [attribute_group_code] ) in magento 2

          Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

          Magento 2.3: How do i solve this, Not registered handle, on custom form?How can i rewrite TierPrice Block in Magento2magento 2 captcha not rendering if I override layout xmlmain.CRITICAL: Plugin class doesn't existMagento 2 : Problem while adding custom button order view page?Magento 2.2.5: Overriding Admin Controller sales/orderMagento 2.2.5: Add, Update and Delete existing products Custom OptionsMagento 2.3 : File Upload issue in UI Component FormMagento2 Not registered handleHow to configured Form Builder Js in my custom magento 2.3.0 module?Magento 2.3. How to create image upload field in an admin form