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

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

          Circuit construction for execution of conditional statements using least significant bitHow are two different registers being used as “control”?How exactly is the stated composite state of the two registers being produced using the $R_zz$ controlled rotations?Efficiently performing controlled rotations in HHLWould this quantum algorithm implementation work?How to prepare a superposed states of odd integers from $1$ to $sqrtN$?Why is this implementation of the order finding algorithm not working?Circuit construction for Hamiltonian simulationHow can I invert the least significant bit of a certain term of a superposed state?Implementing an oracleImplementing a controlled sum operation

          Magento 2 “No Payment Methods” in Admin New OrderHow to integrate Paypal Express Checkout with the Magento APIMagento 1.5 - Sales > Order > edit order and shipping methods disappearAuto Invoice Check/Money Order Payment methodAdd more simple payment methods?Shipping methods not showingWhat should I do to change payment methods if changing the configuration has no effects?1.9 - No Payment Methods showing upMy Payment Methods not Showing for downloadable/virtual product when checkout?Magento2 API to access internal payment methodHow to call an existing payment methods in the registration form?