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)
"... to apply for a visa" or "... and applied for a visa"?
How can I protect witches in combat who wear limited clothing?
Keeping a retro style to sci-fi spaceships?
How can I define good in a religion that claims no moral authority?
Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?
Why can't wing-mounted spoilers be used to steepen approaches?
Finding the path in a graph from A to B then back to A with a minimum of shared edges
Why did all the guest students take carriages to the Yule Ball?
Sort a list of pairs representing an acyclic, partial automorphism
Why is superheterodyning better than direct conversion?
How to delete random line from file using Unix command?
Do working physicists consider Newtonian mechanics to be "falsified"?
Netflix Recommendations?
How many people can fit inside Mordenkainen's Magnificent Mansion?
Did the UK government pay "millions and millions of dollars" to try to snag Julian Assange?
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
does high air pressure throw off wheel balance?
Match Roman Numerals
Wall plug outlet change
What is special about square numbers here?
Simulating Exploding Dice
In horse breeding, what is the female equivalent of putting a horse out "to stud"?
Does Parliament hold absolute power in the UK?
Didn't get enough time to take a Coding Test - what to do now?
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;
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
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
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
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
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
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
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
magento-1.9 database database-update
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
asked Aug 19 '15 at 11:56
Jaimie DijstraJaimie Dijstra
96214
96214
bumped to the homepage by Community♦ 12 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♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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:
- 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])
- 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.
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
Interesting approach. Have you tested this on anchor categories as well?
– Steven J
Aug 18 '17 at 18:50
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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:
- 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])
- 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.
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
Interesting approach. Have you tested this on anchor categories as well?
– Steven J
Aug 18 '17 at 18:50
add a comment |
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:
- 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])
- 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.
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
Interesting approach. Have you tested this on anchor categories as well?
– Steven J
Aug 18 '17 at 18:50
add a comment |
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:
- 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])
- 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.
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
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:
- 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])
- 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.
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
answered Aug 22 '15 at 5:23
Jaimie DijstraJaimie Dijstra
96214
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
add a comment |
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
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
