Magento export/import category product sort order The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How to map data from AutoQuotes Catalog Data Export to Magento Standard Products File to Import?Magento export returns a blank screenImporting URL Rewrites Directly to Database is successful but not showing in admin nor working on the frontendMagento product CSV sheet is not import, just show loading imageSpecial characters stripped off while saving data in DB through raw sql_queryexport/import categoriesIssue with magento 1.9 config product import: “Product with specified super products SKU not found”Magento 2: Data Migration From Non Magento Database to Magento DatabaseMagento2 - How to Export mysql database without products,orders and customers data?Moving Live database to a staging Server (M1)

does high air pressure throw off wheel balance?

Why does the Event Horizon Telescope (EHT) not include telescopes from Africa, Asia or Australia?

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

Difference between "generating set" and free product?

How are presidential pardons supposed to be used?

What can I do if neighbor is blocking my solar panels intentionally?

How do you keep chess fun when your opponent constantly beats you?

How many people can fit inside Mordenkainen's Magnificent Mansion?

What was the last x86 CPU that did not have the x87 floating-point unit built in?

Sort a list of pairs representing an acyclic, partial automorphism

What is this lever in Argentinian toilets?

University's motivation for having tenure-track positions

Segmentation fault output is suppressed when piping stdin into a function. Why?

How to split my screen on my Macbook Air?

The variadic template constructor of my class cannot modify my class members, why is that so?

How to test the equality of two Pearson correlation coefficients computed from the same sample?

Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?

How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?

Simulating Exploding Dice

Do working physicists consider Newtonian mechanics to be "falsified"?

I could not break this equation. Please help me

ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?

What do you call a plan that's an alternative plan in case your initial plan fails?



Magento export/import category product sort order



The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How to map data from AutoQuotes Catalog Data Export to Magento Standard Products File to Import?Magento export returns a blank screenImporting URL Rewrites Directly to Database is successful but not showing in admin nor working on the frontendMagento product CSV sheet is not import, just show loading imageSpecial characters stripped off while saving data in DB through raw sql_queryexport/import categoriesIssue with magento 1.9 config product import: “Product with specified super products SKU not found”Magento 2: Data Migration From Non Magento Database to Magento DatabaseMagento2 - How to Export mysql database without products,orders and customers data?Moving Live database to a staging Server (M1)



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








0















I am looking for an easy way to be able to quickly update the product sort order on any category page via export or import. I have looked into several extensions but have been limited due to the issue of having 1000's of products per category which by default would result in a csv with over 150,000 characters in a particular cell. Even if I do find an extension it will take about the same amount of time to organize the data for import than if I was to organize data for a direct import into a database via a correctly formatted csv (I dare say!).



I am familiar with MySQL and phpMyAdmin and I am very comfortable with exporting and importing directly into it, and even more comfortable with triple checking data before importing for precise characters etc, but I am not so familiar with Magento's database handling and the indexing.



Is it viable to export the "catalog_category_product" table and amend for re-import and does any one know if there would be any other tables involved in this? Or which tables? And any further steps apart from a backup(!).










share|improve this question














bumped to the homepage by Community 4 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.





















    0















    I am looking for an easy way to be able to quickly update the product sort order on any category page via export or import. I have looked into several extensions but have been limited due to the issue of having 1000's of products per category which by default would result in a csv with over 150,000 characters in a particular cell. Even if I do find an extension it will take about the same amount of time to organize the data for import than if I was to organize data for a direct import into a database via a correctly formatted csv (I dare say!).



    I am familiar with MySQL and phpMyAdmin and I am very comfortable with exporting and importing directly into it, and even more comfortable with triple checking data before importing for precise characters etc, but I am not so familiar with Magento's database handling and the indexing.



    Is it viable to export the "catalog_category_product" table and amend for re-import and does any one know if there would be any other tables involved in this? Or which tables? And any further steps apart from a backup(!).










    share|improve this question














    bumped to the homepage by Community 4 mins ago


    This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

















      0












      0








      0








      I am looking for an easy way to be able to quickly update the product sort order on any category page via export or import. I have looked into several extensions but have been limited due to the issue of having 1000's of products per category which by default would result in a csv with over 150,000 characters in a particular cell. Even if I do find an extension it will take about the same amount of time to organize the data for import than if I was to organize data for a direct import into a database via a correctly formatted csv (I dare say!).



      I am familiar with MySQL and phpMyAdmin and I am very comfortable with exporting and importing directly into it, and even more comfortable with triple checking data before importing for precise characters etc, but I am not so familiar with Magento's database handling and the indexing.



      Is it viable to export the "catalog_category_product" table and amend for re-import and does any one know if there would be any other tables involved in this? Or which tables? And any further steps apart from a backup(!).










      share|improve this question














      I am looking for an easy way to be able to quickly update the product sort order on any category page via export or import. I have looked into several extensions but have been limited due to the issue of having 1000's of products per category which by default would result in a csv with over 150,000 characters in a particular cell. Even if I do find an extension it will take about the same amount of time to organize the data for import than if I was to organize data for a direct import into a database via a correctly formatted csv (I dare say!).



      I am familiar with MySQL and phpMyAdmin and I am very comfortable with exporting and importing directly into it, and even more comfortable with triple checking data before importing for precise characters etc, but I am not so familiar with Magento's database handling and the indexing.



      Is it viable to export the "catalog_category_product" table and amend for re-import and does any one know if there would be any other tables involved in this? Or which tables? And any further steps apart from a backup(!).







      magento-1.9 database database-update






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Aug 19 '15 at 11:56









      Jaimie DijstraJaimie Dijstra

      96214




      96214





      bumped to the homepage by Community 4 mins ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







      bumped to the homepage by Community 4 mins ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.






















          1 Answer
          1






          active

          oldest

          votes


















          0














          I don't like answering my own questions, but here goes! Just a different approach to sorting the products and making it more manage-able helped.
          My steps:



          1. Disable the category sort order's ordering on the front end view (remove "position" from the sort order thanks to this nice post [http://prattski.com/2009/11/30/magento-how-to-remove-the-position-sort-option/][1])

          2. Add a new Attribute for all products not visible/search-able etc, just sort-able and give that a label such as "Default".

          The new attribute is easily changed along with all the other product data via magento's import/export data-flow profiles.
          The only set back is to have a reminder that if you update your theme, to go and repeat step 1 above.






          share|improve this answer























          • Interesting approach. Have you tested this on anchor categories as well?

            – Steven J
            Aug 18 '17 at 18:50











          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%2f79198%2fmagento-export-import-category-product-sort-order%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          I don't like answering my own questions, but here goes! Just a different approach to sorting the products and making it more manage-able helped.
          My steps:



          1. Disable the category sort order's ordering on the front end view (remove "position" from the sort order thanks to this nice post [http://prattski.com/2009/11/30/magento-how-to-remove-the-position-sort-option/][1])

          2. Add a new Attribute for all products not visible/search-able etc, just sort-able and give that a label such as "Default".

          The new attribute is easily changed along with all the other product data via magento's import/export data-flow profiles.
          The only set back is to have a reminder that if you update your theme, to go and repeat step 1 above.






          share|improve this answer























          • Interesting approach. Have you tested this on anchor categories as well?

            – Steven J
            Aug 18 '17 at 18:50















          0














          I don't like answering my own questions, but here goes! Just a different approach to sorting the products and making it more manage-able helped.
          My steps:



          1. Disable the category sort order's ordering on the front end view (remove "position" from the sort order thanks to this nice post [http://prattski.com/2009/11/30/magento-how-to-remove-the-position-sort-option/][1])

          2. Add a new Attribute for all products not visible/search-able etc, just sort-able and give that a label such as "Default".

          The new attribute is easily changed along with all the other product data via magento's import/export data-flow profiles.
          The only set back is to have a reminder that if you update your theme, to go and repeat step 1 above.






          share|improve this answer























          • Interesting approach. Have you tested this on anchor categories as well?

            – Steven J
            Aug 18 '17 at 18:50













          0












          0








          0







          I don't like answering my own questions, but here goes! Just a different approach to sorting the products and making it more manage-able helped.
          My steps:



          1. Disable the category sort order's ordering on the front end view (remove "position" from the sort order thanks to this nice post [http://prattski.com/2009/11/30/magento-how-to-remove-the-position-sort-option/][1])

          2. Add a new Attribute for all products not visible/search-able etc, just sort-able and give that a label such as "Default".

          The new attribute is easily changed along with all the other product data via magento's import/export data-flow profiles.
          The only set back is to have a reminder that if you update your theme, to go and repeat step 1 above.






          share|improve this answer













          I don't like answering my own questions, but here goes! Just a different approach to sorting the products and making it more manage-able helped.
          My steps:



          1. Disable the category sort order's ordering on the front end view (remove "position" from the sort order thanks to this nice post [http://prattski.com/2009/11/30/magento-how-to-remove-the-position-sort-option/][1])

          2. Add a new Attribute for all products not visible/search-able etc, just sort-able and give that a label such as "Default".

          The new attribute is easily changed along with all the other product data via magento's import/export data-flow profiles.
          The only set back is to have a reminder that if you update your theme, to go and repeat step 1 above.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Aug 22 '15 at 5:23









          Jaimie DijstraJaimie Dijstra

          96214




          96214












          • Interesting approach. Have you tested this on anchor categories as well?

            – Steven J
            Aug 18 '17 at 18:50

















          • Interesting approach. Have you tested this on anchor categories as well?

            – Steven J
            Aug 18 '17 at 18:50
















          Interesting approach. Have you tested this on anchor categories as well?

          – Steven J
          Aug 18 '17 at 18:50





          Interesting approach. Have you tested this on anchor categories as well?

          – Steven J
          Aug 18 '17 at 18:50

















          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%2f79198%2fmagento-export-import-category-product-sort-order%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

          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

          How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

          Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її